New topic: Good practice keeping MySQL DB connection alive
<http://forums.realsoftware.com/viewtopic.php?t=48063> Page 1 of 1 [ 1 post ] Print view Previous topic | Next topic Author Message richardschmidt Post subject: Good practice keeping MySQL DB connection alivePosted: Tue Jun 04, 2013 4:58 am 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) Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
