[FX.php List] Retrieving data from multiple layouts?

[Derrick Fogle]

Putting all the fields that you do need on one layout, and calling it  
once, should be much faster than multiple calls to multiple layouts.  
The initial data return might take a lot longer, but 99% of  slowness  
in FM-backed transactions is in FM feeding the data to PHP. Depending  
on the hardware, there's probably at least a 1/2 second overhead for  
even the smallest FMFind() call. More data slows it down more.  
Depending on the amount of data, you might have to crank up your  
timeout setting for PHP.

You can literally copy all the elements from all 7 layouts (if they  
are all from the same DB) and paste the whole mess on a single  
layout. Remove any fields, graphics, or anything else that isn't  
absolutely necessary to deliver the data, from your super-layout.

On Aug 28, 2006, at 8:01 AM, Dr. Andrew J. Fallon wrote:

> I have been working on a script for a FMP6 DB that parses the  
> database and retrieves certain field data that I am uploading to a
>
> MySQL server. My script works fine but what I have noticed is it  
> takes a long time. The reason being, I believe is that I need to
>
> Iterate through the main file many times getting the data I need  
> from different layouts. (The main file contains over 300 layouts,
>
> I need data from about 7). I am loathe to do a SetDBData(‘Main’,  
> ‘’, ‘ALL’) as this would most certainly destroy any sense of
>
> Speed or efficiency. Is there a way to use SetDBData with multiple  
> layouts?
>
>
>
> Drew
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.11.6/428 - Release Date:  
> 8/25/2006
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


Derrick Fogle
derrick at fogles.net