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