I used to use MySQL but now I use Valentina and find an incredible difference in speed. Perhaps you should consider running some tests with Valentina too?
On Fri, May 29, 2009 at 2:33 PM, stephen barncard < [email protected]> wrote: > I've been both working with MySQL and on this list for some time but never > asked about this: > How much overhead is involved with opening and closing a MySQL connection? > Before I run some benchmarks I'd like to get other opinions. > > For instance, in an app I have a recursive handler than may make upwards of > 66 queries in rapid succession. Each query depends on the previous query > for > the next. I want to see this information returned as soon as possible. > > At this time I just try to keep the connection open with a ping every few > minutes. This works well on my machine, but working with a MySQL server on > the net tends to disconnect, even though the timeout at the server is set > to > a high number. > > If I would open and close the connection for each of the rapid queries, > isn't that generating more work for the server? Or does it really matter? > > What's the 'best' way of dealing with opening / closing' in MySQL? > > thanks > ------------------------- > Stephen Barncard > Swervedriver Fan > San Francisco > http://barncard.com > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > -- http://www.bluewatermaritime.com _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
