Add parameters for limit duration of queries
--------------------------------------------
Key: CORE-3755
URL: http://tracker.firebirdsql.org/browse/CORE-3755
Project: Firebird Core
Issue Type: Improvement
Reporter: Pavel Zotov
For the purposes of performance and scaling applications it would be useful to
have the following options in the firebird.conf:
1) "own" #KeepAliveTime = 90 (seconds), independent of OS' settings and applies
only to the work of the Firebird. The default value of this parameter in
Windows (2 hours) is completely unacceptable for daily practice. Firebird use
this parameter for permanent checking is client alive or not. If client is dead
all activity for his connect will be immediatelly terminated.
2) #MaxQueryExecutionTime = 900 (seconds) limits the maximum duration of any
request, regardless of the client state (i.e. is it alive or dead). This
parameter is not affected for transactions with SNAPSHOT isolation level cause
it is often used for reporting purpuses.
3) #MaxGarbageTimeForTrancaction = 900 (seconds) limits the maximum duration of
any transaction can make garbage collection. Currently some 'ill-fated'
transaction that has been started just after bulk deletetion will collect
garbage infinite time.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
