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.