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]
")'

Reply via email to