ok, I'll try connect_cached too. On 8/1/07, Perrin Harkins <[EMAIL PROTECTED]> wrote: > On 7/31/07, Clinton Gormley <[EMAIL PROTECTED]> wrote: > > What you could do instead is to use DBI's connect_cached method, which > > provides similar functionality. I actually use this instead of > > Apache::DBI, even when running under mod_perl. > > I also use connect_cached in many cases. Just be aware of what you're > missing out on, because Apache::DBI does some extra things to protect > you. > > Here are the main differences: > - Apache::DBI doesn't require code changes. connect_cached() does. > - Apache::DBI will avoid caching a connection that you open during > server startup, so that you don't accidentally try to use the same > connection in multiple processes (due to forking). > - Apache::DBI issues an automatic rollback at the end of every > request, so that if your code dies while it has a transaction going, > that will be freed before the next request. (This is only if you open > your handles with AutoCommit off though.) > > Hmm, maybe this should be in the Apache::DBI documentation. > > - Perrin >
-- perl -e 'print unpack(u,"62V5N\"FME;G\!E<FQ`9VUA:6PN8V]M\"[EMAIL PROTECTED] ")'