BestHub
Sign in
Tagged articles

Pagination

339 articles · Page 2 of 4
Java Architect Essentials
Java Architect Essentials
Oct 30, 2024 · Backend Development

Optimizing Excel Export with EasyExcel: Performance, Pagination, Concurrency, and Cell‑Merging Strategies

This article demonstrates how to use EasyExcel to efficiently export large volumes of data to Excel by improving performance through pagination, concurrent queries, and custom cell‑merging strategies, including built‑in annotations and WriteHandler implementations, while providing complete Java code examples.

Cell MergingEasyExcelExcel export
0 likes · 16 min read
Optimizing Excel Export with EasyExcel: Performance, Pagination, Concurrency, and Cell‑Merging Strategies
Programmer XiaoFu
Programmer XiaoFu
Oct 30, 2024 · Databases

How to Boost Pagination Queries for a Million Products by 10×

This article walks through nine practical techniques—default filters, smaller page sizes, fewer joins, index tuning, straight_join, data archiving, efficient count(*), ClickHouse offloading, and read/write splitting—to dramatically improve the performance of pagination APIs handling millions of product records.

ClickHouseMySQLPagination
0 likes · 11 min read
How to Boost Pagination Queries for a Million Products by 10×
Architect
Architect
Oct 29, 2024 · Databases

Four Pagination Strategies: MySQL LIMIT OFFSET, Primary‑Key Filtering, HasMore Scrolling, and Elasticsearch

This article compares four pagination techniques—MySQL LIMIT OFFSET, LIMIT with primary‑key filtering, HasMore scrolling, and Elasticsearch pagination—explaining their implementations, advantages, drawbacks such as deep‑page performance issues, and recommending appropriate scenarios for each method.

ElasticsearchMySQLPagination
0 likes · 6 min read
Four Pagination Strategies: MySQL LIMIT OFFSET, Primary‑Key Filtering, HasMore Scrolling, and Elasticsearch
Su San Talks Tech
Su San Talks Tech
Oct 26, 2024 · Databases

9 Proven Tricks to Supercharge Your Pagination API Performance

This article presents nine practical techniques—including default filters, smaller page sizes, reduced joins, index tuning, straight_join usage, data archiving, count(*) optimization, ClickHouse offloading, and read/write splitting—to dramatically improve the speed and scalability of pagination query interfaces.

PaginationSQLbackend
0 likes · 13 min read
9 Proven Tricks to Supercharge Your Pagination API Performance
Tencent Cloud Developer
Tencent Cloud Developer
Oct 18, 2024 · Backend Development

Tencent Meeting "My Recordings" List Optimization Practice

Tencent Meeting optimized its “My Recordings” list by replacing offset pagination with cursor‑based seeks, implementing a two‑layer cache separating ID lists from record details, choosing MongoDB for multi‑source aggregation, and adding reliable Kafka‑driven sync, cutting latency from 308 ms to 70 ms while supporting over 700 QPS.

MongoDBPaginationbackend
0 likes · 36 min read
Tencent Meeting "My Recordings" List Optimization Practice
Programmer XiaoFu
Programmer XiaoFu
Oct 12, 2024 · Fundamentals

How Generics + Functional Programming Make Java Code Look More Sophisticated

The article demonstrates how combining Java generics with functional programming—using lambda‑based callbacks and generic pagination utilities—can transform repetitive data‑access code into a concise, reusable structure, while also discussing the benefits, trade‑offs, and potential debugging challenges of this approach.

Functional ProgrammingJavaPagination
0 likes · 11 min read
How Generics + Functional Programming Make Java Code Look More Sophisticated
ITPUB
ITPUB
Oct 11, 2024 · Databases

How to Efficiently Delete Massive MySQL Logs While Preserving Critical Types

This article explains how to clean up a rapidly growing MySQL log table by batching deletions, handling unindexed type columns, and using a start‑id based pagination strategy that scales from tens of millions to billions of rows without locking the database.

MySQLPaginationSQL optimization
0 likes · 8 min read
How to Efficiently Delete Massive MySQL Logs While Preserving Critical Types
Programmer1970
Programmer1970
Oct 7, 2024 · Backend Development

Mastering MyBatis Plugins: Features, Mechanics, Real‑World Use Cases & Best Practices

This article explains MyBatis plugins’ core capabilities—SQL rewriting, logging, performance monitoring, transaction enhancement, and result handling—detailing their interception points, the Java dynamic‑proxy implementation, a complete pagination plugin example, typical application scenarios, and practical best‑practice recommendations for developers.

Dynamic ProxyJavaMyBatis
0 likes · 11 min read
Mastering MyBatis Plugins: Features, Mechanics, Real‑World Use Cases & Best Practices
Java Tech Enthusiast
Java Tech Enthusiast
Oct 3, 2024 · Databases

MySQL Large Table Data Deletion Optimization Strategy

