1.

How To Specify Transaction Or Query Timeout?

Answer»

In ORDER to keep the server low reasonable, you might want to LIMIT the time a single query can consume. Firebird does not support this directly YET (there are plans for Firebird 3.0).

However, you could periodically query the monitoring TABLES to detect and CANCEL long running queries. You can do:

SELECT * FROM MON$STATEMENTS:
Look for those having MON$STATE set to 1.

In order to keep the server low reasonable, you might want to limit the time a single query can consume. Firebird does not support this directly yet (there are plans for Firebird 3.0).

However, you could periodically query the monitoring tables to detect and cancel long running queries. You can do:

SELECT * FROM MON$STATEMENTS:
Look for those having MON$STATE set to 1.


Discussion

No Comment Found

Related InterviewSolutions