Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a MySQL database hosted in a server in Brazil.

When I connect through an ODBC connection (FE is access) with a Brazilian IP everything runs fine.

When I connect from the U.S. with the same connection performance slows down dramatically.

Any suggestions?

share|improve this question

1 Answer 1

If you have a lot of back-and-forth between your front-end and your database, network link latency could kill your application's performance.

Measure ping times between your US front-end and your Brazilian database server. Your front-end needs to wait for that round-trip time for each and every database access (sometimes more than once per request).

If this is indeed your problem, then I'm afraid there is no easy fix for latency generally speaking (unless you can find a provider that has a more direct route to your Brazilian endpoint). Adding more "bandwidth" (Mb/s) won't solve high latency issues.
You need to keep your front-end closer to your database, or reduce the number of database calls.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.