Joined: Tue May 31, 2011 1:42 pm Posts: 32
|
I have developed an application win/mac with RS using a mysql database on my VPS. Sometimes my connection gets broken and my app seems to lock up. I've the timeout to 60sec but after this time out the app seems to work but is not able to access the database anymore, so I think it cannot recover the connection.
I open the database in the App.Open event. What is a good practice to keep a healthy connection? There doesnt seem to be a db.reconnect method. Or is it a good way to setup a time that periodicly checks if the db is still connected and if not connects again?
Who can give me some good advice? Thanks in advance.
_________________ RealStudio Web 2012r2.1 | MonkeyBread | MacBook Air OSX Mountain Lion | CentOS VPS / WHM*CPanel
My RealStudio Web applications are available at http://www.runapps.nl/english/ (Dutch language apps only)
|
|