On Tue, Oct 05, 2004 at 10:27:19PM +0200, Perrin Harkins wrote: > > Remember, Apache::DBI doesn't share these connections between processes > -- every process will need to open a connection to all three databases.
If the databases all reside on the same server, you could initiate one connection (to one of the three databases or even without stating a database) and use the <database>.<table> syntax in your SQL. This limits the number of connections considerably. The downside is that you know about access/authorisation issues only at the moment of executing your SQL (and not at the connect-state). HTH Frank -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html