Re: Parallel Query Execution !

Hello ! I had the same problem and I used fork to create childs which access the same table (no problem). What I also would like to do is to create threads which to the work in parallel. With Informix 7.2 Informix supports threads if you use the DCE Thread-Package. But there is one problem (it's only one little sentence in the ESQL/C Programers Manual): You can have one active connection per thread (that means every thread can be ready to start his SQL-requests), but only _ONE_ thread at a time can have the current connection (that's the connection that is currently sending SQL requests to the database server and possibly receiving data from the database server). I am very sorry about this because that means you cannot receive data in parallel when you use threads --> no run time improvements (except of preparing anything you need befor you use the active connection). Alexander Selg Nitin Joglekar wrote: > > Hi all, > I have an application with Informix Ver. 7.2 as a database and C as a > host language. The hardware platform is on HP UX box with HP unix > ver. 10.2 It's a typical ESQL/C application. > I have two different and independent queries in the same program. I am > executing it sequentially (one after the other) as usual and putting the > result in the temp table. Both queries use the same temp table and the > structure of the table is also same. I would like to know, whether with > the unix capability of fork (parent-child process) or with any Informix > provided call, can I execute those two queries parallely ? With that I > would like to achieve some run time improvements if possible. > I hope I am clear. Thanks. > Bye, > Nitin Joglekar > Email - njogle01@valos000.los.gsd.eds.com -- ------------------------------------------------------------------- Alexander Selg | e-mail: alexander.selg@siemens.at Siemens AG Austria | Tel.: +43 1 1707-45960 A-1101 Wien, Gudrunstr. 11 | Fax.: +43 1 1707-55832 -------------------------------------------------------------------