PodMaster already pointed you to my post about this on the mod_perl list. The main problem is that if you don't do something like what I show there, you will lose the safety rollback that Apache::DBI does at the end of every request, and this is very important when using a transactional database.

For persistent connections outside of mod_perl, just use DBI->connect_cached(). Class::DBI already uses this.