rkg has asked for the wisdom of the Perl Monks concerning the following question:
Hi
I'm using Ima::DBI to access one mysql server consisting of multiple databases of InnoDB tables. I'm using Autocommit=0 and explicit transactions.
To ensure commit works properly, should I create one Ima::DBI db handle per database, or just a single shared handle for everything? (When querying, I always use fully qualified table names -- 'db.table', not just 'table' -- so this isn't an issue for selects, but rather inserts, deletes, updates, and commits.)
Thanks for the advice!
|
|---|
Back to
Seekers of Perl Wisdom