I would like to know if the Firebird have any kind of timeout on query execution.
I´m asking that because we are facing the following situations: .. query executing alone on the environment, manipulating 4 millions of records, the return is in seconds; .. the same query, executing in parallel with other queries and manipulating the same 4 millions of records, the return is in about 20 minutes; .. the same query executing alone on the environment, manipulating 5 millions of records, return is in about 20 minutes; Anybody have passed for a situation like that or know what are causing it? Affected version identified: 2.5.8 as SuperClassic running on dedicated server with Debian distribution. Regards, Marcelo Guimarães
