Hi,
My opinion:
For sure is not a bug.
Perhaps the client lock the table for read/write before access the table and
remain locked until retrieve data.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Luca Vertua" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 6:34 PM
Subject: One slow connection make mysql slow
> I use mysql to register data in an accounting system, comunications
> happen in a 200 Mbit network and database is really fast, so lock
> situation ( ie delete after a long select ... ) is really fast and
> does not create problems. When I connect from a dialup connection
> obviously query take the same time but sending results to me may take
> 30 seconds. The problem is that mysql locks the table up to the end of
> the data sending process so other local client can't work. Is this a
> bug? Are there a logical explanation?
> Thanks for your help
>
> Luca
> mysql, sql
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