To efficiently purge old user‑operation logs while retaining the most recent three months and preserving type‑c entries, the article recommends abandoning offset pagination and MyBatis PageHelper, using primary‑key‑based pagination with a tracked startId, in‑memory filtering, intelligent startId recalculation, and optional sleep intervals to avoid database overload.

MySQLPaginationPerformance Tuning
0 likes · 6 min read
MySQL Large Table Data Deletion Optimization Strategy
Selected Java Interview Questions
Selected Java Interview Questions
Sep 2, 2024 · Databases

Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices

This article explains the challenges of executing full‑table UPDATE statements on large MySQL tables using row‑based binlog replication, analyzes deep pagination issues, and presents a batch‑processing strategy with FORCE INDEX, SQL_NO_CACHE and controlled rate limiting to safely migrate data at scale.

Full Table UpdateMySQLPagination
0 likes · 8 min read
Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices
Architecture & Thinking
Architecture & Thinking
Jul 24, 2024 · Databases

Why MySQL Pagination Slows Down and How to Speed It Up

This article examines why MySQL pagination using large LIMIT OFFSET values becomes increasingly slow, explains the underlying scanning behavior, and presents six practical optimization techniques—including indexed subqueries, cursor‑based pagination, column selection, partitioning, caching, and hardware considerations—to dramatically improve query performance on massive tables.

DatabaseMySQLOptimization
0 likes · 7 min read
Why MySQL Pagination Slows Down and How to Speed It Up
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jun 17, 2024 · Backend Development

20 Essential Spring Boot Best Practices to Boost Your Java Backend

This article presents a comprehensive collection of Spring Boot best practices—including package structuring, design patterns, starter usage, dependency management, constructor injection, SLF4J logging, pagination, caching, exception handling, naming conventions, and code quality tools—to help developers build more efficient, maintainable, and robust Java backend applications.

Design PatternsJavaLogging
0 likes · 10 min read
20 Essential Spring Boot Best Practices to Boost Your Java Backend
Code Ape Tech Column
Code Ape Tech Column
May 4, 2024 · Backend Development

Understanding PageHelper Pagination Issues and ThreadLocal Management in MyBatis

This article analyzes common anomalies caused by the PageHelper pagination plugin in a Java backend project—such as duplicate user registration, limited query results, and password‑reset errors—traces them to ThreadLocal misuse, explains the internal workflow of startPage, getLocalPage, and clearPage, and offers practical recommendations to avoid these pitfalls.

JavaMyBatisPagination
0 likes · 11 min read
Understanding PageHelper Pagination Issues and ThreadLocal Management in MyBatis
Top Architect
Top Architect
Apr 19, 2024 · Databases

Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives

This article explains why using OFFSET and LIMIT for pagination becomes inefficient on large tables, illustrates the performance impact with examples, and proposes a cursor‑based pagination alternative that leverages indexed primary keys to achieve faster, scalable queries.

DatabaseLIMITPagination
0 likes · 8 min read
Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives
Liangxu Linux
Liangxu Linux
Apr 7, 2024 · Databases

8 Proven MySQL Query Optimizations to Slash Execution Time

This article explains common MySQL performance pitfalls such as large‑offset pagination, implicit type conversion, inefficient UPDATE/DELETE joins, mixed ordering, EXISTS subqueries, predicate push‑down, early data reduction, and intermediate result set push‑down, and provides concrete rewrites that turn multi‑second queries into millisecond‑level executions.

CTEIndexingJoins
0 likes · 13 min read
8 Proven MySQL Query Optimizations to Slash Execution Time
JD Retail Technology
JD Retail Technology
Mar 20, 2024 · Backend Development

Multithreaded Pagination Query with Java ThreadPoolExecutor: Principles, Parameters, and Usage

This article explains how using a Java thread pool for multithreaded pagination can dramatically speed up large‑scale data queries, outlines thread‑pool concepts and benefits, details ThreadPoolExecutor parameters and work‑queue options, and reviews common rejection policies and built‑in pool factories.

JavaPaginationPerformance
0 likes · 6 min read
Multithreaded Pagination Query with Java ThreadPoolExecutor: Principles, Parameters, and Usage
JD Tech
JD Tech
Mar 6, 2024 · Backend Development

Fixing Incorrect Total Count in PageHelper Pagination Using PageInfo

This article analyzes why the total record count returned by PageHelper mismatches the actual number of rows, examines the underlying PageInfo and PageSerializable source code, and provides a concrete solution that avoids type conversion and directly constructs PageInfo from the mapper result to ensure accurate pagination.

DebuggingJavaMyBatis
0 likes · 7 min read
Fixing Incorrect Total Count in PageHelper Pagination Using PageInfo
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Feb 26, 2024 · Backend Development

Understanding and Configuring Pagination Rationalization with MyBatis PageHelper in SpringBoot

This article explains pagination rationalization in SpringBoot using MyBatis PageHelper, illustrates common unreasonable pagination scenarios, demonstrates a bug caused by page deletion, and shows how a simple two‑line configuration or per‑query setting resolves the issue while detailing the underlying implementation.

