BestHub
Sign in
Tagged articles
16 articles
Page 1 of 1
Architecture & Thinking
Architecture & Thinking
Mar 13, 2026 · Databases

Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It

The article explains how deep pagination on massive MySQL tables causes full‑table scans, massive I/O, and memory pressure, then presents six concrete optimization techniques—including delayed join, cursor pagination, covering indexes, ID‑range pagination, caching, and partitioning—backed by a real‑world e‑commerce case study and detailed execution‑plan analysis.

deep paginationindexingmysql
0 likes · 18 min read
Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It
Architect
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.

Database OptimizationElasticsearchcursor pagination
0 likes · 10 min read
How to Overcome Deep Pagination Bottlenecks with Cursor, Subqueries, and Elasticsearch Search After
Architecture Digest
Architecture Digest
Nov 5, 2025 · Backend Development

Why Deep Pagination Breaks Elasticsearch and How to Fix It

This article explains how deep pagination in Elasticsearch triggers costly scatter‑gather queries that overload CPU, memory, and network, and it presents practical alternatives such as the scroll API and search_after to achieve efficient, real‑time pagination for large datasets.

Elasticsearchdeep paginationperformance
0 likes · 10 min read
Why Deep Pagination Breaks Elasticsearch and How to Fix It
Su San Talks Tech
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.

ElasticsearchTable Partitioningcovering index
0 likes · 9 min read
How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques
Java Backend Technology
Java Backend Technology
Sep 25, 2024 · Databases

How to Safely Update Billion‑Row MySQL Tables Without Overloading Binlog

This article explains why a simple full‑table UPDATE on massive MySQL tables can cripple master‑slave replication, analyzes deep‑pagination inefficiencies, and presents a step‑by‑step batch‑update strategy using NO_CACHE and FORCE INDEX to keep binlog size and buffer‑pool impact under control.

BinlogFORCE INDEXFull Table Update
0 likes · 9 min read
How to Safely Update Billion‑Row MySQL Tables Without Overloading Binlog
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.

Keyset Paginationcovering indexdeep pagination
0 likes · 7 min read
How to Solve MySQL Deep Pagination: Causes and 6 Effective Optimization Strategies
Su San Talks Tech
Su San Talks Tech
Nov 26, 2023 · Databases

Why Does MySQL LIMIT offset,size Slow Down With Large Offsets?

This article explains why MySQL's LIMIT offset,size becomes slower as the offset grows, compares it with LIMIT size, details the internal execution using primary and secondary indexes, discusses deep pagination issues, and presents practical optimization techniques to improve query performance.

LIMITdeep paginationmysql
0 likes · 14 min read
Why Does MySQL LIMIT offset,size Slow Down With Large Offsets?
MaGe Linux Operations
MaGe Linux Operations
Aug 19, 2023 · Databases

How Deep Pagination Slowed Our System and the SQL Fixes That Saved It

This article walks through a real‑world incident where a pagination‑related slow‑query caused massive CPU spikes, details the step‑by‑step investigation, and presents several MySQL optimization techniques—including ID‑based queries, sub‑queries, and cursor‑based pagination—that ultimately resolved the performance crisis.

Database PerformanceSQL Optimizationdeep pagination
0 likes · 10 min read
How Deep Pagination Slowed Our System and the SQL Fixes That Saved It
MaGe Linux Operations
MaGe Linux Operations
Jan 22, 2023 · Databases

How to Fix Deep Pagination Slow Queries in MySQL: A Real Incident Walkthrough

This article recounts a real‑world MySQL pagination outage, detailing how deep‑page queries caused massive CPU spikes, the step‑by‑step investigation, and the series of SQL redesigns—including ID‑based range queries, sub‑queries, scroll queries and join‑based solutions—that finally restored stable performance.

Database PerformanceSQL Optimizationdeep pagination
0 likes · 10 min read
How to Fix Deep Pagination Slow Queries in MySQL: A Real Incident Walkthrough
Architecture Digest
Architecture Digest
Sep 15, 2022 · Databases

Case Study: Resolving Deep Pagination Slow Queries in MySQL

This article walks through a real‑world incident caused by deep pagination in a MySQL‑based system, detailing the timeline of symptoms, root‑cause analysis, and a series of optimizations—including ID‑based queries, range scans, and rolling cursor techniques—that ultimately restored stable performance.

Database PerformanceIndex Optimizationdeep pagination
0 likes · 10 min read
Case Study: Resolving Deep Pagination Slow Queries in MySQL
dbaplus Community
dbaplus Community
Sep 12, 2022 · Databases

How to Resolve Deep Pagination Performance Problems in MySQL

This article walks through a real‑world incident caused by MySQL deep pagination, explains how the slow queries and CPU spikes were diagnosed, and presents several concrete optimization techniques—including ID‑based queries, range scans, sub‑queries and cursor‑based pagination—culminating in a stable production fix.

SQL Optimizationdatabasedeep pagination
0 likes · 10 min read
How to Resolve Deep Pagination Performance Problems in MySQL
Su San Talks Tech
Su San Talks Tech
Aug 13, 2022 · Databases

Why MySQL LIMIT offset slows down deep pagination and how to fix it

This article explains how MySQL processes LIMIT with an offset, why large offsets cause slower queries and deep‑pagination problems, and presents practical optimization techniques such as id‑based pagination, sub‑queries, and index‑aware strategies to improve performance.

LIMITdeep paginationmysql
0 likes · 14 min read
Why MySQL LIMIT offset slows down deep pagination and how to fix it
DeWu Technology
DeWu Technology
Jul 2, 2021 · Databases

MySQL Deep Pagination Optimization

MySQL deep pagination can be dramatically accelerated by ordering on the primary key, indexing the sort column, and using keyset pagination or a sub‑query join instead of scanning millions of rows, while only minor tweaks like increasing sort_buffer_size provide negligible gains.

deep paginationindexingmysql
0 likes · 10 min read
MySQL Deep Pagination Optimization