| Subject | Stored Procedure slowing down |
|---|---|
| Author | |
| Post date | 2013-12-20T19:06:07Z |
Hi,
I have a stored procedure using a FOR SELECT loop through roughly 1,000 records, that normally runs in about 4 seconds. In one location it sometimes takes up to 30 seconds. If the firebird service is stopped and started, usually makes the procedure time drop back to around 4 seconds. However, this week, starting and stopping the service did not help. Looking for any ideas of what would cause a procedure's performance to slow down like this.
Other relevent info: Firebird 1.5.6, Win 2012 Server.
I have a stored procedure using a FOR SELECT loop through roughly 1,000 records, that normally runs in about 4 seconds. In one location it sometimes takes up to 30 seconds. If the firebird service is stopped and started, usually makes the procedure time drop back to around 4 seconds. However, this week, starting and stopping the service did not help. Looking for any ideas of what would cause a procedure's performance to slow down like this.
Other relevent info: Firebird 1.5.6, Win 2012 Server.