hi!
>>>>> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: Jeremy> On Fri, Jan 18, 2002 at 12:40:00AM -0800, Simon Kirby wrote: >> >> MySQL appears to be having problems walking backwards on the index when >> starting from a known row. >> >> On the web documentation, it looks like this is supposed to work: Jeremy> [snip] >> Does anybody have any ideas? :) MySQL 3.23.46, by the way. 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. Regards, Monty --------------------------------------------------------------------- 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