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
Post a Comment