WRITING / NOTES FROM THE FORGE

Performance

2 articles tagged Performance.

Partitioning and Clustering: How to Make Warehouse Queries Faster

Data partitioning for faster queries: how partition pruning works, pick partition keys, avoid the small files problem, and when clustering or Z-ordering helps.

Sep 19, 20267 min read

System Design Caching Performance

Caching Strategies Explained: Cache-Aside, Write-Through, and More

Caching strategies compared: cache-aside, read-through, write-through, write-behind, and write-around, with trade-offs, code, and when to use each.

Aug 8, 20266 min read