Short answer: Yes.
On Tue, Jun 4, 2013 at 6:00 PM, Mike Copeland <m...@ggisoft.com> wrote: > My VFP app connects to a MYSQL (soon to be a MariaDB) server running on a > dedicated Linux box via the Internet. My current design is that when the > app starts up it connects to the MySQL server and then keeps that > connection 'live' by using a timer every 15 minutes, sending 'SELECT > @@identity' in case there is no user activity. > > I'm running into frequent situations where the workstation's Internet > connection seems to be getting dropped briefly (by the ISP) and the next > attempt to access the server by the app on that workstation will trigger > "there is no connection" errors. (loosely paraphrased) The app then > reconnects and moves along. > > Would it be smarter to > - connect when needed > - send/get data needed > - disconnect > each time I need to access the server? I had avoided this assuming it > would slow things down during the connection process, but, maybe this would > be preferable? > > I know that testing is the best way to figure this out, but I'm sure this > is old stuff to many of you and you've already been there done that. > > Thanks for any wisdom or opinions. > > Mike Copeland > > ______________________________**_________________ > Post Messages to: ProFox@leafe.com > Subscription Maintenance: > http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox> > OT-free version of this list: http://mail.leafe.com/mailman/** > listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech> > Searchable Archive: > http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox> > This message: http://leafe.com/archives/**byMID/profox/51AE636B.6050800@** > ggisoft.com<http://leafe.com/archives/byMID/profox/51ae636b.6050...@ggisoft.com> > ** 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. > > Report [OT] Abuse: http://leafe.com/reportAbuse/** > 51ae636b.6050...@ggisoft.com<http://leafe.com/reportAbuse/51ae636b.6050...@ggisoft.com> > -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4sSagJ9BV1T46GaYH0a1=pmvsrph0hi3xzuuj7yvft...@mail.gmail.com ** 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.
