Performance drop while executing StoredProcedure in Informix

[GEBOF]

Hi,

When I start a SP the performance of my system droppes.

Can anyone help me?

GEBOF

 

[GRP]

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.

G.R.P.

 

[ifxtechie]

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

 

[JCarlosS]

Hi,
Tell me more about bug on Java Procedure, and the patch, please!!

 

[ifxtechie]

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