+
message, but everything is the same as before (query still takes a
long time and explain says it is still using filesort).
JDZ> What about if you use BETWEEN()?
JDZ> I meant to suggest that earlier, too, but I, uh... forgot.
Sorry, no dice. It probably con
headers ORDER BY id DESC LIMIT 10;
JDZ> Did you try (sid > 15 and sid < 17), or something that means
JDZ> the same thing as (sid = 16) if sid is an int?
JDZ> Don't know if it'll help, but you never know.
r index, for instance called
negative_id that is always (4294967296 - id) or something like that,
so I can ORDER BY negative_id instead of ORDER BY id DESC?
Thank you for any advice or suggestions you might have.
--
Ben Escoto
---
Hi, I think I found a bug in mysql. I tried the mysqlbug thing but it
didn't work right away. I hope this message will be detailed enough.
I am not subscribed to the mailing list.
In the following sections are the output of, respectively:
mysql -e "SHOW VARIABLES"
mysqldump sqmail sequence
