[FX.php List] FM Scripts vs. PHP

Bob Patin bob at patin.com
Thu Oct 25 20:14:53 MDT 2007

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
Member of FileMaker Business Alliance and FileMaker TechNet

      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 •  

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

More information about the FX.php_List mailing list