Here's my scenario: I've got a Light server located through Amazon . com AWS that's located in america East region. That web server connects to some local mysql DB and everything runs rapidly and easily. I lately installed Apache on my small computer in order to develop in your area and arrange it for connecting towards the DB around the live server rather than establishing a database in your area.

The issue is, the demands from the local machine towards the DB server are slow. I examined 5 queries choosing a restriction of just one, 10, 100, 1000, and 10000 from the random table. Listed here are my results:

Production server hooking up in your area:

Total time : 0.1961 seconds
Connection : 0.069 seconds
Query Limit 1 : 0.0001 seconds
Query Limit 10 : 0.0001 seconds
Query Limit 100 : 0.0003 seconds
Query Limit 1000 : 0.002 seconds
Query Limit 10000 : 0.1246 seconds

My comp hooking up remotely:

Total time : 8.2012 seconds
Connection : 0.813 seconds
Query Limit 1 : 0.2133 seconds
Query Limit 10 : 0.3243 seconds
Query Limit 100 : 0.8209 seconds
Query Limit 1000 : 1.2209 seconds
Query Limit 10000 : 4.8088 seconds

Listed here are my ping leads to stated server:

Reply from xx.xx.xx.xxx: bytes=32 time=117ms TTL=42
Reply from xx.xx.xx.xxx: bytes=32 time=120ms TTL=42
Reply from xx.xx.xx.xxx: bytes=32 time=126ms TTL=42
Reply from xx.xx.xx.xxx: bytes=32 time=116ms TTL=42

Ping statistics for xx.xx.xx.xxx:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 116ms, Maximum = 126ms, Average = 119ms

And here's the table description:

col1    mediumint(9)    unsigned NO    PRI    NULL    auto_increment
col2    varchar(128)             YES          NULL
col3    varchar(100)             NO    MUL    NULL  
col4    mediumtext               YES   MUL    NULL  
col5    tinyint(1)               YES   MUL    0 

I know of the skip_title_resolve mysql variable and also have place it to ON, however i did not use whatever enhancements. Is just a latency/bandwith problem between my comp (US West Coast) towards the DB server? Ideally Let me continue dealing with the remote db, but must i just make use of a local copy from the DB rather?