Re: "lazy"stored procedures

In article <0kM4lWAiPejzEwoV@smooth1.demon.co.uk>, David says... > >In article <5mkinu$8bv@cssun.mathcs.emory.edu>, Oscar Goldes ><ogolde@impsat1.com.ar> writes >> >>Oscar >> >>Sorry, misread your original posting. I agree it does not seem = >>reasonable based on the >>situation you have described. >> >>I would see what informix have to say and in the meantime run update = >>stats for the >>procedure. >> >>Do you have lots of procedures? >>YES!!! 1200 of them! >> > Proably means that the online internal procedure cache is too small. > What does onstat -g prc say? >> >> >>What else is going on on the machine when it slows down? >>Nothing special. Just about 10-15 users using PowerBuilder client apps = >>that call stored procs >>What I have noticed is a high value of "buffwait" around 120000 after = >>some hours on , I do not know the normal values, or if it has anything = >>to do with the problem.=20 >> >>Once they slow down, they remain slow even with a single user on the = >>system! (130 MHz Pentium biprocessor) >> > Check in $INFORMIXDIR/etc/$ONCONFIG that NOAGE is set to 1 > (disable priority aging). Check in the release notes (ONLINE_7.2 > somewhere under $INFORMIXDIR/release that disabling priority aging > is suppported.. But for God sake make sure it is set to 0 if you are on HP. There is a really nasty bug which brings your box to a standstill as Online gets hold on all CPU so no one can even log in. > >-- >David Williams Ilya Bogorad