Re: What's the problem with stored procedures

Jacob Salomon wrote: > > Additional reparte betweeen Jake & Mark: > > Key: Mark: | > Jake: || > > |Jacob Salomon wrote: > -- SNIP -- > ||I have warned classes not to implement their whole blessed > application > ||in store procedures, partially because of a limited cache of > ||procedures that would thrash in the cache if you used more than the > ||limit (50). > | > |Oh poohy! You have always been able to change the default value of > 50. > |It's just that you have to add the configuration parameters to your > |configuration file manually. PC_POOLSIZE and PC_HASHSIZE I think. > |PC_HASHSIZE must be a prime number. I don't know what the limits of > |these are except the size of SHM. > > I find it quite annoying that these are not documented in the OnLine > Admin Guide, even in release 7.2. At lease not in the index. Indeed. But these sort of parameters can be very dangerous in the wrong hands...... Mind you, OnLine can be very dangerous in the wrong hands. ;-) > BTW, you misspelled "phooey" and MS-word spell checker picked it up. > ;-) > It also seems to have a well-stocked vocabulary of unprintable > language... Verrrry interesting.. I'd be a very poor techie if I couldn't misspell "phooey". ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+