Right, this is the final straw.
We have be suffering heavily with this MySql Latency issue for months now.
Its gotten so bad that their are functions within our application that can no longer be used.
Let me give you the run down of our setup.
User logs into PC, PC has a C# application that utilises the MySql Connector to connect to a database hosted on a remote site. So user opens application, Logs In (This is a verification of user details on the remote site using MySql Connector). The application obviously sends the connection on port 3306, it goes through 1 switch, then through our router, out to our broadband line, and in to the web, where it gets routed to our remote site which hosts the MySql Database, and obviously makes the connection.
Periodically, and in particular today, we get enormous connection lag, to the point where the application is completely un-usable. This app is a central part to our companies functioning so its a very critical that we get this fixed.
Another observation has shown that our Office in New York in the United States, experiences absolutely no latency/lag issues when connecting to the database with the same application. Even during the times were our application in the UK is slamming the ground and getting rug burn, the US site is running crystal clear without any problem whatsoever.
I have done broadband speed testing, connection performance testing, rebooting the database, purging the connections, rebooting our router, checked mysql database configurations (which should make a difference anyway since the US site doesnt have any problems).
Also, our website utilises the same database, and again absolutely no problems there, its always running fine. (I always check the website, and the US site when we are having these lag issues).
A tracert to the remote site shows lots of time outs from our building, but from the US site there is no timeouts. I dont know if this is at all relevant.
At the present moment our download speed shows ~5000kbps with 663 kbps upload speed.
And at this very moment, we are having enormous lag issues with the program.
I am at my wits end and this whole thing is going to make my hair fall out.
MySql Database Version 5.0.45
MySql Connector Version 22.214.171.124 (Runtime Version v2.0.50727)
Personally, the whole thing seems to point at some routing problem in the web somewhere, but I dont really know. Its such a nightmare, and if it IS the web, we are basically up the creak without a paddle because there is absolutely nothing we can do about it. Unless there is someway to choose the specific route that the application takes to the remote site.
I once thought it might be the application, but I have done extensive testing that shows that this is not the case. The code can simply be 4 lines of code, essentially just declaring a new MySql Connection, and then opening the connection, I have tested this and we still get the same problem.
I would really, really appreciate it if someone can resolve this issue for me.