[FX.php List] Re-That sinking feeling: FileMaker 12 & FX ?

[Dale Bengston]

Bob,

I think the answer is "it depends." The inclusion of any portals or even related fields on a layout affects performance more and more as the record count goes up. At some point, that time hit passes the extra time needed for a separate query.

Dale

On May 9, 2012, at 9:43 AM, Bob Patin wrote:

> 
> On May 9, 2012, at 9:29 AM, BEVERLY VOTH wrote:
> 
>> I just never caught this in fm12. I make my "related" queries rather than using portals. I guess that's why?!
>> 
>> Let's hope it gets ESCALATED to 'fixed', Dale. :)
> 
> That's what I've always done as well, except for when there's a related field on a layout (not a portal, just a single related field); I've never compared speeds between the two, however. Has anyone ever compared the speed between doing a 2nd query and pulling the desired related records, versus pulling the related records from a portal on the web layout?
> 
> Seems like we talked about this a while back, but I forget now what the consensus was...
> 
> 
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> FileMaker 9, 10 & 11 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --
> Twitter: bobpatin
> Google+: http://www.longtermsolutions.com/plus
> AIM: longterm1954
> iChat: bobpatin
> --
> Expert FileMaker Consulting 
> FileMaker Hosting for all versions of FileMaker
> 
> _______________________________________________
> 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/20120509/4b0c89cb/attachment-0001.html