[FX.php List] Slow after upgrading to FMP12

[Malcolm Fitzgerald]

Have you tried putting the search field ( ticket layout -> assigned portal -> user -> related group name ) on a layout without a portal? 

malcolm


On 27/08/2013, at 12:35 PM, Nick wrote:

> I've found layouts with portals on them to be orders of magnitude slower than doing multiple finds on simple layouts... this isn't something necessarily related to 12, only just more noticeable.  to try it, put a portal that has related data two deep (like a total of 3 relationships deep) and do a search on the 3rd deep... it's horribly slow heh.
> 
> like, ticket layout -> assigned portal -> user -> related group name
> 
> also, using ip address instead of domain name saves a couple hundred milliseconds per request.. at least in my environment.
> 
> 
> On Mon, Aug 26, 2013 at 11:16 AM, Chris Hansen <chris at iviking.org> wrote:
> Stephen,
> 
> Are you using "fmalt" as the datasource type?  If so, that might be it.  The XML schema used there is much more verbose than that used by default elsewhere.
> 
> FYI, this is the same schema used by the FileMaker API for PHP.  I think that's at least part of the reason that FX.php has historically been a bit faster.
> 
> Best,
> 
> --Chris
> 
> On Aug 23, 2013, at 6:33 AM, Stephe Pocock <zippyaus at yahoo.com> wrote:
> 
>> Hi all
>> 
>> I finally took the plunge and migrated to FMP12.
>> 
>> I have installed the latest fx.php and removed all the references to the FM7 extension from my database names.
>> 
>> Since migration we have found the fx.php integrations considerable slower than FM11.
>> 
>> Are there any gotchas that I have missed?
>> 
>> Is it worth exploring the native filemaker php integration?
>> 
>> Thanks for any input.
>> 
>> Stephen
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20130827/6123659a/attachment.html