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?