MySQL database connecting or reconnecting

[Davor Geci]

Hello guys,

I have a very big project that previously was only used in a local environment and now it goes over the internet. The database in on a web server.
The project is designed to once connect to the database and use this global connection everywhere. It was using Access mdb database.
Now that the database is MySQL and on the web server if the connection is not used it triggers the timeout.
Would you:
1. go and reconnect the connection before using, or
2. would you rewrite the code to use a local connection and connect and disconnect

Thanks,
Davor