EC2 Small vs Amazon RDS - which is faster for MySQL?
(I have one database, well-indexed and tuned. About 10,000 rows on each table.)
How's the performance like?
Firstly, I don't use RDS - so don't take this as an absolute. As with EC2, RDS is classed by instance type, so in terms of computing you get the same thing. The difference comes down to 'configuration' and the degree to which the hardware is dedicated.
I'd suggest the following:
For any specific use case, the best option is probably to benchmark each and see how they stack up - performance will vary for each setup afterall.