[supermatt]

Nope, single digit millisecond performance for me on those nodes when the tables are cached - anything else and you are complaining about performance of the storage medium.

[tpxl]

How much data? We were doing a few million writes/day on peak days and the nodes couldn't keep up.

[supermatt]

A few million writes a day is still well within the write performance of one of those nodes. But... we were talking about querying the data, no?

[tpxl]

Well yes, but if your database is busy writing, it's going to have less time for reading.

[supermatt]

I'm not sure what your point is. You said the nodes are slow. They are not slow, and will handle thousands of requests a second when configured correctly.

If you arent getting that then you are doing something big, something inefficient, or something stupid - and that would be the same on any size node.

Size your instances accordingly.