On Sat, Jan 26, 2002 at 07:06:57PM +0200, Michael Widenius wrote: > Jeremy> I think that the "walking backwards" optimizations were introduced > Jeremy> in the MySQL 4.0 tree. > > That's correct. Simon, could you please download MySQL 4.0.1 and try > if this works better for you. > > We shall also add the ORDER BY DESC on an index to the MySQL benchmark > suite to clearly show this difference between 3.23 and 4.0. > > The things we need to tests are: > > ... WHERE key_prefix BETWEEN # and # ORDER BY key_prefix DESC > > with one and two key parts. We also need to execute the same queries > without DESC to get an comparison of this.
Yes, MySQL 4.0.1 appears to walk backwards on the index properly, and all queries are fast as expected. Great! Thanks, Simon- [ Stormix Technologies Inc. ][ NetNation Communications Inc. ] [ [EMAIL PROTECTED] ][ [EMAIL PROTECTED] ] [ Opinions expressed are not necessarily those of my employers. ] --------------------------------------------------------------------- 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
