| Subject | Re: [firebird-support] Potential Causes for Query to Slow Down |
|---|---|
| Author | livius |
| Post date | 2017-05-04T20:54:59Z |
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
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.
