BestHub
Sign in
Tagged articles

keyset pagination

10 articles · Page 1 of 1
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Sep 21, 2026 · Backend Development

Why Your API Slows Down: 8 Critical Bottlenecks in Spring Boot Performance

This article analyzes eight common API performance bottlenecks in Spring Boot applications, including N+1 queries, improper entity returns, missing indexes, JOIN FETCH pagination issues, in-memory filtering, deep pagination, long transactions, and caching strategies, with code examples and optimization techniques for each.

API performanceCachingDTO projection
0 likes · 14 min read
Why Your API Slows Down: 8 Critical Bottlenecks in Spring Boot Performance
dbaplus Community
dbaplus Community
Aug 30, 2026 · Databases

Why OFFSET Pagination Slows You Down: Switch to Keyset and Cut Latency from Seconds to Milliseconds

The article recounts how an API that originally used OFFSET pagination suffered 2‑3 seconds response time, and after rewriting the query to Keyset (Seek) pagination—adding a secondary sort key for stability and exploring cursor pagination, index‑only OFFSET, and materialized views—the same endpoint now responds in under 200 ms, with detailed benchmark comparisons.

Cursor PaginationMaterialized ViewsPerformance Optimization
0 likes · 7 min read
Why OFFSET Pagination Slows You Down: Switch to Keyset and Cut Latency from Seconds to Milliseconds
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 27, 2026 · Backend Development

Why Your Deep Pagination Is Slow: LIMIT OFFSET vs Keyset Pagination in Spring Boot

This article analyzes the performance bottleneck of LIMIT OFFSET deep pagination in MySQL with millions of rows, demonstrates EXPLAIN plan analysis, compares traditional pagination, subquery, covering index, and keyset pagination approaches, provides Spring Boot implementation examples for MyBatis-Plus and JPA, and benchmarks showing keyset pagination maintains constant response time regardless of page depth.

Cursor PaginationDeep PaginationLIMIT OFFSET
0 likes · 22 min read
Why Your Deep Pagination Is Slow: LIMIT OFFSET vs Keyset Pagination in Spring Boot
Architect-Kip
Architect-Kip
Nov 21, 2025 · Backend Development

Mastering Pagination Performance: Single‑DB and Cross‑DB Strategies

This guide explores common pagination bottlenecks and presents practical solutions for single‑database and sharded environments, covering keyset pagination, bidirectional paging, join‑based paging, index design, middleware rewriting, approximate paging, and two‑phase query techniques.

SQLkeyset paginationmiddleware
0 likes · 14 min read
Mastering Pagination Performance: Single‑DB and Cross‑DB Strategies
ITPUB
ITPUB
Sep 6, 2025 · Databases

Why OFFSET Slows Your API and How Keyset Pagination Boosts Speed

The article explains how using OFFSET for pagination can cause severe performance degradation as data grows, and demonstrates how switching to keyset (seek) pagination, optionally combined with cursor encoding, index‑only OFFSET, or materialized views, dramatically reduces query latency.

Database OptimizationMySQLPostgreSQL
0 likes · 8 min read
Why OFFSET Slows Your API and How Keyset Pagination Boosts Speed
Lobster Programming
Lobster Programming
Apr 28, 2024 · Databases

How to Solve MySQL Deep Pagination: Causes and 6 Effective Optimization Strategies

Deep pagination in MySQL becomes a performance bottleneck when tables reach millions of rows, causing excessive row scans and costly index lookups; this article explains its root causes and presents six practical optimization techniques—including keyset pagination, delayed joins, covering indexes, data partitioning, and external search engines—to dramatically improve query speed.

Covering IndexDeep PaginationIndexing
0 likes · 7 min read
How to Solve MySQL Deep Pagination: Causes and 6 Effective Optimization Strategies
NiuNiu MaTe
NiuNiu MaTe
Apr 14, 2021 · Databases

Why MySQL OFFSET Is So Slow and How to Fix It

This article examines why MySQL pagination with large OFFSET values becomes painfully slow, explains the underlying B+‑tree index mechanics, and presents two practical solutions—keyset pagination and index‑covering subqueries—to dramatically improve query performance.

B+ TreeCovering IndexMySQL
0 likes · 8 min read
Why MySQL OFFSET Is So Slow and How to Fix It
Code Ape Tech Column
Code Ape Tech Column
Mar 15, 2021 · Databases

Why Large OFFSETs Slow MySQL Queries and How to Fix Them

A developer discovers that massive OFFSET values in MySQL pagination cause full‑table scans and severe latency, then reproduces the issue with simulated data, benchmarks the slowdown, and presents three practical solutions—including index‑covering subqueries, cursor‑based pagination, and offset limits—to restore query performance.

Index OptimizationLarge OFFSETMySQL
0 likes · 16 min read
Why Large OFFSETs Slow MySQL Queries and How to Fix Them
IT Architects Alliance
IT Architects Alliance
Aug 29, 2020 · Databases

Why OFFSET/LIMIT Pagination Breaks at Scale and How to Use High‑Performance Keyset Pagination

The article explains why traditional OFFSET and LIMIT pagination becomes inefficient for large tables due to full‑table scans, demonstrates the performance gap with real‑world examples, and presents keyset (cursor‑based) pagination as a fast, index‑driven alternative with practical query patterns.

Database OptimizationOFFSET LIMITPerformance
0 likes · 6 min read
Why OFFSET/LIMIT Pagination Breaks at Scale and How to Use High‑Performance Keyset Pagination