I have an application running on an ec2 m3 instance and mysql running on an dRDS instance. They're both in the same, region, VPC hwoever they appear to be in different availability Zones.
The issue is that running queries can be excruciatingly slow - I'm talking about delays that run above 700ms to over a second. I'm suspecting the delay is on account of connecting to the RDS server but am not particularly sure.
What exactly can I do to totally reduce / eliminate this delay. On my localhost the same queries take less than a quarter to half a millisecond at most. I've checked at off peak times with little to no traffic and even with a dump of my live data on my localhost. So the issue cannot be with regards to heavy traffic or data mass.
==EDIT===
Here are specs of the RDS instance:
Instance and IOPS
Instance Class: db.m3.medium
Storage Type: Provisioned IOPS (SSD)
IOPS: 1000 Storage: 100 GB