OT: MySQL Open/Close question

[william humphrey]

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 <
stephenREVOLUTION2 at barncard.com> 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
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.bluewatermaritime.com