Subject | Re: [IBO] Gradual Slow Down |
---|---|
Author | Helen Borrie |
Post date | 2005-02-16T05:55:13Z |
At 08:52 PM 15/02/2005 +0000, you wrote:
operations) and what is accomplished, volume-wise, each time each SP runs.
Can you also show the exact client code that starts and commits your
transactions; and report the AutoCommit setting on the transaction.
Also describe what other work is running concurrently.
Helen
>I have an app that is running several stored procedures on aSure is. But we need more detail about what the SPs are doing (i.e. the
>database. It seems that as the process of running all the
>procedures progresses the application starts to slow down. I start
>a transaction before every stored procedure and commit after each
>one.
>
>Is there anything else I can do to avoid this gradual slow down?
operations) and what is accomplished, volume-wise, each time each SP runs.
Can you also show the exact client code that starts and commits your
transactions; and report the AutoCommit setting on the transaction.
Also describe what other work is running concurrently.
Helen