1 comment

[ 4.0 ms ] story [ 12.3 ms ] thread
When we talk about how SingleStore unifies transactions and analytics into a single database, and how fast it is at both, people understandably find it hard to believe at first - most database systems today do one or the other well, but not both.

Here are numbers to back up our claims, on the industry-standard benchmarks TPC-H (analytics) and TPC-C (transactions). SingleStore delivers state-of-the-art performance on both, compared to leading cloud data warehouses and a leading cloud operational database - SingleStore matches the data warehouses on TPC-H and matches the operational dbs on TPC-C, and does it with excellent scale-out performance in the cloud. On the other hand, the data warehouses couldn't even run TPC-C, and the operational database didn't finish TPC-H within 24 hours.

Not every workload needs the full spectrum of transactions and analytics, but modern applications increasingly need at least some of both. We think SingleStore is the general-purpose database system of the future, capable of running a breadth of workloads and unifying multiple disparate domain-specific database systems into one.

Check out the results at https://www.singlestore.com/blog/tpc-benchmarking-results/ and if you're interested, try out SingleStore for yourself - we published the benchmark materials in our github repo https://github.com/memsql/benchmarks-tpc