hmmm… interesting idea. That would certainly isolate whether or not the problem was one with sqlYoga, if I used Livecode API to do a time query. If it succeeds and an sqlYoga query times out, that would give me a vector on the problem. If a simple query fails using the LC API, then I would know it’s some kind of host connectivity issue.
Thanks for the suggestion. Bob On Feb 2, 2014, at 11:45 , stephen barncard <stephenrevoluti...@barncard.com> wrote: > On Sun, Feb 2, 2014 at 11:34 AM, Bob Sneidar > <bobsnei...@iotecdigital.com>wrote: > >> What I need is a way to check for the availability of the database without >> actually running a query. My gut feeling is that there is not without >> invoking the dreaded 1 minute timeout, so the real question is, can I >> adjust the amount of time Livecode will wait before giving up? > > > have you tried some queries NOT using SQL yoga? > > I thought most timing stuff was on the server side… > > regarding a reliable 'ping': > I know there are non-storage mySQL commands like time and calculations that > would be very small blips… I assume you've tried those. > > it's been a while since I did much mySQL work.. and I used Trevor's earlier > 'abstraction layer' libraries that I needed to hack for my own purposes. > > *--* > *Stephen Barncard - San Francisco Ca. USA - Deeds Not Words* > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
