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