Re: "lazy"stored procedures

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.. -- David Williams