Hi,
I think it's better to lock the table before to "delete".If you offer more
details.... maybe we can help.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Luca Vertua" <[EMAIL PROTECTED]>
To: "Gelu" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 7:52 PM
Subject: Re: One slow connection make mysql slow
> Ok, I'm agree with you, someone know how to avoid this?
> Why mysql does not retrive data in the buffer before send them on network?
> My query is about 400 Kbyte.
>
> Luca
>
> ----- Original Message -----
> From: "Gelu" <[EMAIL PROTECTED]>
> To: "Luca Vertua" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, May 07, 2002 6:45 PM
> Subject: Re: One slow connection make mysql slow
>
>
> > 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