JavaMyBatisPagination
0 likes · 8 min read
Understanding and Configuring Pagination Rationalization with MyBatis PageHelper in SpringBoot
Java Tech Enthusiast
Java Tech Enthusiast
Feb 9, 2024 · Backend Development

Understanding PageHelper Issues and ThreadLocal in MyBatis Pagination

Unexpected duplicate registrations, truncated query results, and password‑reset SQL errors in a Java backend were traced to PageHelper’s ThreadLocal pagination state persisting across requests when startPage() is called without immediate query execution, so developers should ensure immediate execution or manually clear the ThreadLocal to prevent stale LIMIT clauses.

JavaMyBatisPagination
0 likes · 12 min read
Understanding PageHelper Issues and ThreadLocal in MyBatis Pagination
IT Niuke
IT Niuke
Jan 21, 2024 · Databases

Implementing Pagination and Multi‑Condition Fuzzy Search in Redis

The article explains how to use Redis Sorted Sets for efficient pagination, employ Hashes with HSCAN for multi‑condition fuzzy matching, combine both techniques into a unified solution, and apply expiration‑based optimizations to keep the cache lightweight and responsive.

Cache OptimizationFuzzy SearchHash
0 likes · 10 min read
Implementing Pagination and Multi‑Condition Fuzzy Search in Redis
JD Cloud Developers
JD Cloud Developers
Jan 17, 2024 · Databases

How to Efficiently Scan Billions of Rows in MySQL: Pagination Strategies

This article examines the challenges of querying massive follower lists stored in MySQL, compares limit‑based pagination with tag‑record and range‑limit methods, and offers practical indexing and query‑optimization recommendations for handling tables containing hundreds of millions of rows.

IndexingLarge DataPagination
0 likes · 12 min read
How to Efficiently Scan Billions of Rows in MySQL: Pagination Strategies
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jan 14, 2024 · Frontend Development

High‑Performance GridList Component with Pagination and Virtual Scrolling in Vue 3

This article introduces a Vue 3 GridList component that supports responsive grid layouts, server‑side pagination via a request function, and virtual scrolling to render only visible items, providing performance improvements for large data sets while offering clear usage examples and full source code.

GridListPaginationPerformance
0 likes · 17 min read
High‑Performance GridList Component with Pagination and Virtual Scrolling in Vue 3
php Courses
php Courses
Jan 9, 2024 · Backend Development

Implementing Data Pagination in PHP with PDO: A Step‑by‑Step Guide

This article explains how to create a MySQL database and table, connect to it using PHP PDO, and implement server‑side pagination with configurable page size, total‑page calculation, and navigation links, providing complete code examples for each step.

Paginationbackendtutorial
0 likes · 5 min read
Implementing Data Pagination in PHP with PDO: A Step‑by‑Step Guide
Architect
Architect
Dec 27, 2023 · Backend Development

Master MyBatis‑Plus in Spring Boot: From Quick Start to Advanced Features

This guide walks through integrating MyBatis‑Plus with Spring Boot, covering dependency setup, configuration, entity annotations, CRUD operations, pagination, logical deletion, enum handling, automatic field filling, multi‑data‑source support, and testing with concrete code examples and detailed explanations.

CRUDEnum MappingLogical Deletion
0 likes · 20 min read
Master MyBatis‑Plus in Spring Boot: From Quick Start to Advanced Features
IT Niuke
IT Niuke
Dec 25, 2023 · Backend Development

Master MyBatis-Plus: From Basics to Advanced Features

This article introduces MyBatis-Plus, an enhancement layer for MyBatis, and walks through its core features—non‑intrusive CRUD, Lambda queries, primary‑key strategies, automatic field filling, optimistic locking, pagination, logical delete, performance analysis, condition builders, and a code generator—providing complete code examples and configuration steps for Spring Boot integration.

CRUDJavaORM
0 likes · 17 min read
Master MyBatis-Plus: From Basics to Advanced Features
dbaplus Community
dbaplus Community
Dec 24, 2023 · Databases

Boost MySQL Performance: Proven SQL Optimization Techniques

When a system’s data grows, MySQL queries can become slow and cause latency; this article presents practical optimization strategies—including query tuning, pagination, join improvements, subquery replacement, order‑by and group‑by enhancements, and count() efficiency—illustrated with sample tables, code snippets, and performance screenshots.

GROUP BYIndexingJOIN
0 likes · 13 min read
Boost MySQL Performance: Proven SQL Optimization Techniques
Sanyou's Java Diary
Sanyou's Java Diary
Dec 4, 2023 · Backend Development

When Pagination Breaks: Real‑World Bugs and Practical Fixes

This article recounts three production‑level pagination bugs encountered in a payment system, explains why they occurred—ranging from naive batch processing to MySQL's nondeterministic LIMIT behavior—and shows how proper pagination, ThreadLocal cleanup, and deterministic ordering resolve the issues.

