proformance problem executing stored procedure (2)
proformance problem executing stored procedure (2)
(OP)
I have a similar problem, but mine is not java related. I have optimized my store procedure and it works real fine. However when I run 10 in the background it eats all my CPU time. I have tried run 25 select statements on the same table and it does not eat up so much CPU.
Even so, is Informix suppose to take up all the CPU time when it can? It seems strange that one store procedure can use up the whole CPU (four stored procedures running together and the other 6 waiting to be executed in the queue).
I am using IDS 7.31 on Solaris 4CPU.
The stored procedure creates and populates a few temp tables, then creates indexes.
Performs some updates and returns the result set in another table.
OK so the SP is not nice but is there a way to limit the usage of each process??
Even so, is Informix suppose to take up all the CPU time when it can? It seems strange that one store procedure can use up the whole CPU (four stored procedures running together and the other 6 waiting to be executed in the queue).
I am using IDS 7.31 on Solaris 4CPU.
The stored procedure creates and populates a few temp tables, then creates indexes.
Performs some updates and returns the result set in another table.
OK so the SP is not nice but is there a way to limit the usage of each process??
Talk To Other Members