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
1742
July 09, 2015 10:27AM
763
July 09, 2015 10:36AM
766
July 09, 2015 10:52AM
715
July 09, 2015 03:41PM
738
July 09, 2015 10:13PM
769
July 09, 2015 10:37PM
764
July 09, 2015 11:48PM
657
July 10, 2015 08:30PM
628
July 14, 2015 11:11AM
719
July 14, 2015 11:50AM
667
July 14, 2015 01:37PM
712
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.