Re: SPL & Triggers - do's and don'ts

David Williams wrote: > > In article <3291472D.5831@sprynet.com>, Jake Salomon > <jsalomon@sprynet.com> writes > >As far as I recall, the SP cache is still limited to 50 procs. This is > >not [yet] a tunable to keep those feature requests coming, folks! > > > Where did you hear about this limit - I cannot find it in the > manuals. It's always been a tunable parameter, well in 7.xx anyway, just not documented. ;-) I'm not at the office at the moment, but if memory serves me, the parameter is something like PCPOOL_SIZE, and defaults to 50. So this is where the so-called limit comes from. As to the maximum value for this parameter... I haven't a clue. :-) Hope this helps, -- 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! | +------------------------+------------------------------------------------+