Xu, Qiang (XSSC SGP) wrote:

quite a bit, and none at all.

key to Apache-DBI is that when used in mod-perl, it works like a cache of open DBI handles; when your cgi script runs and calls DBI->connect(@args), it is given a reference to a previously opened and cached handle, or if the connect @args are different, opens a new one for you, and saves it to cache, assuming youll be back to use it again.

I believe your code can remain unchanged; you call DBI->connect, not Apache::DBI->connect. But you do have to load Apache::DBI at server startup (either directly or indirectly from a <Perl> section in your httpd.conf

I dunno whether it eventually closes LRU handles, or whether/how-many additional handles it will open if the currently available matches are busy, but im sure some hints are in the docs.

and caveats apply - im writing from memory /understanding, not from perldoc