Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Ima::DB db handles

by rkg (Hermit)
on Mar 11, 2004 at 17:35 UTC ( [id://335891]=perlquestion: print w/replies, xml ) Need Help??

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!

rkg

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://335891]
Approved by valdez
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-03-29 07:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found