Hi, first potential thing – transaction management. Probably you have transaction long running and it stop garbage collector to process old record versions
Look into MON$TRANSACTIONS regards, Karol Bieniaszewski From: [email protected] [firebird-support] Sent: Thursday, May 4, 2017 7:56 PM To: [email protected] 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. --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus
