Tag: database optimization

Posts tagged "database optimization"

← All posts

Working with ClickHouse® LowCardinality and Enum Types

Learn how to use ClickHouse® LowCardinality and Enum types to optimize storage, improve query performance, and choose the right data type for analytical workloads.

July 11, 20267 min read

Advanced ClickHouse® Dictionaries: Working with External Data Sources

Learn how to use advanced ClickHouse® Dictionaries with external data sources to accelerate lookups, reduce expensive JOINs, and build faster analytical workloads.

July 9, 20268 min read

Benchmarking ClickHouse®: Tools & Methodologies

Learn how to benchmark ClickHouse® correctly using industry-standard tools, realistic workloads, and proven methodologies to measure performance accurately.

July 8, 20266 min read

ClickHouse® Query Profiling: Identifying Bottlenecks

Profile queries in ClickHouse® to identify CPU, memory, I/O, and network bottlenecks for faster query performance. (

July 4, 20267 min read