Re: Multi-thread connection to Informix server
Posted in 1998
Topics: Performance & Tuning
This goes back to the argument threads vs fork(). In your application, none of the *threads* need to talk to one another. Therefore you will have minimal communications between the parents and the children. Use fork() over threads. (Now I know I'll get some moron flaming me for saying this, but the overhead of the forked procs is low and your communications are fairly trivial to handle ...) -HTH Mikey Ka-Leung Tong wrote: > Hi, > > I'm trying to write an application server to accept client > requests and then create a thread for each request to execute SQL > query to the Informix server. But somehow the query executions from > different threads are all serialized by the Informix server. So > the performance degrades much when you have more and more threads. > Does anyone know if this is a limitation of the informix server? > Please reply to tong@cs.stanford.edu. > > Thanks, > Tong