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 --------------------------------------------------------------------- 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