Re: Stored Procedures Limitation

Posted in 2006

Topics: Performance & Tuning, Stored Procedures & SPL

Art S. Kagel — Mon, 03 Apr 2006 18:04:03 -0400 — source: Usenet: comp.databases.informix

OptionJ wrote: > I found a reference that tells me that Informix can only have 16 stored > procedures running at one time. The only thing I can think of that's remotely related is that you can only recurse in a stored procedure, or have one proc call another, to a depth of 16 calls. You can have 1000's of procs running in different sessions sumultaceously. Art S. Kagel > Currently, we have a variety of things that are set up as stored > procedures that take a long time to process. If there are 16 running > at one time, does that mean that the 17th must wait until one finishes > in order to be loaded into cache so that it can start processing? > > I believe that we are running an older version, 7.1, of Informix. If > this is enhanced in later versions, I'd be interested in knowing that > as well. > > Many of these processes have been, in my opinion, incorrectly set up as > SP's. If this is also causing a performance hit, then I would be > better able to request time and resources to make these changes. > > Thank you! > > Option J Upton >

↪ replying to Art S. Kagel

Superboer — 4 Apr 2006 00:20:54 -0700 — source: Usenet: comp.databases.informix

Hello Art, afaikr 16 deep is not true either; remember the pre7.2 hack for upper. i thing the great Junet wrote that; it could do at least 256 deep. Superboer. Art S. Kagel schreef: > OptionJ wrote: > > I found a reference that tells me that Informix can only have 16 stored > > procedures running at one time. > > The only thing I can think of that's remotely related is that you can only > recurse in a stored procedure, or have one proc call another, to a depth of > 16 calls. You can have 1000's of procs running in different sessions > sumultaceously. > > Art S. Kagel > > > > Currently, we have a variety of things that are set up as stored > > procedures that take a long time to process. If there are 16 running > > at one time, does that mean that the 17th must wait until one finishes > > in order to be loaded into cache so that it can start processing? > > > > I believe that we are running an older version, 7.1, of Informix. If > > this is enhanced in later versions, I'd be interested in knowing that > > as well. > > > > Many of these processes have been, in my opinion, incorrectly set up as > > SP's. If this is also causing a performance hit, then I would be > > better able to request time and resources to make these changes. > > > > Thank you! > > > > Option J Upton > >

↪ replying to Superboer

Superboer — 4 Apr 2006 00:21:49 -0700 — source: Usenet: comp.databases.informix

oopps it should read pre 7.3 ..

↪ replying to Superboer

david@smooth1.co.uk — 4 Apr 2006 18:35:39 -0700 — source: Usenet: comp.databases.informix

June Tong? Where is she now?