A question about PHP and Mysql
| From: | Alex zhang | Date: | Thu, 06 Apr 2000 14:16:40 +0000 |
| Subject: | A question about PHP and Mysql | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-13226@lists.php.net to get a copy of this message | ||
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