this will be a big help
""John Lim"" <[EMAIL PROTECTED]> wrote in message
9efl78$2kc$[EMAIL PROTECTED]">news:9efl78$2kc$[EMAIL PROTECTED]...
> 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
> > has its MaxSpareServers in the httpd.conf set to 100. So that turns out
> > be 400 connections to the Oracle database. We are not using persistent
> > connections, because that makes the problem worse. Does anyone know of
> > 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]
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]