Re: "lazy"stored procedures
You can adjust the PC_POOLSIZE parameter to cache more stored procedures.
This parameter is not in the onconfig file by default but can be added.
The default setting is 50; with 1200 you may benefit by upping this.
-Bill
}
} 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
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com ennis@accesschicago.net