| Subject | Re: [firebird-support] Stored Procedure slowing down |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2013-12-20T19:10:33Z |
Hello, MarkC!
Friday, December 20, 2013, 11:06:07 PM, you wrote:
Mwc> I have a stored procedure using a FOR SELECT loop through
Mwc> roughly 1,000 records, that normally runs in about 4 seconds. In
Mwc> one location it sometimes takes up to 30 seconds. If the
Mwc> firebird service is stopped and started, usually makes the
Mwc> procedure time drop back to around 4 seconds. However, this
Mwc> week, starting and stopping the service did not help. Looking for
Mwc> any ideas of what would cause a procedure's performance to slow down like this.
record versions, garbage, etc.
--
Dmitry Kuzmenko, www.ib-aid.com
Friday, December 20, 2013, 11:06:07 PM, you wrote:
Mwc> I have a stored procedure using a FOR SELECT loop through
Mwc> roughly 1,000 records, that normally runs in about 4 seconds. In
Mwc> one location it sometimes takes up to 30 seconds. If the
Mwc> firebird service is stopped and started, usually makes the
Mwc> procedure time drop back to around 4 seconds. However, this
Mwc> week, starting and stopping the service did not help. Looking for
Mwc> any ideas of what would cause a procedure's performance to slow down like this.
record versions, garbage, etc.
--
Dmitry Kuzmenko, www.ib-aid.com