Check the query in your SP. Fine tune your query in SQL and implement the same in your SP. I don't find any reason for drop in your system performance.
Hi,
I don't know which version of Informix you are using. Also I donot know about the type of stored procedure
If this is a Java procedure [udr], then it is a bug. Try installing patch. The problem is with the memory.
If this is the case then talk to informix tech-support.
Otherwise, if this is a ordinary procedure, then try optimizing the sql that you are using as GRP said above.
Hope this makes some sense.
Regards
Partha
In Informix 9.xx versions, informix has to allocate the memory dynamically. This happens certain number of times and after that it doesnot happen. This is the bug description. The Java procedures may require more and more memory and when the engine cannot allocate the memory then performance drastically goes down. Then by rebooting the server this problem can be solved.
If this is the case, I advice you to talk to the Informix people who can give better explanation and solution [patch].
Hope this helps
Regards
Partha Parthasarathy, Hassan
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.