Re: MySQL 3.23.44 not using indexes

[Jeremy Zawodny]

On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote:

[snip]

> In a case like this (where so many rows are covered by the index)
> it's not self evident that a table scan is not faster than an index
> scan.
> 
> Especially with many users using the key cache at the same time, a
> table scan is likely to use less resources from the system.
x
That reminds me.  A while back (9 months, maybe), I seem to remember
you discussion a re-write of the key cache so that it would use a more
locking strategy.

Is that supposed to happen in 4.0.x?  I don't recall having seen a
commit that affected the key cache yet.

Thanks!

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/