[Catalyst] Shared database handles under mod_perl 2.0 / Catalyst 5.33?

[Perrin Harkins]

On Thu, 2005-11-10 at 16:22 -0600, Brandon Black wrote:
> At least under PostgreSQL, even a readonly SELECT statement is part of
> a transaction, and if you issue a SELECT via DBI without AutoCommit
> and then idle the connection for a while (which would be a common
> mod_perl usage pattern), the connection will not be "idle", it will be
> "idle in transaction", taking up locks on the backend and all sorts of
> nasty stuff that's bad for efficiency and sanity.

That's true for MySQL InnoDB tables as well.  I usually change the
isolation level to "READ COMMITTED" to help with this.  I think that's
the default for PostgreSQL though.

- Perrin