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
