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
Graeme Hinchliffe <[EMAIL PROTECTED]> writes:
> If I do the following:
> SELECT username,acctstarttime FROM radacct WHERE username='user'
> ORDER BY acctstarttime;
> again the results come up slightly slower as would be expected but
> still very quickly.. (a few hundred rows in this case)
>