|
DBMAXPROC <number> oninit/session
Максимальное количество процедур хранимое в
кэше. По умолчанию 50. У меня были интересные
графики, которые показывали как уменьшение этой
переменной до 10, увеличивало скорость процедур и
убирало memory leak в версии IDS 7.30UC(?). Но это скорее
всего частный случай. Описана в "Guidelines for Using
Informix Stored Procedures Revision 1.1, December 22, 1998"
- "Each user session contains a private stored procedure and data structure cache
that is used for executing stored procedures. The number of stored procedures that can be
stored in this cache is controlled by the DBMAXPROC environment variable, by default 50.
For performance reasons, the database server allocates memory in a session-s private
shared memory for every SQL statement inside of a stored procedure. To avoid the overhead
of additional memory allocation,
this private cache is not freed until the session disconnects. For this reason,
applications with stored procedures will require additional shared memory resources. For
applications with large numbers of complex, stored procedures, lowering DBMAXPROC will
reduce shared memory requirements."
| 