Re: [PHP-DB] 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 fir

[PHP-DB] Pulling a long list of data stalls PHP

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) w