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