Folks,
I am having a problem with PHP/MySQL database connections. I currently have a PHP web application running under IIS 5.0 and I am connecting to a MySQL 3.23.47-nt database server on the same machine. This is my problem: I have the wait time out and interactive time out set to 30 seconds, and even though I use mysql_close($link), the connections do not seem to close, and over time, this causes a performance degradation in my application.
<strong>Additional Information (For those who care):</strong>
In my application, I have a header and footer wrapper to do things like connect to the database and check for error messages, and give my application a consistant look and feel. In the header I connect to the database, and in the footer I close that connection. I was initially including the database.inc file each time I wanted to run a query, but this seemed to be a bit much. Since I have changed my methods and ramped up the number of page reloads, I have noticed a performance issue and noticed that the server is not dropping the connections.
So, sorry about the rambling, and if anyone has any advice, I would appreciate it.
Thanks,
Bernie
