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

[Andy Gaunt]

Ankur -

How about a look at your code, then we may be able to help.


Andy Gaunt
T: 407.810.4722
andy at fmpug.com
http://www.fmpug.com    

Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award

For chapter locations, dates & times please visit the website at
http://www.fmpug.com If you can make it to a meeting, please RSVP at
http://www.fmpug.com/rsvp.php

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Ankur Goyal
Sent: Wednesday, January 25, 2006 3:18 PM
To: FX.php Discussion List
Subject: [FX.php List] FindAll search is slow !!

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