On Fri, 11 Feb 2000, John McCormac wrote:
> fewer open database connections to achieve the results. (There is a very
> good explanation of this in Philip Greenspun's article on
> Oracle/AOLserver on the Linuxworld site or in his Database Backed
> Websites book at http://photo.net/wtr/ ) The number of connections open
> to the database would be the critical aspect of such a design and
> AOLserver wins on this.
Read the book again John - the important aspect here, and the one which
philg harps on about is NOT the number of connections open but the fact
that in the AOLserver there is a pool of open connections, and when a TCL
procedure requires a database connection, it just asks for one from the
pool, thus saving the overhead of opening a new connection and closing it
again for a simple query. I imagine that a little imagination could
provide such a solution with Apache and modperl - in fact with modperl
you'd need to mind you back to make sure that this didn't happen
inadvertently :-) However, it is of course integrated into AOLserver and
thoroughly tested. But you do have to program in TCL rather than Perl :-(
Kindest regards,
Niall O Broin
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
