Re: Massive slowdown when LIMIT applied

Purely out of curiosity, what sort of execution time do you get if you
use:

SELECT *
FROM (SELECT username,acctstarttime FROM radacct WHERE username='user'

ORDER BY acctstarttime ) allstarttimes
LIMIT 50;


Graeme Hinchliffe wrote:
>
> Now, if I do the following:
>
> SELECT username,acctstarttime FROM radacct WHERE username='user'
> ORDER BY acctstarttime LIMIT 50;
>
> I have to wait a very long time, IE instead of 2-3 seconds.. can be
> as slow as 10+ minutes.