Much Faster. Even on CPUs.

Kinetica is blazing fast on a GPU but even on CPUs we continue to outperform leading analytical databases in TPC-DS benchmarks.

Benchmark Summary from Radiant Advisors

TPC-DS benchmark comparison chart showing Kinetica performance versus other analytical databases

Comparisons are made to Kinetica from a geomean of the queries that a database was able to run. So Clickhouse was 13x slower overall on the 8 queries it was able to successfully complete.

Kinetica is 9X faster than Clickhouse

Kinetica

Clickhouse

The TPC-DS Benchmarks were run on the following hardware: 40 CPU cores, 384GB of memory (Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz)

Kinetica Version: 7.2.12|Clickhouse: 25.1.7.20-stable|Last updated: March 11th, 2025

	Q1	Q2	Q3	Q4	Q5	Q6	Q7	Q8	Q9	Q10	Q11	Q12	Q13	Q14	Q15	Q16	Q17	Q18	Q19	Q20	Q21	Q22	Q23	Q24	Q25
Kinetica	0.7	1.2	9.5	0.6	1.6	6.1	0.9	1.4	2.2	17.9	0.5	1.6	0.3	0.9	1.4	1.5	0.6	0.4	2.6	8.6	0.9	1.1	1.2	1.6	1.6
Clickhouse	1.5	3.1	140	1.3	6.6	140	140	7.8	14.3	0.2	0.4	140	140	140	17.8	3.7	140	2.9	140	24.9	2.3	3.1	4.2	1.4	140

	Q26	Q27	Q28	Q29	Q30	Q31	Q32	Q33	Q34	Q35	Q36	Q37	Q38	Q39	Q40	Q41	Q42	Q43	Q44	Q45	Q46	Q47	Q48	Q49	Q50
Kinetica	2.5	0.9	2.5	1.3	9.2	1.3	1.4	3.1	6.6	36.1	2.6	0.8	7	1.2	0.5	2.5	4.1	24.5	0.6	0.6	16.9	3.5	1	2.9	1.9
Clickhouse	140	2.5	140	3	8.1	140	140	2.1	3.8	121	8.7	140	18.3	140	1	12.1	140	140	140	12.1	16.2	140	140	9.2	6.3

	Q51	Q52	Q53	Q54	Q55	Q56	Q57	Q58	Q59	Q60	Q61	Q62	Q63	Q64	Q65	Q66	Q67	Q68	Q69	Q70	Q71	Q72	Q73	Q74	Q75
Kinetica	17.5	3.9	3.3	14.2	16.8	1.1	0.4	0.9	0.6	1	0.6	0.1	0.8	0.5	0.5	3.7	2.1	24.2	58.9	2	7.7	3.3	0.8	1.6	0.5
Clickhouse	140	5.5	12.2	21.6	2.7	2.9	5.1	140	3.9	5	3.8	140	4.5	140	140	14	140	33.5	140	140	22.4	3	2.8	8.6	140

	Q75	Q76	Q77	Q78	Q79	Q80	Q81	Q82	Q83	Q84	Q85	Q86	Q87	Q88	Q89	Q90	Q91	Q92	Q93	Q94	Q95	Q96	Q97	Q98	Q99
Kinetica	0.5	10.8	11.8	2.8	0.9	0.3	1.2	0.6	1.1	5.2	0.6	2.2	14.6	1	1.4	1.5	2.9	3.9	25.3	2.5	1.3	0.5	0.5	5	1.4
Clickhouse	140	38.4	21.2	140	2.6	0.7	6.7	3.9	2.9	3.4	1.7	140	36.4	2.6	4.2	140	11.7	9.3	123	2.9	4.7	0.7	5.8	140	1.9

View the Individual TPC-DS Queries Here

What is notable from these results?

Vectorized architecture delivers performance

Kinetica's unique native vectorized join engine is able to process chunks of data in parallel, rather than sequentially working through rows of data line by line. This delivers very quick results, particularly with complex ad-hoc analysis of complex data.

Mature database capable of running complex SQL

Kinetica has been in development for over a decade. It is mature and battle-tested and able to reliably parse and deliver results on complex SQL queries. Kinetica is typically able to run all 99 queries of the TPC-DC harness.

Geospatial and time-series capabilities also included

Kinetica fast, real-time capabilities extend out to it's versatile suite of functionality for time-series and geospatial analysis, as well as graph query modes, and easy to use notebook tools for building multi-step queries.

Talk to Us!

The best way to appreciate the possibilities that Kinetica brings to high-performance real-time analytics is to see it in action.

Contact us, and we'll give you a tour of Kinetica. We can also help you get started using it with your own data, your own schemas and your own queries.