I looked into this a little further. Calling

$dbh->disconnect

closes the database connection. I am calling this script at the end of each SQL command. All seems to be working well so far. The ...ORDER BY was also handy and I should have thought of this before. See what happens when one does not use perl everyday...