when connecting to a DB, should you always disconnect?

[spewn]

i have the following code:

my $dbh2 = DBI->connect('dbi:mysql:dbName','','');
my $sthX1 = $dbh2->prepare("select oneA, oneB, oneC from products where prodID = '321'");
$sthX1->execute;
use constant ONEA => 0;
use constant ONEB => 1;
use constant ONEC => 2;

i want to know if it's crucial that for each instance of the above script, should i always end with:

$sthX1->finish();
$dbh2->disconnect();

i have been running my site on my comp without and it's fine, so i wonder if they are even needed.

any ideas?

- g

 

[ericbrunson]

It's good programming, but not necessary with the default mysql config.