[Toolserver-announce] Query time limiter

River Tarnell river.tarnell at wikimedia.de
Thu Aug 12 13:08:30 UTC 2010


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I've just added a new feature to the automated query killer which can be used 
to limit the execution time of queries.

To use it, include the string LIMIT:<n> in your query.  For example:

  SELECT /* LIMIT:60 */ * FROM ...

would limit the query execution time to 60 seconds.

This could be used in web tools to prevent excessively long page load times 
(where the user will gave given up by the time the query finishes), or as a 
sanity check on queries which usually finish quickly, but sometimes take too 
long.

	- river.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (FreeBSD)

iEYEARECAAYFAkxj8k4ACgkQIXd7fCuc5vJQWwCfaVYnSWoxSmEd8HesFcfUikeH
dLsAn3sgbrnXQwpeGoyys48fad+gbQKO
=HE6k
-----END PGP SIGNATURE-----



More information about the Toolserver-announce mailing list