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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
