Query locked at "Writing to net" state

[Lefebvre Denis]

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