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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php