categorized question
QandAEditors
I have a web resource served by Apache with a Perl interface
to a MySQL database. In order to speed things up, I am using
mod_perl/Apache::DBI to create a persistent database connection
in a script that is run when Apache is started.<br>
<br>
I want to make sure that I actually have a persistent connection.
The scripts that query the db were not originally written
with mod_perl in mind and each one contains a db connection
statement. The mod_perl guide says these will be ignored
if a persistent connection exists.<br>
<br>
The obvious way to test would be to remove these statements
and see if the queries fail but I'm sure there must be a
more elegant and explicit test.<br>
<br>
Does anyone know how to do this? Is there a connection id or
environment variable that I can get?<br>
<br>
Specs:
<ul>
<li>MySQL 3.22.21</li>
<li>Apache 1.3.9</li>
<li>Perl 5.004_04</li>
<li>Apache::DBI 0.87</li>
<li>DBI 1.14</li>
</ul>
<br>
Thanks in advance...<br>
<br>
<i>[formatted by editor]</i>
1831