5 ms·
And of course, how does it compare to kdb? So it seems less expensive, but also lacks the advanced query language. The last tests I saw for kdb was the 1.1 bil
by jnordwick 9y ago
And of course, how does it compare to kdb? So it seems less expensive, but also lacks the advanced query language.
The last tests I saw for kdb was the 1.1 billion taxi ride.
http://tech.marksblogg.com/billion-nyc-taxi-kdb.html http://tech.marksblogg.com/billion-nyc-taxi-kdb.html
Where it basically outperformed every other CPU based system with slightly more complex queries.
Any comparisons planned?
- manigandham 9y agoIt'll be faster than Redshift and about the same as ClickHouse, +/- depending on hardware and setup. It's a great system, we used it for 2 years and it's one of the most polished databases out there with a simple MySQL interface. It's more general purpose than kdb, with a nice rowstore + columnstore architecture. I believe they're adding full-text search indexes in the latest version too. If you need the query language, the advanced/asof joins, or the tightly integrated query/process environment, then there's no match to kdb though.