[Toolserver-l] Please use LIMIT for sql-queries of webtools

[DaB.]

Hello all,

the last days when the replag on s3 was high, I looked for long-running-querys 
from time to time. I noticed, that many queries which are run from inside of 
webtools (like editcounters) had no LIMIT (see [1]). This is bad – no user 
waits 5000s or more for a result and he/she is long go when the query still 
needs resources (and at the end the result is abject). So please use a LIMIT 
for your querys – even if they are fast for normal (the LIMIT doesn't hurt 
then).
Please don't confuse this with the SQL-command LIMIT (which you should also 
use if possibe ;-)).

Sincerly,
DaB.

[1] https://wiki.toolserver.org/view/Database_access#Query_time_limits

-- 
Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
Url : http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20110812/965621f6/attachment.pgp