-----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.