Re: Multi-threaded applications for On-Line

I would check out Informix CLI (the call level interface) as well as the UDBC drivers from OpenLink (http://www.openlinksw.com) to see if any of these could support a multi treaded application in a better way than it seems ESQL/C does at the moment. vsingh@bactc.com (Vijay Singh) wrote: : : :Thanks Sunil for responding to my posting, : :I have consulted a few people and my understanding differs. :My understanding is : : :The thread safe version of Informix general libraries allows an ESQL/C :application that has several threads to call these library function :simultaneously. : :What it means is that with a multi-threaded process we could open multiple :sessions and insert / query simultaneously. All functions in the library :are MT safe. : :The idea here is to achieve parallelism. I developed a multi- process :application doing the same thing. It is running Great. My problem is :that I have to create several shared memory buffers and semaphores to :support the Inter Process Comm. All this is adding up to the overhead :and my system is getting CPU bound ( 100 % CPU usage ). :In order to reduce this overhead on my system I am planning to move to :multi-threaded instead of multi-process. : :I have developed a multi-threaded prototype. A few questions which I have :on my mind are: : :1) Is there any other database vendor that supports multi-threading ( : Solaris or POSIX threads ) without needing to install a third party : package like DCE ( which is non-standard ). : :2) If I go with Informix is there an alternative to not spending the $4000 : for DCE threads. : :3) If I am ready to install DCE package can I still use the standard POSIX : threads or will I have to use their threads ( which are non standard ) : : : I will appreciate all responses. : :Vijay : : :PS I am not a user on the informix group so please send me EMAIL directly. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org