Query locked at "Writing to net" state
am 29.09.2010 15:21:26 von Lefebvre Denis--------------050808020903030100060708
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hello,
I have a Windows Delphi application (Zeos component) which makes a
request on a remote MySQL database. The server is in France.
On a Windows workstation that is located in France (500 kilometers), the
application works well despite the 200,000 records to retrieve.
The same application is not working on workstations on various ADSL
connections in Israel.
In the MySQL process list, the application remains in state "writing to
net" and never goes out "sending data". While in France, "writing to
net" is fast and followed by "sending data".
The same query in MySQL Workbench operates seamlessly in Israel and in
France.
Do you have an idea or a line of inquiry?
Server config: Core2Duo, 4GB, 100Mbps, CentOS5.2. Mysql5
Thank you for your help,
Regards,
Denis
--
Denis Lefebvre
--------------050808020903030100060708--