Subject Re: [IBO] Gradual Slow Down
Author Helen Borrie
At 08:52 PM 15/02/2005 +0000, you wrote:


>I have an app that is running several stored procedures on a
>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?

Sure is. But we need more detail about what the SPs are doing (i.e. the
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