Hi!
Steven == Steven Roussey [EMAIL PROTECTED] writes:
... WHERE key_prefix BETWEEN # and # ORDER BY key_prefix DESC
Steven What about
Steven ... WHERE key_part1 = xxx ORDER BY key_part2 DESC
This is already fixed in MySQL 4.0.2 source tree; 4.0.2 should be out
within a couple of weeks.
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
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
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