No, QuestDB is not Faster than ClickHouse

Re:No, QuestDB is not Faster than ClickHouse by Dzugaru on Thursday June 16, 2022 @03:05PM (#31769703)

"while QuestDB utilizes its full indexing strategy to read just a tiny fraction of the actual data"

Can you please elaborate on this?

[ Parent | on HN ]

Re:No, QuestDB is not Faster than ClickHouse by bluestreak on Thursday June 16, 2022 @03:13PM (#31769786)

Full disclosure: I am CTO of QuestDB and I took part in JIT implementation. The quote above is not mine, it was written by Clickhouse staff. "utilizes its full indexing strategy" statement is false and is news to me.

[ Parent | on HN ]

Re:No, QuestDB is not Faster than ClickHouse by Dzugaru on Thursday June 16, 2022 @03:51PM (#31770150)

So you do a full scan and it's ~50 CPU cycles per row (48 CPUs at 4 GHZ), correct? This is possible I guess? And in this case Clickhouse is wrong.

[ Parent | on HN ]

Re:No, QuestDB is not Faster than ClickHouse by pepemon on Thursday June 16, 2022 @03:29PM (#31769949)

So, QuestDB is faster or not? I'm puzzled now!

[ Parent | on HN ]

Re:No, QuestDB is not Faster than ClickHouse by olluk on Thursday June 16, 2022 @03:51PM (#31770145)

Looks like QuestDB is faster if you don't optimize your table storage for 1 query.

But if you are okay that only limited number of columns to be scanned faster than others ClickHouse comes first.

[ Parent | on HN ]