Re: [GENERAL] Massive slowdown when LIMIT applied

2006-08-22 Thread macgillivary
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

Re: [GENERAL] Massive slowdown when LIMIT applied

2006-08-16 Thread Tom Lane
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) >