MySQL Forums
Forum List  »  MySQL for Visual Studio

Remote MySQL Query takes a long time to run
Posted by: Shyamal Parikh
Date: July 09, 2015 10:27AM

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

Options: ReplyQuote

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.