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"" <[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
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
