DB with best inserts/sec performance?

Question

We deploy an (AJAX - based) Instant messenger which is serviced by a Comet server. We have a requirement to store the sent messages in a DB for long-term archival purposes in order to meet legal retention requirements.

Which DB engine provides the best performance in this write-once, read never (with rare exceptions) requirement?

We need at least 5000 Insert/Sec. I am assuming neither MySQL nor PostgreSQL can meet these requirements.

Any proposals for a higher performance solution? HamsterDB, SQLite, MongoDB ...?

user_9786377 · Answer

Use Event Store (https://eventstore.org), you can read (https://eventstore.org/docs/getting-started/which-api-sdk/index.html) that when using TCP client you can achieve 15000-20000 writes per second. If you will ever need to do anything with data, you can use projections or do the transformations based on streams to populate any other datastore you wish. You can create even cluster.

DB with best inserts/sec performance?

11 Answers