Hello, I have a server with a Mysql Database.
Every time an users logged in, create account, loosing life, .. the server is opening a mysql connection, execute mysqlcommand, close connection.
Now I think this isnt needed and I want to open the mysql connection 1 Time and close the connection only when server is turned off.
So is it a good idea to leave the mysql connection opened? (Does it get timeouts sometimes?) Or is it a better way to connect/disconnect for every command? Same question goes to the Mysql Reader (Ive expected some bugs when dont turn off the reader every time)
Here is my current code: Thanks
asked Jun 29 '10 at 03:21 PM