Re: Limiting # of connections to remote Oracle

thanks john! this will be a big help --Larry ""John Lim"" <jlim@natsoft.com.my> wrote in message news:9efl78$2kc$1@toye.p.sourceforge.net... > Hi Larry, > > See > > http://marc.theaimsgroup.com/?l=php-dev&m=98193543028899&w=2 > > I would create a special web server listening at port 81 to perform Oracle > queries. Your main web servers call the port 81 server using > > fopen("http://proxyserver:81/updatemail.php?params=..."); > to update the > Oracle database. > > There are also tools to help you create a proxy database web server at > http://php.weblogs.com/adodb_csv > > Regards, John > > PS: This is taken from a list of Tuning PHP and Apache tips at > http://php.weblogs.com/tuning_apache_unix > > ""Larry Osborn"" <larry@napster.com> wrote in message > news:9eemqc$s7q$1@toye.p.sourceforge.net... > > Greetings all, > > We are having serious issues with PHP4.0.5 using OCI8 and Apache 1.3.17. > > > > We have 4 webservers that handle our various needs for oracle. Each server > > has its MaxSpareServers in the httpd.conf set to 100. So that turns out to > > be 400 connections to the Oracle database. We are not using persistent > > connections, because that makes the problem worse. Does anyone know of a > > way to limit the number of database connections without having to turn > away > > users by limiting the number of apache processes? > > > > We are using php+apache+oci8 to subscribe and unsubscribe people to our > > mailing list. We have simple select and update queries using > non-persistent > > connections. Im not too sure what other information I would need to > > provide, Im just a webdeveloper, not a sysadmin, so please bear that in > mind > > :) > > > > Thanks for any help you can give me. > > > > Larry Osborn > > Web Developer > > Napster, Inc. > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >