3 ms·
Kdb+ is a time series database; and in my experience, for this work it is much, much faster than vertica, sql server and Monet.
by beagle3 8y ago
Kdb+ is a time series database; and in my experience, for this work it is much, much faster than vertica, sql server and Monet.
- halayli 8y agomapd beats it and iirc so does clickhouse.
- arnon 8y agoThere's no "This database beats that other database". There are a variety of use-cases, query profiles, workloads. There is no one-database-fits-all.
- coldtea 8y agoThere are however worse than others in all aspects.
- halayli 8y agoYes there is, and that's why tpc benchmarks exist. I didn't say there's a one-database-fits-all. But comparing kdb+ to mapd and clickhouse is a very reasonable comparison.
- arnon 8y agoTPC focuses on very specific scenarios. That's why there's more than one. There are also a variety of scale factors. A database that performs well on TPC-H SF 100 will not necessarily perform well on TPC-H SF 10000. One that performs well on TPC-H may be completely useless at TPC-DS. So, no.
- manigandham 8y agoAs listed in my comment, kdb+ is actually just a column-store, and like all column-stores it handles time-series really well. There's nothing stopping you from putting other data in there that doesnt have a time component at all, but it's designed to primarily work in the fintech space so has special performance optimizations and features for working with time and money.