Database Optimization

How Partial Indexes Affect UPDATE Performance in Postgres

Based on a true story

Partial index is a good way to save some disk space and improve record lookup performance. The common rule is “use it when you can afford it” — in other words, if all your queries…

Redis Hotspot Key Discovery and Common Solutions

Improving Redis Performance through Multi-Thread Processing

Optimisation is Key: Track Those Slow Running Queries (PostgreSQL)

Database index : B+Tree vs Hash

Berawal dari tugas kuliah basis data, saya ingin membagi hasil tugas saya disini :D.

Index digunakan untuk mengoptimalkan pencarian data pada database. Terdapat banyak cara untuk melakukan indexing dan yang saya bahas disini adalah B+Tree dan Hash…

How Alibaba Cloud Redis Can Be Used for High-Concurrency and Low Latency Scenarios

Avoid N+1 Query Problem in OutSystems

There are elements that when combined can do more harm than good. I’m not talking about…

How We Scaled Our User Import Task Using Bulk Operations

Neo4j 4.x Query Logging Enhancements

How the Query Log Analyzer 1.0.2 allows you to make use of these

Analysis on Group by and Order by Performance

We will explore 3 potential solutions to solving slow…