sybperl-l Archive

From: Vaclav Ovsik <ovsik at skoda dot cz>
Subject: using single Sybase connection for parallel processes ?
Date: Nov 6 1997 8:56AM

I'm using Sybperl + Open Market FastCGI + Apache WEB server.
My application create one connection to SQL server when start.
Behavior FastCGI interface is as server when accepting requests
from WEB server.

Fragment of code:
######
use FCGI;

$syb = Sybase::CTlib->ct_connect(...)
while(FCGI::accept() >= 0) {
....
}
######

or (when using functionality of package CGI.pm)

######
use CGI::Fast;

$syb = Sybase::CTlib->ct_connect(...)
while( $q = new CGI::Fast ) {
.....
}
######
I do'not know if this construction is ok. Aplication seems to work ok,
but I tested it only with small load on webserver (one web browser only).
It is clear, that when load on server will be increased, then aplication
will go to fork to more parallel processes.

Q: Can be used single connection to SQL server for more
simultanously running processes (in while loop) ?

Thank you for your help !

--
	Vaclav OVSIK			email: ovsik@skoda.cz
	Skoda Informatika		phone: +420 19 7721366