Bob, on my last project I had some time-outs issues - I thought at the time it was more 'economical' to keep the connection open for multiple queries and I spend a whole bunch of energy making a "pinger" to keep the connection open -- That was probably true for the 65 or so rapid fire queries I was doing for a special app; open , do 65 queries, close. But I found that leaving the connection open all the time was really pointless - there isn't that much latency in the opening and closing of connections - most of the time is spent funneling textual data to the client - the database. In the end I now think that closing often is good - it releases the server when not needed. ------------------------- Stephen Barncard San Francisco http://houseofcubes.com/disco.irev
On 4 February 2010 16:05, Bob Sneidar <b...@twft.com> wrote: > Hi Jim. > > Thanks for the info. I'm always in the hunt for a good mySQL utility. The > original post was really about what happens when on-rev drops the connection > due to an idle timeout. What happens is, the communication between > Revolution fails, but it takes close to 10 minutes for Revolution to stop > beach balling. This may or may not be typical of all mySQL servers, but when > I ran all this on a local mySQL server I did not have these timeout > problems. I was alerted right away that the connection was bad. > > My particular application merges and syncs two databases with each other, > so it becomes important to create and drop tables automatically, as well as > insert columns and such. So simply using a utility to do these things will > not get me there. > > My fix of always connecting at the beginning of every script that needs > access, and disconnecting at the end of every script that made the > connection works for now. It's probably better to do this anyway, as we have > an online grading system at our K-12 school that requires persistent > connections, and fails if anything glitches or burps on the network. I can > never reset the routers or switches during school hours without incurring > the wrath of school admins. :-) > > Thanks. > > Bob > > > On Feb 4, 2010, at 3:44 PM, Jim Bufalini wrote: > > > Bob and Sarah and anyone else using MySQL, > > > >> I have used a MySQL database via On-Rev and it has seemed very fast > >> for both reading & writing, but I did all the setup through cPanel and > >> phpMyAdmin first. > > > > The cPanel and phpMyAdmin is "OK" in that it works, but I find it very > > clumsy. Check out MySQL Workbench (the Community Edition) at > > http://mysql.com/products/workbench/. It's completely free, > cross-platform > > (PC, Mac, Linux), runs from your desktop, and has one of the best ER > > Modeling modules I've ever seen. At this point you can download version > 5.1 > > or 5.2 (which is considered beta) but I have found it very stable and > it's > > quite different from 5.1. > > > > Aloha from Hawaii, > > > > Jim Bufalini > > > > _______________________________________________ > > use-revolution mailing list > > use-revolution@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-revolution > > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution