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

[Derrick Fogle]

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