You can verify correct operation of Apache::DBI by doing the following:
1) Make sure it appears BEFORE the DBI load in your startup.pl (or
equivalent)
2) Use Apache::Status and enable perl-status as needed in your httpd.conf
load in this order:
use Apache::Status();
use Apache::DBI();
use DBI();
3) Pull the URL that should use the presistent connection and then check
the status of the DBI connections via the perl-status default page.
If you don't see any connections after calling that page then the database
connection is NOT being reused.
Aaron Johnson
David Lloyd wrote:
> If I use Apache::DBI under mod_perl and continuosly open and disconnect
> a DBI:mysql connection, it should reuse the same connection and not
> perform a database lookup all the time.
>
> I have a piece of code that I can't be bothered optimising (i.e. it
> currently opens and closes about 30 connections before finishing and
> recoding it would be a Pain In The Arse [PITA]).
>
> DSL
> --
> Pussy's good for six at the most
> (Mrs. Lovett, Sweeney Todd)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
