16.10.2018 14:02, Marcelo Guimaraes mfguimaraes@... [firebird-support] wrote:

> . 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?

Perhaps it is caused by garbage collection and related to bad transaction management in
application or bad database design. Use gstat for diagnostics.


--
WBR, SD.