>>>>> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
>>>>> wrote the following on Mon, 4 Jun 2001 13:41:08 +0300 (EEST)
SM> One more thing.
SM> Can you try to run ANALYZE TABLE on sequence_data and see if
SM> that changes anything ...
I got the
+----------------------+---------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------+---------+----------+----------+
| sqmail.sequence_data | analyze | status | OK |
+----------------------+---------+----------+----------+
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 converts BETWEEN to standard comparisons
anyway.
--
Ben Escoto
---------------------------------------------------------------------
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
