Re: What's the problem with stored procedures

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. 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.. -- SNIP -- ||Anybody know a diplomatic way to say "Nya Nya, I told you so!" ? | "I believe that WAS the conclusion we arrived at before." A favorite Alfred E. Neuman quotation: A diplomat is someone who can something off his chest without losing his shirt. -- -- Jake (Never yelled "CROWDED THEATER!" during a fire) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+