dbi question

[Michael G Schwern]

On Sun, May 13, 2001 at 01:19:04PM +0100, Stray Toaster wrote:
> That is, the explicit call a handle, then explicitly destroy it.(I
> don't mind the making, it is the disconnect that is bugging me.)

You're following the road that lead to Ima::DBI and Class::DBI.
Consider using Ima::DBI as it will negociate all that connecting when
needed for you.

Poke through:
http://www.pobox.com/~schwern/papers/Class-DBI/Class-DBI-paper.pod


> So how do I avoid all that then? I am sure I am missing the obvious
> here...........

What Leon said, don't disconnect and reconnect in each method, just
leave it open.  Under anything but MySQL, connecting can be sluggish.
And use connect_cached().


-- 

Michael G. Schwern   <schwern at pobox.com>    http://www.pobox.com/~schwern/
Perl6 Quality Assurance     <perl-qa at perl.org>	     Kwalitee Is Job One
BOFH excuse #386:

The Internet is being scanned for viruses.