Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Sun Aug 20, 2017 12:58 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Good practice keeping MySQL DB connection alive
PostPosted: Tue Jun 04, 2013 4:58 am 
Offline

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
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group