Bug fixingMySQLPagination
0 likes · 16 min read
When Pagination Breaks: Real‑World Bugs and Practical Fixes
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.

Deep PaginationLIMITMySQL
0 likes · 14 min read
Why Does MySQL LIMIT offset,size Slow Down With Large Offsets?
IT Architects Alliance
IT Architects Alliance
Nov 17, 2023 · Databases

How to Implement Conditional Queries and Pagination in Redis

This article explains how to achieve conditional fuzzy queries and pagination in Redis by leveraging Sorted Sets and Hashes, detailing command usage, data modeling, combination strategies, and performance optimizations such as expiration and real‑time updates.

Fuzzy QueryHashPagination
0 likes · 8 min read
How to Implement Conditional Queries and Pagination in Redis
Architect
Architect
Nov 14, 2023 · Databases

Implementing Pagination and Multi‑Condition Fuzzy Query in Redis

This article explains how to use Redis Sorted Sets for efficient pagination, leverages Hashes and HSCAN for multi‑condition fuzzy searches, and combines both techniques with optimization strategies such as temporary ZSet expiration and real‑time update handling to build a practical caching‑layer query solution.

CacheFuzzy QueryHash
0 likes · 10 min read
Implementing Pagination and Multi‑Condition Fuzzy Query in Redis
Shepherd Advanced Notes
Shepherd Advanced Notes
Nov 10, 2023 · Backend Development

Comprehensive Beginner’s Guide to MyBatis-Plus with Spring Boot

This article introduces MyBatis-Plus, outlines its non‑intrusive features and CRUD enhancements, walks through integrating it with a Spring Boot project, demonstrates entity, mapper and service definitions, explains common annotations, showcases the powerful Wrapper condition builder, and covers pagination configuration for everyday backend development.

CRUDJavaORM
0 likes · 24 min read
Comprehensive Beginner’s Guide to MyBatis-Plus with Spring Boot
JD Tech
JD Tech
Nov 9, 2023 · Databases

Optimizing Pagination Queries for Billion‑Row MySQL Tables

This article analyzes the performance problems of LIMIT‑based pagination on massive MySQL tables and presents three progressively more efficient solutions—including a simple LIMIT approach, a tag‑record method using the last primary key, and a range‑limit method with cached min‑ID—along with best‑practice indexing recommendations to keep query latency in the tens of milliseconds even for tables containing billions of rows.

Large DataMySQLPagination
0 likes · 12 min read
Optimizing Pagination Queries for Billion‑Row MySQL Tables
macrozheng
macrozheng
Nov 6, 2023 · Backend Development

Mastering MyBatis PageHelper: Avoid Common Pagination Pitfalls

This article explains the core principles and multiple usage patterns of MyBatis PageHelper for pagination, demonstrates code examples, details its internal ThreadLocal and interceptor mechanisms, and highlights common pitfalls with safe versus unsafe practices to ensure reliable data retrieval.

JavaMyBatisPagination
0 likes · 9 min read
Mastering MyBatis PageHelper: Avoid Common Pagination Pitfalls
dbaplus Community
dbaplus Community
Nov 5, 2023 · Backend Development

Three Hidden Pagination Pitfalls That Can Break Your Production System

The article recounts three real‑world pagination bugs—batch‑processing loops, misuse of MyBatis PageHelper, and nondeterministic results from identical ORDER BY values—explaining why they occur, how they manifest in production, and concrete fixes to avoid data loss or endless loops.

MyBatisMySQLPagination
0 likes · 15 min read
Three Hidden Pagination Pitfalls That Can Break Your Production System
php Courses
php Courses
Oct 31, 2023 · Backend Development

Implementing Pagination in PHP with Custom Functions

This article explains the principle of pagination and provides three reusable PHP functions—get_total_pages, get_offset, and generate_pagination—along with example code to calculate total pages, determine record offsets, and render a navigation bar for efficient web page data paging.

PHPPaginationbackend
0 likes · 6 min read
Implementing Pagination in PHP with Custom Functions
JD Retail Technology
JD Retail Technology
Oct 20, 2023 · Databases

Understanding Pagination Issues with ORDER BY and LIMIT in MySQL

This article examines why combining ORDER BY with LIMIT in MySQL pagination can produce duplicate rows on subsequent pages, analyzes the optimizer’s priority‑queue behavior introduced in version 5.6, and presents practical solutions such as using unique sort keys, adding ID ordering, and understanding deep‑pagination limitations.

LIMITMySQLORDER BY
0 likes · 8 min read
Understanding Pagination Issues with ORDER BY and LIMIT in MySQL
dbaplus Community
dbaplus Community
Oct 8, 2023 · Databases

How to Optimize Pagination for Massive MySQL Tables with Sharding

When a single MySQL table grows to millions of rows, offset‑based pagination becomes painfully slow, so this article explains why, measures the performance impact, and presents three practical sharding‑aware pagination strategies—including global query, jump‑page prohibition, and a two‑step query method—along with concrete SQL rewrites and optimization tips.

