Hello,

I was wondering if you need to specifically close connection to MySQL whenever you open the connection to the database. Also, is it necessary to clean up $sth by issuing $sth->finish() whenever you call $sth->execute().

Looking at the Links SQL source code, I don't see any closing or cleaning up the connections to MySQL. Does MySQL automatically closes connection at the end of every Perl script? If not, would it cause a resource leak problem for MySQL on a heavy site?

I had a similar problem working on an Access database using ASP, and was wondering how MySQL handles the database connections.

Thanks in advance,

5th season