Hi Larry,


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

Regards, John

PS: This is taken from a list of Tuning PHP and Apache tips at

""Larry Osborn"" <[EMAIL PROTECTED]> wrote in message
9eemqc$s7q$[EMAIL PROTECTED]">news:9eemqc$s7q$[EMAIL PROTECTED]...
> 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
> 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
> 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
> :)
> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to