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!

rkg