stored procedures and threads

Posted in 1999

David Henry — Tue, 9 Nov 1999 16:13:34 +0200 — source: Informix-list mailing list archive (1991-1998)

I'm using Dynamic Server V7.3. I have heard it claimed that all calls to stored procedures go via a single thread. Can anyone verify or deny that claim?

↪ replying to David Henry

mars1972@my-deja.com — Tue, 09 Nov 1999 19:07:08 GMT — source: Informix-list mailing list archive (1991-1998)

In article <809aea$r3o$1@news2.inter.net.il>, "David Henry" <henryd@net-gong.com> wrote: > I'm using Dynamic Server V7.3. > I have heard it claimed that all calls to stored procedures go via a single > thread. Can anyone verify or deny that claim? > > That used to be true. It was fixed in 7.2, I think. Assuming, of course, that it is possible and makes sense to use multiple threads. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to David Henry

Art S. Kagel — Tue, 09 Nov 1999 16:00:59 -0500 — source: Informix-list mailing list archive (1991-1998)

David Henry wrote: > > I'm using Dynamic Server V7.3. > I have heard it claimed that all calls to stored procedures go via a single > thread. Can anyone verify or deny that claim? Stored procedures are executed by your current SQLEXEC thread. Someone may be thinking of UDFs in UDO (Universal Server). In early versions there was one VP dedicated to executing DataBlades and UDFs (User Defined Functions). The newer versions this is still true for UDFs not written with multi-threading in mind, however, there is a defined procedure for making your UDFs parallelizable so they can be run in multiple threads. Art S. Kagel