Look at this (from the SQL-Relay FAQ):
"Connecting to Oracle databases is especially time-costly and OCI
libraries are especially heavyweight compared to other databases.
Moving that overhead out of your application is especially
advantageous with Oracle."
you can solve the problem of costly setup and teardown of OCI8
connections by using persistent connections. You can do this with
Apache::DBI or your own code (it's a 5-liner in Perl).
"Using conventional connection pooling mechanisms, at least one
persistent database connection would be maintained per-process.
Sometimes, under heavy load, the database server just can't handle
the traffic from that many simultaneous client connections."
by putting a Squid HTTP accelerator in front of Apache, you limit the
number of Apache processes -- as the FAQ states elsewhere, usually not
more than a few clients *need* database access at any given time, but you
have to have enough processes to handle static access to prevent excessive
latency.
having Squid take care of static content serving fixes this problem
easily, in a database-independent way which doesn't require extra software
or coding.
---
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