MySQLPaginationPerformance
0 likes · 16 min read
How to Optimize Pagination for Massive MySQL Tables with Sharding
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 PerformanceDeep PaginationMySQL
0 likes · 10 min read
How Deep Pagination Slowed Our System and the SQL Fixes That Saved It
Top Architect
Top Architect
Aug 18, 2023 · Databases

MySQL Table Splitting and Pagination Using the MERGE Engine

This article explains how to split a massive MySQL table into smaller tables, use the MERGE engine to create a unified view, troubleshoot common errors, and implement efficient pagination across the split tables with example SQL and Java code.

MERGE engineMySQLPagination
0 likes · 6 min read
MySQL Table Splitting and Pagination Using the MERGE Engine
Code Ape Tech Column
Code Ape Tech Column
Aug 11, 2023 · Big Data

Elasticsearch Pagination: From/Size, Deep Paging Issues, and Alternative Methods (Scroll, Search After, PIT)

This article explains how Elasticsearch pagination works with from/size, why deep paging can cause performance problems, and compares alternative techniques such as Scroll, Scroll‑Scan, Sliced Scroll, Search After, and point‑in‑time (PIT) searches for handling large result sets efficiently.

Deep PagingElasticsearchPagination
0 likes · 17 min read
Elasticsearch Pagination: From/Size, Deep Paging Issues, and Alternative Methods (Scroll, Search After, PIT)
Top Architect
Top Architect
Aug 8, 2023 · Databases

MySQL Pagination Query Optimization Techniques and Performance Testing

The article examines various MySQL pagination strategies—including simple LIMIT clauses, sub‑query approaches, ID‑range filtering, and temporary‑table methods—provides performance measurements on a table with millions of rows, and offers practical recommendations for reducing query latency in large datasets.

DatabaseMySQLPagination
0 likes · 9 min read
MySQL Pagination Query Optimization Techniques and Performance Testing
Architects Research Society
Architects Research Society
Jul 22, 2023 · Backend Development

Understanding JSON API: Benefits, Features, and a FitBit Case Study

This article explains what JSON API is, outlines its key advantages such as compound documents, sparse fieldsets, optional features, pagination and caching, compares it with GraphQL, and illustrates its practical use through a FitBit case study, helping readers decide if it fits their API design needs.

API designJSON APIPagination
0 likes · 12 min read
Understanding JSON API: Benefits, Features, and a FitBit Case Study
Architecture Digest
Architecture Digest
Jul 18, 2023 · Databases

Implementing Conditional Query and Pagination in Redis

This article explains how to use Redis Sorted Sets and Hashes to achieve pagination, fuzzy multi‑condition queries, and their combination, while also discussing performance optimizations such as expiration and update strategies for generated ZSet collections.

Fuzzy SearchHashPagination
0 likes · 8 min read
Implementing Conditional Query and Pagination in Redis
Laravel Tech Community
Laravel Tech Community
Jul 5, 2023 · Databases

Performance Testing and Optimization of Large‑Scale MySQL Queries

This article demonstrates how to generate, insert, and query millions of rows in a MySQL 5.7 table, measures pagination performance under varying offsets and result sizes, and presents several optimization techniques—including sub‑queries, indexed look‑ups, and column selection—to dramatically reduce query latency.

DatabaseLarge DataMySQL
0 likes · 10 min read
Performance Testing and Optimization of Large‑Scale MySQL Queries
Top Architect
Top Architect
Jul 5, 2023 · Databases

Implementing Pagination and Multi‑Condition Fuzzy Query in Redis

This article explains how to achieve efficient pagination and multi‑condition fuzzy searches in Redis by leveraging Sorted Sets for ordered paging, Hashes with HSCAN for pattern matching, and combining both techniques with caching and expiration strategies to optimize performance.

CacheFuzzy QueryHash
0 likes · 9 min read
Implementing Pagination and Multi‑Condition Fuzzy Query in Redis
Selected Java Interview Questions
Selected Java Interview Questions
Jul 3, 2023 · Databases

Root Cause Analysis and Solutions for Pagination Slow Queries in a Backend System

This article details a real‑world incident of severe pagination slow queries, walks through the timeline of detection, diagnosis, and mitigation steps, and presents multiple MySQL optimization techniques—including ID‑based queries, sub‑queries, scroll queries, and join‑based solutions—to resolve deep pagination performance issues.

MySQLPaginationSQL optimization
0 likes · 11 min read
Root Cause Analysis and Solutions for Pagination Slow Queries in a Backend System
Top Architect
Top Architect
Jun 30, 2023 · Databases

Optimizing MySQL LIMIT Pagination: Analysis and Solutions

This article examines why MySQL LIMIT pagination becomes slower with deeper offsets on a 500,000‑row table, demonstrates the performance impact with concrete queries, and presents three optimization strategies—including using ordered primary keys, subqueries, and join‑based approaches—to reduce scan range and improve query speed.

