$Id: README,v 1.2 2001/10/31 22:17:38 mpeppler Exp $ This is Apache::Sybase::ConPool, a connection pooling module for mod_perl and Sybase database servers. Copyright (c) 2001 by Michael Peppler. This module uses the fact that Sybase client connections can be shared between processes to create a pool of database connections that can be shared between all of the httpd processes using mod_perl. The connections are created during the Apache initialization by including this module in a startup.pl or pre-load.pl script loaded with a PerlRequire directive in httpd.conf. I have been using a version of this module for about a year now on a site with a farm of 40 web servers, and it has worked well. The caveat is that connections can't be re-initialized while the web server is running, so you have to stop/start Apache to reconnect to the database if the database is rebooted, or if the connections become unusable for any other reason. The eg/ directory has a sample conpool.cfg file, as well as a simple pool.cgi script that illustrates usage. Credit where credit is due department: I initially got this technique from Kenny MacLeod, who suggested it when I was inquiring about connection pooling in the Sybase newsgroups about a year ago. Comments are as usual welcome! Michael Peppler, mpeppler@peppler.org