Subject Re: [firebird-support] Potential Causes for Query to Slow Down
Author livius
first potential thing – transaction management.
Probably you have transaction long running and it stop garbage collector to process old record versions
Karol Bieniaszewski
Sent: Thursday, May 4, 2017 7:56 PM
Subject: [firebird-support] Potential Causes for Query to Slow Down

I have a Delphi Application that uses FireDac to communicate with Firebird 2.5.  I have a query that periodically slows down fro about 5 secs to many minutes.  If I backup and restore the database, I get my original performance back.

What kind of things could cause this behavior.

Thanks in advance. 

Wolny od wirusów.