I have an m4.10xlarge
EC2 instance and a AWS RDS, both running MySQL 5.7 with same data.
I tried running a few complex queries (cross joins, nested select) on them, and found that the EC2 instance has consistently better performance (lower duration and fetch time).
Can I safely conclude the EC2 database, which has more CPUs, has better performance than RDS, which has Provisioned IOPS (SSD)?
RDS specs: