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
Do you have an idea or a line of inquiry?
Server config: Core2Duo, 4GB, 100Mbps, CentOS5.2. Mysql5
Thank you for your help,
|• Query locked at "Writing to net" state||Lefebvre Denis||29 Sep|