Re: Anybody Knows The Black Magic Behin SPL Performance?

Irwin Goldstein wrote: > The engine tries to cache stored procedures to improve performance, however it has a > limited amount of memory available for this. With the large number of stored procedures > you are using, you may have hit the wall at or around the point the one offending > procedure is being called. I believe that some later versions (perhaps 7.11 or later?) > have some enviornment variables which can be used for controlling the size of the > stored procedure cache and/or for setting up a "private" cache for a particular > session. Check the release notes in $INFORMIXDIR/release. I think this is where > I saw reference to the enviornment variables. >From version 7.00 onwards, and maybe even version 6.00, you can actually set the cache size in terms of the number of procedures cached by setting PC_POOLSIZE which defaults to 50. However, I would also like to hear from an 'expert' when the cached entries are actually updated if you change a procedure. Is it upon creation or next time the procedure is read into the cache? I have also seen something on 'private' caches in version 6.00, but this was from SAP, who tend to hack Informix before release to their unsuspecting clients. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+