RE: [PHP-DB] MySQL Performance

Are you just grouping them into categories? If so, perhaps you need to do the 1 query and parse the returned data a bit more.. (ie, compare the current category and the previous one, if differnt print a header) it also depends on whether you are closing/opening connections to mysql each time.. But with 120 entries that does sound a tad slow. > -----Original Message----- > From: Manuel Trunk [mailto:trunk@explain.de] > Sent: Monday, May 15, 2000 14:31 > To: php-db@lists.php.net > Subject: [PHP-DB] MySQL Performance > > > I use a "Select * from Table order by ..." Statement several (31) > times and > MySQL takes about one minute to do this. The Table consists of 120 entrys > (text) . What could that be? > > > -- > 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 >