There is a specific solution for your problem within the DBI module itself, you need to replace your connect with connect_cached, then multiple connects to the same db will just return the same db-handle
I have tried that as well. That works as far as limiting one $dbh but I still have to call new for every table I create. Some of the scripts may access over 30 tables. That would mean that I would have to call new over 30 times and that is what I'm trying to avoid. What is the best method for only having to create one object then use that object over without having to call new each time I access a new table.