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
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