Do I need to close the database connection?

Question

MySQL

Hello. I am writing a python program and using mysql connector.
I will have a lot of calls to the database in my program, but the program will also run for hours and no one will work in it.
Whether prompt it is necessary to close connection after each SQL request? For example like this:

conn = MySQLConnection("Данные для соединения")
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM avi_db")
        row = cursor.fetchall()
        cursor.close()
        conn.close()

or is it better to close the connection after closing the program?

Answer 1

If the application is a daemon, then it is better to reuse it. If each request raises a new process, then you can not close it, because. all connections will be cut off as soon as the request is processed.

Answer 2

Make a Singleton on the connections and use it as you work. Reconnect every 10-15 minutes, because connections can still break, for example, the server itself will break or the grid, and indeed a bunch of all sorts of reasons.