Re[2]: Bad count(*) perfermance on index.

2002-01-25 Thread Artem V. Ryabov
Hello Jeremy, Friday, January 25, 2002, 11:00:43 AM, you wrote: >> Why query type >> >> select count(*) from table_name where key_field between 'min' and >> 'max' so slow? >> >> example: >> >> mysql> select count(*) from Textes where ID between 7937 and 45061; >> +--+ >> | count(*) | >

Re: Bad count(*) perfermance on index.

2002-01-24 Thread Jeremy Zawodny
On Wed, Jan 23, 2002 at 02:32:49PM +0300, Artem V. Ryabov wrote: > Hello mysql, > > Why query type > > select count(*) from table_name where key_field between 'min' and > 'max' so slow? > > example: > > mysql> select count(*) from Textes where ID between 7937 and 45061; > +--+ > | count