up vote 0 down vote favorite
share [g+] share [fb]

Let's assume that it was only writes.
Each "document" inserted is less than 140 characters.

How many writes can this database handle?

link|improve this question
84% accept rate
Per second ? As a whole ? Are you sure you're never ever going to read them ? I'd do bench that with some mock data. Where will the data stored ? On an EBS disk ? On the ephemeral disk ? At least, you could probably write more than 10 millions record I guess. Honestly, If you don't plan to read them, you can probably fill up your disk with these documents and the server could still handle them... – Oct Jun 28 '11 at 22:03
feedback

1 Answer

up vote 0 down vote accepted

EC2 is notorious for inconsistent throughput. There is no way to answer this question reliably, and even testing this in "production" is going to be problematic because of the varied nature of your platform.

If you want to load-test your application, you need a different platform, and really should be using a hosted (or better, leased) server environment.

With that said, to maximize throughput, use SSD drives, ensure that at least your indexes can remain in memory and that they're useful indexes (though keeping your indexes + db in memory is even more ideal), and shard. (Keep in mind that sharding increases complexity, especially on the backup/recovery front.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.