Re: Descending indexes not working?

2002-01-26 Thread Simon Kirby
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

Descending indexes not working?

2002-01-05 Thread Simon Kirby
Hello all, I'm working on a photo album engine where a few MySQL queries find which thumbnails that should be around the image queried (in order of time). I ended up starting with a query to get the time, filename, etc., of the requested image, and then one query for images before and one query