php4-beta | 200004

[PHP4BETA] A question about PHP and Mysql From: Alex zhang (cd_av2av2 <email protected>)
Date: 04/06/00

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 <email protected>
For additional commands, e-mail: php4beta-help <email protected>
To contact the list administrators, e-mail: php4beta-admin <email protected>