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
1802
July 09, 2015 10:27AM
795
July 09, 2015 10:36AM
810
July 09, 2015 10:52AM
755
July 09, 2015 03:41PM
782
July 09, 2015 10:13PM
797
July 09, 2015 10:37PM
803
July 09, 2015 11:48PM
689
July 10, 2015 08:30PM
661
July 14, 2015 11:11AM
760
July 14, 2015 11:50AM
702
July 14, 2015 01:37PM
753
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.