[FX.php List] FindAll search is slow !!

[Jason H Awbrey]

To expand on Derrick's statement, I've noticed speed issues with  
files that have complex relational structures, i.e. multi-predicate  
relationships and the like, causing similar problems. The problem  
lies with FileMaker, not FX.php. If you perform the XML query against  
FileMaker you'll probably notice a time delay in the returned  
dataset. Simplification, like Derrick said, is the key -- not only in  
limiting what FM is returning, but through what relationships FM is  
returning data.

HTH,
Jason

~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Jason Awbrey
Web Integration
FileMaker 7 Certified Developer
Harmonic Data Associates
http://www.harmonic-data.com
jawbrey at harmonic-data.com
~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~



On Jan 25, 2006, at 2:46 PM, Derrick Fogle wrote:

> The overhead is probably in the transfer of the data out of FMP  
> into PHP. How many fields do you have, and how much data is in, the  
> fields on the layout you are using? Make sure your layout doesn't  
> have any more fields or data than absolutely necessary.
>
> I've got a DB with nearly 100,000 records in it. A search and  
> return of 100 records is nearly instant. A return of 5,000 records  
> takes 10-15 seconds. A return of 25,000 records takes about a minute.
>
> I've only got 5 fields on the layout, and each total record size  
> averages about 50 characters, with an max of about 300 characters.
>
> On Jan 25, 2006, at 2:18 PM, Ankur Goyal wrote:
>
>> Hi,
>>
>> I have a database with 7250 records. I have a search page with a  
>> set of fields, when I do a search on a specific field, the results  
>> come pretty fast, but when I do a "find all" search, it is really  
>> slow !! (sometimes take 1-2 mins)
>> I checked the database, and "Find All" search is pretty fast  
>> there ...so I am not sure, if my PHP code is making things slow !!
>> Once I get the data from the database, I'm doing a set of  
>> calculations with PHP in-order to display that data in a specific  
>> way to my users.
>>
>> Please provide me some guidance/recommendation...I am not sure,  
>> what's making it slow ??
>>
>> Thanks !
>>
>> Ankur
>> _______________________________________________
>> 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
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list