MySql localhost vs Amazon RDS instance -


i have surprise of mysql performance. when run simple query 'select 1;' on local host (mysql 5.6.x) using workbench, execute in 0.000s, same query ran on amazon rds (medium mysql 5.5.x) tooks 0.094s.

i can not understand behavior of mysql.

the query select 1 requires no parsing , no table access execution quick. remote servers there's time transmit request , shared resources rds not real-time resources, might take millisecond or 2 task executed. if there's no bigger difference ignore little time.


Comments

Popular posts from this blog

c++ - Function signature as a function template parameter -

algorithm - What are some ways to combine a number of (potentially incompatible) sorted sub-sets of a total set into a (partial) ordering of the total set? -

How to call a javascript function after the page loads with a chrome extension? -