Tagged articles

Cursor Pagination

13 articles · Page 1 of 1

Jul 22, 2026 · Backend Development

Why Does Pagination Slow Down at 10 Million Records? Rethinking MySQL LIMIT in Java Backends

The article explains why deep pagination with large offsets becomes increasingly slow, why adding indexes often does not help, examines common “optimizations” like delayed joins, introduces cursor (keyset) pagination as a high‑performance alternative, and provides practical guidelines for designing pagination APIs in Java back‑ends at scale.

Cursor PaginationDeep PaginationMySQL

0 likes · 16 min read

Why Does Pagination Slow Down at 10 Million Records? Rethinking MySQL LIMIT in Java Backends

Lobster Programming

May 11, 2026 · Backend Development

Designing Effective Ad Mixing in Short‑Video Feed Streams

The article examines common pitfalls of naïve ad insertion in short‑video feeds, explains how cursor‑based pagination prevents duplicate ads, and outlines a client‑side mixing architecture that isolates services, meets strict latency requirements, and ensures accurate ad billing.

Cursor Paginationad mixingbackend design

0 likes · 4 min read

Designing Effective Ad Mixing in Short‑Video Feed Streams

Architecture & Thinking

Apr 22, 2026 · Backend Development

Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It

This article dissects the performance collapse of classic LIMIT‑OFFSET pagination on tables with hundreds of millions of rows, explains the underlying execution steps, presents benchmark data, and walks through a progressive set of solutions—including index tuning, Seek pagination, Cursor pagination, and sharding—complete with Go code examples and practical trade‑offs.

Cursor PaginationMySQLSharding

0 likes · 30 min read

Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It

Architect

Nov 27, 2025 · Databases

How to Overcome Deep Pagination Bottlenecks with Cursor, Subqueries, and Elasticsearch Search After

This article explains why deep pagination hurts performance in large datasets, demonstrates the inefficiency of offset‑based SQL queries, and presents practical alternatives such as cursor pagination, sub‑query optimizations, delayed joins, caching, business limits, and the Elasticsearch Search After technique for stable, scalable paging.

Cursor PaginationDeep PaginationElasticsearch

0 likes · 10 min read

How to Overcome Deep Pagination Bottlenecks with Cursor, Subqueries, and Elasticsearch Search After

dbaplus Community

Nov 12, 2025 · Databases

Mastering Data Sync: From Full Loads to Real‑Time CDC in E‑Commerce

This guide walks a new e‑commerce developer through the evolution of order data synchronization—from naïve full‑table loads, through incremental and batch strategies, cursor‑based pagination, performance tuning, and finally to real‑time CDC with message queues—highlighting pitfalls and practical solutions.

Batch ProcessingCDCCursor Pagination

0 likes · 12 min read

Mastering Data Sync: From Full Loads to Real‑Time CDC in E‑Commerce

IT Services Circle

Jul 4, 2025 · Databases

Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques

This article examines the performance pitfalls of MySQL deep pagination and presents six practical optimization methods—including cursor‑based pagination, deferred joins, covering indexes, table partitioning, precomputed pages, and Elasticsearch integration—to dramatically speed up large‑scale order queries.

Cursor PaginationMySQLdatabase indexing

0 likes · 8 min read

Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques

Su San Talks Tech

Mar 7, 2025 · Databases

How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques

This article dissects the performance problems of MySQL deep pagination, explains why OFFSET‑based queries become increasingly costly, and presents six practical optimization strategies—including cursor pagination, deferred joins, covering indexes, partitioning, precomputed pages, and Elasticsearch integration—to dramatically speed up order‑lookup queries in large e‑commerce databases.

Covering IndexCursor PaginationDeep Pagination

0 likes · 9 min read

How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques

Programmer XiaoFu

Mar 5, 2025 · Databases

From 12 s to 200 ms: 6 MySQL Deep‑Pagination Tricks for 20 M Orders

When a MySQL order table with 20 million rows is paginated using a large OFFSET, query latency can explode from seconds to minutes, but applying six concrete techniques—cursor pagination, deferred join, covering index, table partitioning, precomputed pages, and Elasticsearch integration—can shrink response time to a few hundred milliseconds.

Covering IndexCursor PaginationElasticsearch

0 likes · 9 min read

From 12 s to 200 ms: 6 MySQL Deep‑Pagination Tricks for 20 M Orders

IT Services Circle

Aug 13, 2024 · Backend Development

Implementing Pull‑Down Pagination for Instant Messaging History

This article explains the challenges of loading historical chat messages in an instant‑messaging app and demonstrates why traditional offset pagination fails, then introduces cursor‑based pagination with SQL examples and best‑practice guidelines for reliable incremental loading.

Cursor PaginationInstant MessagingSQL

0 likes · 7 min read

Implementing Pull‑Down Pagination for Instant Messaging History

JD Retail Technology

Feb 29, 2024 · Databases

Optimizing Large‑Scale Batch Processing for an Advertising Platform: From Query Tuning to Load‑Balanced Execution

This article presents a real‑world case study of optimizing massive batch‑processing tasks in an ad‑platform by applying query‑level improvements, cursor‑based pagination, shard‑aware batch updates, JVM‑tuned garbage collection, and distributed load‑balancing, ultimately reducing CPU usage from 80% to under 2% and cutting query‑per‑minute volume from millions to a few thousand.

Batch ProcessingCursor PaginationSharding

0 likes · 22 min read

Optimizing Large‑Scale Batch Processing for an Advertising Platform: From Query Tuning to Load‑Balanced Execution

Programmer DD

May 15, 2021 · Backend Development

Why Cursor-Based Pagination Beats Offset: Performance Insights and Code

This article explains how cursor‑based pagination avoids the heavy cost of offset/limit queries by using database cursors, shows practical API examples, compares query plans, and discusses why cursors improve performance and consistency for deep pagination in backend systems.

API paginationCursor Paginationoffset pagination

0 likes · 9 min read

Why Cursor-Based Pagination Beats Offset: Performance Insights and Code

Java Backend Technology

Sep 17, 2020 · Databases

Why OFFSET/LIMIT Pagination Fails and How to Use Fast Cursor Pagination

This article explains why traditional OFFSET/LIMIT pagination becomes inefficient with large tables, illustrates its performance drawbacks with real examples, and introduces a high‑performance cursor‑based pagination method that leverages indexed primary keys to dramatically speed up data retrieval.

Cursor PaginationSQLoffset

0 likes · 6 min read

Why OFFSET/LIMIT Pagination Fails and How to Use Fast Cursor Pagination

Aotu Lab

Jun 30, 2017 · Frontend Development

Understanding Pagination: Traditional vs. Infinite Scrolling and How to Implement Them

This article explains the differences between traditional page‑number pagination and infinite‑scroll (streaming) pagination, compares their characteristics, and provides detailed front‑end and back‑end implementation methods along with common pitfalls and optimization techniques such as caching, cursor‑based paging, and client‑side deduplication.

Cache OptimizationCursor Paginationback-end development

0 likes · 12 min read

Understanding Pagination: Traditional vs. Infinite Scrolling and How to Implement Them