On 18-8-2016 17:51, Dimitry Sibiryakov wrote: > On the other hand it provides DBA a choice, not kill the query > unconditionally. > You are not going to make an option "log, but do not kill", are you?.. > >> PS why do you waste my time speaking about feature you not going to use ? > > Because you asked for comments (which is very unusual) and no real > consumers for this > feature are anywhere nearby. >
At my job, we use timeouts for all resources we use; if it takes too long we abort and either fail the task at hand (and maybe return a fallback) or retry it at a later time. If we fail too often in a short time window, we back off for a while. If we consistently get timeouts, then it is time to consider either increasing the timeout, or investigating why a certain action takes too long. We do this to achieve better throughput, ensure snappy response for customer facing applications (even if that means that occasionally part of the information is missing), **and** reducing loads on the services, database, etc that we use. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
