Case Study: DENIC eG achieves 10x faster query times with ClickHouse

Why DENIC chose ClickHouse to power their data science platform allowing them to analyze data from a wide range of sources

DENIC eG, which operates and manages Germany’s .de domain namespace, needed a better way to analyze data from multiple sources for its data science platform. Its existing relational database setup was too complex to administer and too slow for large-scale analytics, with query times stretching from minutes to hours and putting strain on production systems. DENIC chose ClickHouse to support fast, low-maintenance analytics on a small, cost-effective cluster.

ClickHouse helped DENIC redesign its data model and queries around column-oriented storage, using replicated MergeTree-based tables and query optimizations to handle domain and holder data more efficiently. With guidance from ClickHouse support, DENIC reduced a key query from about 5 minutes to 30 seconds, improved overall query performance 10x in some cases, and maintained that performance even as the dataset grew to several hundred million records.

DENIC eG

Robin Gontermann

Business Data Analyst