[FX.php List] FM Scripts vs. PHP

[Bob Patin]

I'm not sure whether it's faster or not, but I've also done separate  
queries for child records.

I learned the FileMaker API a while back, and although it'll write to  
related records directly, I suspect I'll still use the same method of  
doing multiple queries.

I'd be interested in any testing that would show the speed difference  
between a page with a single query, where a record is pulled in and  
some child records, versus a page that does 2 queries--the parent and  
then the child records. Does anyone hae any actual stats on this?  
Might be really interesting...

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
Member of FileMaker Business Alliance and FileMaker TechNet

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060

--------------------------
Contact us for FileMaker hosting for all versions of FileMaker
PHP • CDML • Full email services • Free DNS hosting • Colocation •  
Consulting


On Oct 25, 2007, at 8:45 PM, Dale Bengston wrote:

> I stopped using related fields on layouts back with v6. My  
> anecdotal experience tells me it's faster to go get the data from  
> the child records from a separate, optimized layout than to pull it  
> through the parent record.
>
> Other databases don't have such things as portals, so it's all done  
> with separate queries. MySQL is heaps faster than FMSA for  
> everything we've thrown at it.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20071025/3914d504/attachment.html