Limited connections to the database

From: Date: Mon, 17 Oct 2005 10:36:41 +0000
Subject: Limited connections to the database
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-40516@lists.php.net to get a copy of this message
Hello to everyone, we have been using an Apache server here at work (I work in a Library) where PHP/ASP scripts query the database very frequently (in the near future only PHP scripts will be used). The DBAs have recently complained that our webserver is performing the queries in a high speed and many times in a second. It worried them and they are asking if we could limit the connections to the database to a low number. As an example they told us that other applications in other webserver uses Tomcat to run Java, and there they managed to limit the number of active connections at the same time. I would like to know if it's possible to make something similar, and I'd like to know too if we have to configure the PHP or the Apache. Our environment is listed below: Windows 2003 Server Apache 2.0.54 PHP 4.4.0 Sun Chili!Soft ASP 3.6.2 MySQL 4.0.20a Oracle 9i (through a Oracle 8i NetClient) TIA, Marcos R. Cardoso Blumenau Brazil

« previous php.db (#40516) next »