Subject Stored procedure execution time
Author esbreidenbach
I have an application which executes a stored procedure in Firebird 1.5.6 on a fairly regular basis (multiple times per day).

Immediately following a backup/restore of the database, the procedure runs fairly quickly (less than a second or two) at any time of day.

Gradually, over time (month or so), the first execution of the procedure on any given day starts taking longer and longer (15 seconds up to minutes). However, subsequent executions of the same procedure the rest of the day run just as quickly as before.

I have checked, and it does not appear to be any other processes running during the initial execution.

Any ideas on what causes this?