Re: Informix 7.12: Stored Procs vs Roles

Jake Salomon wrote: > > The bigger problem, however, is caused by a built-in limit in the stored > procedure cache. As of this writing, the limit is 50 procedures. (I > don't recall seeing this capacity raised in 7.2.) If you have many > tables and correspondingly many SP's - all frequently used - you will > have the engine thrashing them in & out of memory. Check out PCPOOL_SIZE (or something like that) Jake. It's been there all along, just never documented. ;-) Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |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! | +------------------------+------------------------------------------------+