Tuesday, 3 May 2016

[firebird-support] Fast Slow Stored procedure

 

What are the possible reason for a SP that normally runs in approx 20 seconds then Occasionally takes 15 minutes, (or a method of trying to find the cause of the problem).


Firebird Details

Server Version: WI-V2.5.5.26952 Firebird 2.5 32 bit Superserver, CpuAffinityMask = 1 in firebird.conf


System

Windows 10 Pro 64 bit

Processor Intel Xeon CPU E5530 @ 2,4 GHz Quad CPU

Memory 12.0 GB


Accessing DB using IBObjects components (TIBStoredProc)


Available tools IBExpert


Thanks for any help


Jack

__._,_.___

Posted by: millsjack14@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment