Re: Pulling a long list of data stalls PHP

Is your table indexed on the field your query is based on? That will greatly speed up the query. Miles Thompson At 11:32 AM 1/7/2002 -0500, Peter Westergaard wrote:

Hi, I'm attempting to pull about 300 rows from a mysql database, (all rows in the table). I can pull the first 10, the first 20, the first 30, no problem. (using LIMIT (start), (10|20|30)... in the SQL statement) But if I attempt to pull all of them (no LIMIT clause), or even the first (x) where (x) is much more than 30, using a simple while (mysql_fetch_row($sql,$db))... construction, IE just idles, tells me it is loading the page, and never displays anything. When I press "STOP", I have a hung PHP process in my Task Manager, which I cannot kill! Does anyone know what could cause this behaviour? It seems so simple, what I'm trying to do, that I'm going insane. Very frustrated. Please, someone help a poor newbie out! -P -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net