php4-beta | 200004

[PHP4BETA] Mysql is really slow! From: Alex zhang (cd_av2av2 <email protected>)
Date: 04/07/00

--- Chris Adams <chris <email protected>> wrote:
> On Thu, 6 Apr 2000 13:05:45 -0700 (PDT), Alex zhang
> wrote:
>
> >I have tried it and checked it with Explain(looks
> >right). Same result.
> >It acturally occurs when you have too much entries
> >return in big tables
> >pls try!
> >Anyway, thanks
>
> What version of MySQL are you using & have you used
> any configuration. I made
> a quick test with Mysql 3.22.34 for NT on my desktop
> with the following
> config options:
>
> set-variable = key_buffer=16M
> set-variable = max_allowed_packet=1M
> set-variable = thread_stack=128K
> set-variable = flush_time=1800
>
> Here's the simple table I used:
> +-------+---------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +-------+---------+------+-----+---------+-------+
> | ID | int(11) | | PRI | 0 | |
> +-------+---------+------+-----+---------+-------+
>
>
> mysql> select count(*) from Count_Test;
> +----------+
> | count(*) |
> +----------+
> | 3639820 |
> +----------+
> 1 row in set (0.00 sec)
>
> Obviously, this doesn't look like some intrinsic
> problem with MySQL; I'd
> check the details of your configuration.
>
>
> cut
Yes , I found if you used simple query like this
    select count(*) from Count_Test
It is fast , no matter how big the table is.
But if you use query like this
  select count(*) from Count_Test where "xxxx";
and make sure the number of the return rows
is more than 1000000,You will find the same result
(too slow) with me.
Thanx

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>