Subject | Gradual Slow Down |
---|---|
Author | Bill Gage |
Post date | 2005-02-15T20:52:37Z |
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?
Bill
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?
Bill