paulserban.eu

Writing Edition

Paul Serban

Writing, snippets & book notes

Vol. 2026

Tag Archive

Database Performance

Archive for this tag.

Posts

Post · March 02, 2023

How to Design High-Performance Pagination Algorithms for APIs and Databases

Master pagination algorithms for APIs and databases-offset, keyset, cursor-based-with performance optimization, scalability patterns, and real-world implementation examples.
Read →
Post · January 12, 2023

Pagination Patterns Explained: Offset vs Cursor vs Keyset (With Real-World Tradeoffs)

Learn offset, cursor, and keyset pagination with real-world examples, SQL code, and performance tradeoffs to make better decisions in scalable system design.
Read →