4 ms·
This sounds great compared to my anecdotal experience with DB write performance; but is there a collection of database performance benchmarks that this can be e
by maliki 12y ago
This sounds great compared to my anecdotal experience with DB write performance; but is there a collection of database performance benchmarks that this can be easily compared to?
The best source for DB benchmarking I know of is http://www.tpc.org/ http://www.tpc.org/. The methodology is more complicated there, but the top results are around 8 million transactions per minute on $5 million systems. This FoundationDB result is more like 900 million transactions per minute on a system that costs $1.5 million a year to rent (so, approx $5 million to buy?).
The USD/transactions-per-minute metric is clear, but without a standard test suite (schema, queries, client count, etc.), comparing claims of database performance makes my head hurt.
- Dave_Rosenthal 12y agoI think you mean "900 million transactions per minute". Of course that overstates things since each TPC-C transaction entails a lot more than one write. TPC-C is about 2/3 read and 1/3 write, and each TPC transaction might do 20 low-level read+write operations (I'm actually not sure, but I think that's in the ballpark.) In the NoSQL world many people have converged on a workload of 90% reads/10% writes to individual keys. We show 90/10 results on our performance page [1] but in this test we do 100% writes to stress the "transaction engine", which processes writes. Since we have our SQL Layer [2] as well, we will run some more-comparable SQL tests in the future. [1] https://foundationdb.com/key-value-store/performance https://foundationdb.com/key-value-store/performance [2] https://foundationdb.com/layers/sql https://foundationdb.com/layers/sql
- maliki 12y ago(Ah, yes, thank you, 900 million per minute. I typo'd.) Nice performance page. It pre-answers my follow up question, which was how linear is scaling with more cores? Looks solid.