> Am I doing something wrong? Can Apache::DBI hold several handlers for > one httpd process? I suspect that user connects to different processes > and the handler (dbname/username/pass) do not always match.
Apache::DBI will cache connections on a per-connection-string basis, once in each child process. so, if each connection to a database is made using a different username each will be cached and you'll end up with users*processes number of cached connections in total. HTH --Geoff