XP is just a number | |
PerlMonks |
Confirm persistent db connection?by Athalia (Initiate) |
on Sep 21, 2000 at 03:01 UTC ( [id://33425]=perlquestion: print w/replies, xml ) | Need Help?? |
Athalia has asked for the wisdom of the Perl Monks concerning the following question:
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. 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. 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. Does anyone know how to do this? Is there a connection id or environment variable that I can get? Specs:
Thanks in advance... [formatted by editor] Originally posted as a Categorized Question.
Back to
Seekers of Perl Wisdom
|
|