RE: [PHP4BETA] A question about PHP and Mysql

That's more than I have ever counted. But you might try counting on a single column: select count(a) from tablea where a='tom'; Or trying using EXPLAIN (see http://www.mysql.com/php/manual.php3?section=EXPLAIN). good luck! michael -----Original Message----- From: Alex zhang [mailto:cd_av2av2@yahoo.com] Sent: Thursday, April 06, 2000 7:17 AM To: php4beta@lists.php.net Subject: [PHP4BETA] A question about PHP and Mysql Hi, Maybe this should be a question about Mysql.But I met them in my PHP code. For too big table in Mysql ex 3 million rows, even you added index for some field , it is very slow to count rows.Like this select count(*) from tablea where a='tom'; I have index for "a" field.But it always took about 5-7 seconds to finish such query. Who has idea about that? thankx in advance Alex __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- PHP 4.0 Beta Mailing List <http://www.php.net/version4/> To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net For additional commands, e-mail: php4beta-help@lists.php.net To contact the list administrators, e-mail: php4beta-admin@lists.php.net