RE: Speed problem with sorted select statements

2002-01-28 Thread Roger Baklund
* [EMAIL PROTECTED] > Description: > I try to get the last 5 different times and the first 5 > different times. There is a difference of aproximately > 1 minute and 40 seconds between this to queries. I do not see > reason for the difference in the execution times. There is a problem in some case

Speed problem with sorted select statements

2002-01-28 Thread Denny . Fritzsche
NULL | 3418459 | where used; Using index; Using temporary; Using filesort | +---+---+-+--+-+ --+-+----------+ 1 row in set (0.00 sec) Fix: Synopsis: Speed problem with sorted select statements Sub