IndexingMySQLPagination
0 likes · 8 min read
Optimizing MySQL LIMIT Pagination: Analysis and Solutions
Sohu Tech Products
Sohu Tech Products
Jun 14, 2023 · Backend Development

Three Strategies for Caching Paginated List Results

This article explains three progressively refined approaches to caching paginated list data—directly caching whole pages, caching individual object entries after querying ID lists, and caching both ID lists and object entries—highlighting trade‑offs, implementation details, and performance considerations using Java and Redis.

PaginationRediscaching
0 likes · 8 min read
Three Strategies for Caching Paginated List Results
Code Ape Tech Column
Code Ape Tech Column
May 25, 2023 · Backend Development

Java Pagination List Caching Strategies

This article explains three progressively finer-grained approaches to caching paginated lists in Java—directly caching whole pages, caching individual objects after retrieving their IDs, and caching both ID lists and object entries using Redis structures—along with code examples and performance considerations.

JavaPaginationPerformance
0 likes · 9 min read
Java Pagination List Caching Strategies
Architect
Architect
May 13, 2023 · Databases

Splitting a Massive MySQL Financial Transaction Table: Challenges, Strategies, and Implementation

The article details how a finance team tackled a 50‑million‑row MySQL transaction table by analyzing the pre‑split problems, defining split goals, choosing sharding‑jdbc, addressing multi‑datasource transaction and pagination issues, designing a phased migration and rollout plan, and summarizing lessons learned.

Data MigrationMySQLPagination
0 likes · 13 min read
Splitting a Massive MySQL Financial Transaction Table: Challenges, Strategies, and Implementation
Top Architect
Top Architect
May 9, 2023 · Databases

Performance Testing and Optimization of MySQL Pagination for Large Datasets

This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures the latency of ordinary LIMIT pagination, analyzes the impact of offset size and result set size, and presents practical optimization techniques such as sub‑query pagination and ID‑range filtering to dramatically improve query speed.

Large DataMySQLOptimization
0 likes · 12 min read
Performance Testing and Optimization of MySQL Pagination for Large Datasets
Java High-Performance Architecture
Java High-Performance Architecture
May 9, 2023 · Databases

How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations

This article walks through creating a 10‑million‑row MySQL table, measuring pagination query times under different offsets and result sizes, and presents practical optimizations such as sub‑queries, ID‑range filtering, and column selection to dramatically improve performance while explaining why using SELECT * is discouraged.

Large DataMySQLOptimization
0 likes · 11 min read
How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations
macrozheng
macrozheng
Apr 12, 2023 · Backend Development

Simplify Join Queries in MyBatis‑Plus with MPJ: A Hands‑On Guide

This tutorial shows how to use the MyBatis‑Plus‑Join (MPJ) extension to perform left‑join queries, modify mappers, build queries with MPJLambdaWrapper and MPJQueryWrapper, and add pagination, eliminating the need for manual XML SQL while improving development efficiency.

JavaJoin QueryMPJ
0 likes · 8 min read
Simplify Join Queries in MyBatis‑Plus with MPJ: A Hands‑On Guide
Top Architect
Top Architect
Apr 2, 2023 · Databases

Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies

This article demonstrates how to generate millions of test rows in MySQL, analyzes the performance impact of deep pagination using LIMIT, explains why non‑clustered index lookups cause costly table scans, and presents two optimization approaches—sub‑query ID filtering and key‑set pagination—to dramatically reduce query latency.

Data GenerationMySQLPagination
0 likes · 8 min read
Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies
Top Architect
Top Architect
Mar 31, 2023 · Backend Development

Why MyBatis PageHelper Pagination Is Slow and How to Optimize It

The article explains that MyBatis PageHelper performs an extra full‑table count query causing pagination to take over eight seconds on a 10,000‑row table, analyzes the root cause, and provides a concrete solution by customizing the count SQL with a _COUNT method and optimized mapper definitions.

JavaMyBatisPagination
0 likes · 6 min read
Why MyBatis PageHelper Pagination Is Slow and How to Optimize It
JD Cloud Developers
JD Cloud Developers
Mar 8, 2023 · Backend Development

Mastering Web Pagination: Database, Backend, and Frontend Techniques

This article explores web pagination across database, backend, and frontend layers, detailing MySQL LIMIT syntax, Java pagination implementations with PageHelper and Spring Data JDBC, and UI approaches using Thymeleaf and Element UI, providing code examples and comparative insights for developers.

Element UIJavaMySQL
0 likes · 9 min read
Mastering Web Pagination: Database, Backend, and Frontend Techniques
Top Architect
Top Architect
Feb 23, 2023 · Backend Development

Comprehensive Guide to Using MyBatis‑Plus with Spring Boot

