Remote MySQL Query takes a long time to run
Running a MySQL query on a local database takes only about 20-30ms but running the same query through a remote connection(internet) takes 500ms. Is this normal? If not what could be the possible reason for such delay?
This is a wireshark time extract for a particular Query run remotely.
Time -195.768993000 --- Request Ping
Time -195.909453000 --- Response OK
Time -195.909729000 --- Request Use Database
Time -196.049567000 --- Response OK
Time -196.049918000 --- Request Query
Time -196.219660000 --- Response
Subject
Views
Written By
Posted
Remote MySQL Query takes a long time to run
1990
July 09, 2015 10:27AM
887
July 09, 2015 10:36AM
911
July 09, 2015 10:52AM
847
July 09, 2015 03:41PM
881
July 09, 2015 10:13PM
885
July 09, 2015 10:37PM
903
July 09, 2015 11:48PM
776
July 10, 2015 08:30PM
768
July 14, 2015 11:11AM
864
July 14, 2015 11:50AM
827
July 14, 2015 01:37PM
832
July 14, 2015 02:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.