B-trees and database indexes — PlanetScale
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
Caching — PlanetScale
planetscale.comSaved July 9, 2025
Summary
Caching improves computer and application performance by storing frequently accessed data in faster, but smaller, storage such as RAM or CPU cache layers.
The method relies on principles like temporal locality (recent data is more likely to be reused) and spatial locality (data near recently accessed items is likely to be needed soon). Effective caching trades off between speed, cost, and storage capacity, with various strategies like prefetching related data and using multiple cache layers to optimize performance across local computers and distributed cloud environments.
