Mysql is really slow!

--- Chris Adams <chris@digitaria.com> 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