PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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