Hi Simon,
This is not an answer to any of your questions, but your mail reminded
me of a "gotcha" relating to Apache::Session and Apache::DBI that is
probably totally obvious to the gurus on this list.
When Apache::Session::DBI connects to a database, it calls:
$self->{dbh} = DBI->connect(
$datasource,
$username,
$password,
{ RaiseError => 1, AutoCommit => 1 }
);
If you use Apache::DBI, make sure that you call "connect" with the
same arguments as above in your other scripts or you will find
yourself with more than one connection/process to the database, which
may not be your intention. I spotted this by running "httpd -X" and
noticing that it would spawn a second db connection whenever a session
was created.
Hope this helps somebody!
Rob