This tutorial walks through integrating MyBatis‑Plus into a Spring Boot project, covering dependency setup, configuration of data sources, entity annotations, service and mapper layers, pagination, logical deletion, enum handling, automatic field filling, multi‑datasource support, and testing with full code examples.

CRUDEnumLogical Delete
0 likes · 18 min read
Comprehensive Guide to Using MyBatis‑Plus with Spring Boot
Su San Talks Tech
Su San Talks Tech
Feb 3, 2023 · Backend Development

Efficiently Export Millions of Rows to Excel Using Async and EasyExcel

This article details a robust solution for exporting massive MySQL datasets—potentially millions of rows—to Excel by leveraging asynchronous processing with jobs or MQ, the memory‑efficient EasyExcel library, pagination, multi‑sheet handling, OSS storage, and WebSocket notifications, ensuring performance and usability.

Async ProcessingEasyExcelExcel export
0 likes · 17 min read
Efficiently Export Millions of Rows to Excel Using Async and EasyExcel
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 PerformanceDeep PaginationPagination
0 likes · 10 min read
How to Fix Deep Pagination Slow Queries in MySQL: A Real Incident Walkthrough
NiuNiu MaTe
NiuNiu MaTe
Dec 21, 2022 · Databases

Why Is MySQL OFFSET Slow? B+ Tree Index Insights & K‑th Largest Query Optimization

This article examines how MySQL uses secondary indexes to find the K‑th largest value, analyzes the O(N) time complexity caused by offset pagination, explains the underlying B+‑tree double‑linked list behavior, and presents three optimization strategies—including index covering, pagination redesign, and boundary prediction—to dramatically improve performance.

B+TreeMySQLPagination
0 likes · 10 min read
Why Is MySQL OFFSET Slow? B+ Tree Index Insights & K‑th Largest Query Optimization
Top Architect
Top Architect
Dec 4, 2022 · Databases

Deep Dive into Elasticsearch Pagination: from/size, Scroll, and Search After

This article explains how Elasticsearch handles deep pagination, compares the traditional from/size method with Scroll and Search After techniques, details their internal query and fetch phases, provides practical code examples, and offers guidance on choosing the right approach for large‑scale search workloads.

Big DataPaginationscroll
0 likes · 15 min read
Deep Dive into Elasticsearch Pagination: from/size, Scroll, and Search After
dbaplus Community
dbaplus Community
Nov 29, 2022 · Databases

Why MySQL LIKE Pagination Misses Exact Matches and How to Fix It

Combining MySQL LIKE fuzzy search with pagination can push exact‑match rows to later pages, causing duplicate brand entries; this article explains the root cause, demonstrates failing queries, and presents several fixes—including adjusting page size, splitting exact and fuzzy queries, and using CHAR_LENGTH and LOCATE functions for custom ordering.

OrderingPaginationchar_length
0 likes · 9 min read
Why MySQL LIKE Pagination Misses Exact Matches and How to Fix It
MaGe Linux Operations
MaGe Linux Operations
Nov 20, 2022 · Backend Development

Master Elasticsearch Pagination: From/Size, Scroll & Search After

This article examines Elasticsearch's three pagination strategies—basic from/size, scroll-based deep paging, and the newer search after method—detailing their execution phases, performance implications, code examples, and practical recommendations for choosing the appropriate approach based on data volume and real‑time requirements.

Paginationbackendfrom+size
0 likes · 17 min read
Master Elasticsearch Pagination: From/Size, Scroll & Search After
Programmer DD
Programmer DD
Nov 17, 2022 · Backend Development

Mastering Elasticsearch Pagination: From/Size, Scroll, and Search After Explained

This article examines Elasticsearch's deep pagination challenges and presents three practical solutions—basic from/size, scroll API, and search after—detailing their execution phases, performance trade‑offs, code examples, and guidance on when to choose each method for efficient data retrieval.

Paginationbackend developmentscroll API
0 likes · 14 min read
Mastering Elasticsearch Pagination: From/Size, Scroll, and Search After Explained
ITPUB
ITPUB
Nov 12, 2022 · Databases

How to Speed Up Large Pagination Queries in MySQL: Delayed Join and Bookmark Techniques

This article explains why traditional ORDER BY … LIMIT pagination becomes slow on tens of millions of rows, analyzes the underlying index scan cost, and presents two practical optimizations—delayed join using covering indexes and a bookmark‑based approach—showing how they can cut execution time to a third or even a tenth of the original.

MySQLPaginationbookmark pagination
0 likes · 8 min read
How to Speed Up Large Pagination Queries in MySQL: Delayed Join and Bookmark Techniques
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 4, 2022 · Frontend Development

Full-Stack Frontend Implementation of a Publishing Platform: Pagination, CRUD, and Vue‑Element‑Plus Integration

This tutorial walks through the front‑end portion of a publishing platform series, demonstrating how to build a Vue 3 and Element‑plus UI with TailwindCSS, implement server‑side pagination via Koa, integrate Axios with proxy and interceptors, and add complete CRUD operations—including create, edit, and delete dialogs—while showcasing the essential code snippets.

