Some Notes on Why to Use Clickhouse

In this post I try to justify with my reasons why one should use Clickhouse as a their main OLTP Database for massive analytics work loads with millisecond latency on scanning billions of rows. In…

Indexes in MySQL

Indexes in MySQL (Mysql indexes) are a great tool for optimizing SQL queries. To understand how they work, let’s look at working with data without them. Reading data from disk Files are stored in hard drive…

TPC-DS Benchmark On Clickhouse Part 1

ClickHouse ClickHouse is an open source, columnar-oriented database that’s been developed primarily by engineers at Yandex. Yandex is one of Europe’s largest Internet-focused businesses. There search engine alone was receiving 150 million searches a day in 2012. ClickHouse…

Columnar database vs Row based database

Columnar database vs Row based database Columnar database is built for Data Analytics(Small/Big/Bigger) data – OLAP Online Analytical Processing Let us see how analytical queries get benefited by storing data in column oriented database against…