Re: Threading ESQL - please help me

Silviamt wrote: > > I am currently getting involved with ESQL and Threads with Informix 7.2 > I am trying to create an application that may receive many simultaneous > queries. For efficiency I want to create a connection per thread with > 20 threads to perform upto 20 concurrent queries. Thus I do not want to > ever delete either the thread or the associated connection. The examples > in the book dont really address this issue. I want to ensure that I have the > highest possible throughput when 20 queries come at the same time. > > Can each query have its own active connection? Yes. > If the first query takes a long time joins etc. > and subsequent queries are simple selects do they need to wait for > the first query to relinquish the connection or is there a better way? No; the threads can be active concurrently. > Note: the query is being passed as a string to my application I have no way > of knowing at runtime its complexity or what queries may immediately follow. You haven't looked at what PREPARE and DESCRIBE tell you. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix -- see http://www.perl.com/CPAN #include <disclaimer.h>