CRUDElement PlusFull-Stack
0 likes · 16 min read
Full-Stack Frontend Implementation of a Publishing Platform: Pagination, CRUD, and Vue‑Element‑Plus Integration
Selected Java Interview Questions
Selected Java Interview Questions
Oct 12, 2022 · Backend Development

MySQL Table Splitting and Pagination Using the MERGE Engine

This article explains how to handle massive MySQL tables by splitting a single large table into multiple smaller tables, creating a MERGE (union) table to combine them, and using the merged view to implement efficient pagination, including necessary SQL statements and troubleshooting tips.

MERGE enginePaginationSQL
0 likes · 5 min read
MySQL Table Splitting and Pagination Using the MERGE Engine
Top Architect
Top Architect
Oct 11, 2022 · Backend Development

Comprehensive Guide to Integrating MyBatis‑Plus with Spring Boot

This article provides a step‑by‑step tutorial on adding MyBatis‑Plus to a Spring Boot project, covering dependency setup, configuration, entity annotations, CRUD operations, pagination, logical deletion, enum handling, automatic field filling, multi‑datasource support, and testing with full code examples.

CRUDEnumJava
0 likes · 17 min read
Comprehensive Guide to Integrating MyBatis‑Plus with Spring Boot
Laravel Tech Community
Laravel Tech Community
Oct 10, 2022 · Databases

Optimizing MySQL Pagination for Large Datasets

The article analyzes why MySQL LIMIT pagination becomes slower as the offset grows, demonstrates the performance impact with sample queries on a 500,000‑row table, and presents three optimization strategies—using ordered primary keys, subqueries, and join‑based pagination—to reduce full‑table scans and improve query speed.

IndexMySQLPagination
0 likes · 8 min read
Optimizing MySQL Pagination for Large Datasets
JD Retail Technology
JD Retail Technology
Oct 10, 2022 · Backend Development

Design and Implementation of Asynchronous Pagination for JD Shopping Cart Auxiliary Information

This article presents a comprehensive case study of how JD.com tackled the growing load of its shopping‑cart service by introducing an asynchronous pagination mechanism for auxiliary product information, detailing the background, objectives, technical architecture, challenges, and measurable performance and cost benefits.

Asynchronous LoadingJD.comPagination
0 likes · 13 min read
Design and Implementation of Asynchronous Pagination for JD Shopping Cart Auxiliary Information
Top Architect
Top Architect
Oct 8, 2022 · Databases

Optimizing MySQL Pagination for Large Datasets: Techniques and Examples

This article analyzes why MySQL LIMIT pagination becomes slower on large tables, demonstrates the performance impact with real query timings, explains the underlying full‑table scan behavior, and presents three practical optimization strategies—including ordered primary‑key scans, sub‑queries, and join‑based approaches—to improve query speed.

IndexingMySQLPagination
0 likes · 7 min read
Optimizing MySQL Pagination for Large Datasets: Techniques and Examples
ITPUB
ITPUB
Oct 7, 2022 · Databases

How to Efficiently Paginate Across Sharded Tables: Three Proven Methods

This article explains why sharding tables improves read/write speed, then compares three pagination strategies—global query, no‑skip pagination, and two‑phase query—detailing their SQL rewrites, execution steps, performance trade‑offs, and practical examples.

PaginationSQLdistributed
0 likes · 10 min read
How to Efficiently Paginate Across Sharded Tables: Three Proven Methods
Architecture Digest
Architecture Digest
Sep 30, 2022 · Backend Development

Best Practices for Designing a Good API

This article explains why well‑designed APIs are essential, covering data modeling, resource hierarchy, naming conventions, RESTful principles, CRUD operations, versioning strategies, and pagination techniques, and provides concrete examples and guidelines to help developers create robust, maintainable, and developer‑friendly APIs.

API designPaginationREST
0 likes · 7 min read
Best Practices for Designing a Good API
Code Ape Tech Column
Code Ape Tech Column
Sep 26, 2022 · Databases

Cross-Database/Table Pagination Query Solutions for Sharded Systems

This article examines the challenges of pagination after database sharding and presents three practical solutions—global query, jump‑page prohibition, and two‑step query—detailing their implementations, trade‑offs, and performance considerations for large‑scale order services.

PaginationSQL
0 likes · 12 min read
Cross-Database/Table Pagination Query Solutions for Sharded Systems
dbaplus Community
dbaplus Community
Sep 25, 2022 · Databases

How to Speed Up MySQL Deep Pagination on Millions of Rows

This article explains why using LIMIT with large offsets slows MySQL queries, analyzes the execution flow, and presents four practical optimization techniques—including subqueries, INNER JOIN, bookmark (tag‑record) method, and BETWEEN range scans—backed by real‑world performance data and code examples.

B+TreeMySQLOptimization
0 likes · 10 min read
How to Speed Up MySQL Deep Pagination on Millions of Rows