We've done a lot of tuning focused on web applications already, our experience is that mostly people with problems just need to add an index.

Performance depends on where you are querying from. We've found that if you are inside EC2 network overhead is typically <1ms.