MB Software Solutions wrote: > What's the best practice in this? iirc, Paul McNett does a timer > process in the background where he constantly keeps polling something > like "show tables" in order to keep the connection alive.
Well, not 'constantly'. I think the timer fires once an hour or something. But I haven't looked at that code in years. I guess it works fine because nobody's complained and I haven't seen connection errors in the error reports emailed to me. > Or is this something better done at the configuration section in ODBC > rather than via the software? You can configure the MySQL server to hold connections open longer. You can make this setting over the client connection if your mysql user has the rights to make that change, but I can't remember if you then need to restart the server or not. The timer was about 10 lines of code, and has been running well for me for about 5 years. Why try to improve on something that works reliably? Paul -- http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
