Performance

Jul 17, 2025 System Design 38 min read

System Design (4): Caching — Where to Cache, What to Evict, and When Caching Hurts

A deep dive into caching strategies across every layer of the stack — from CDN to database buffer pools — covering cache-aside, write-through, write-behind patterns, eviction policies, thundering herd mitigation, and …

Apr 19, 2024 Databases 36 min read

Databases (2): Indexing and Query Planning — How Databases Find Your Data

Deep dive into B-tree and B+tree indexes, hash indexes, composite indexes, covering indexes, and how to read EXPLAIN output to diagnose slow queries.

Apr 27, 2022 Python Engineering 36 min read

Python Engineering (8): Performance — Profiling, Caching, and Knowing When to Stop

Profile Python code to find real bottlenecks, apply caching and vectorization where they matter, and avoid the trap of premature optimization.