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 : gg@stripped
gelugogancea@stripped
----- Original Message -----
From: "Luca Vertua" <tech@stripped>
To: <mysql@stripped>
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 <mysql-thread108226@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
