I'm having an issue with a very slow query in an C# WPF application. The application connects to a MySQL-server. As long as the application is used on my LAN, everything is going fast. When i use the application anywhere else, connecting to the DB over WAN, a simple query takes more than 10 seconds, not workable. The strange thing is that other services, like RDP, VNC, webhosting, streaming,... are working very fast over WAN, bandwidth can't be the problem i think.
This is the speedtest for the location where the server is: speedtest
What can i check/change to make this work better/workable over WAN?
Thanks in advance.