BestHub
Sign in
Tagged articles

pagination

347 articles · Page 1 of 4
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 28, 2026 · Databases

8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)

This article details eight common SQL anti-patterns — including OFFSET pagination, implicit type conversion, correlated subqueries in updates, mixed sorting, EXISTS clauses, blocked condition pushdown, late filtering, and unoptimized intermediate results — with execution plans and rewrites that reduce query times from seconds to milliseconds.

CTEMySQLSQL optimization
0 likes · 16 min read
8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)
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
Shuge Unlimited
Shuge Unlimited
Sep 16, 2026 · Databases

Why Milvus 3.0 Pagination Breaks After Reranking: When Cursor Scores Cross Worlds

Milvus 3.0's search iterator pagination fails after reranking because the cursor uses the last page's score as a boundary, but reranking replaces ANN distances with model predictions (e.g., XGBoost raw scores), causing the filter condition to exclude nothing and return duplicate pages. Milvus now explicitly rejects combining function chains with search iterators rather than fixing pagination, as the fix would require carrying original distances through the entire reduce pipeline—a feature-level change. Workarounds include using offset within single-search limits or moving reranking to the application layer.

MilvusXGBoostfunction chain
0 likes · 21 min read
Why Milvus 3.0 Pagination Breaks After Reranking: When Cursor Scores Cross Worlds
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Aug 28, 2026 · Backend Development

Spring Boot + JPA (Hibernate 7.4): One Annotation for Pagination, History, and Audit Tables

The article demonstrates how Hibernate 7.4, used with Spring Boot 3.5, adds built‑in support for safe pagination of collection fetches, temporal history tables, and native audit tables, all configurable via a single annotation and a few properties, with concrete code examples and runtime screenshots.

Audit TableHibernate 7.4History Table
0 likes · 8 min read
Spring Boot + JPA (Hibernate 7.4): One Annotation for Pagination, History, and Audit Tables
Raymond Ops
Raymond Ops
Aug 11, 2026 · Databases

How to Diagnose MySQL Slow Queries: From Log Capture to Index Optimization

This guide walks MySQL operators through a complete slow‑query troubleshooting workflow—starting with enabling and analyzing the slow‑query log, using pt‑query‑digest and EXPLAIN to pinpoint index, SQL, schema, configuration or hardware bottlenecks, and then applying concrete optimizations such as proper indexing, cursor pagination, JOIN tuning, and server‑level parameter tweaks.

Buffer PoolEXPLAINIndex Optimization
0 likes · 33 min read
How to Diagnose MySQL Slow Queries: From Log Capture to Index Optimization
Java Tech Workshop
Java Tech Workshop
Aug 7, 2026 · Backend Development

Mastering MyBatis-Plus IPage: A Unified Solution for Pagination and Full-Data Export

This article examines common pitfalls of MyBatis-Plus IPage pagination, explains why naive approaches like using two mapper methods or setting pageSize to Integer.MAX_VALUE cause performance and consistency issues, and presents a single‑SQL strategy with custom count handling, cursor streaming, and best‑practice configurations for seamless pagination and full‑data export.

BackendCursorFull Export
0 likes · 20 min read
Mastering MyBatis-Plus IPage: A Unified Solution for Pagination and Full-Data Export
Architect's Guide
Architect's Guide
Aug 5, 2026 · Databases

How to Combine Pagination and Multi‑Condition Fuzzy Search in Redis

This article explains how to implement pagination using Redis Sorted Sets, achieve multi‑condition fuzzy queries with Hashes and HSCAN, and then combine both techniques into a single solution while discussing performance trade‑offs and optimization strategies such as key expiration and data‑sync methods.

HSCANRedisSorted Set
0 likes · 9 min read
How to Combine Pagination and Multi‑Condition Fuzzy Search in Redis
MaGe Linux Operations
MaGe Linux Operations
Aug 4, 2026 · Databases

Why 70% of System Outages Stem from SQL Performance: A MySQL Index Optimization Guide

The article walks through a systematic MySQL 8.0 index‑optimization workflow—starting with diagnosing slow queries and lock waits, validating execution plans with EXPLAIN ANALYZE, safely adding or dropping indexes using online DDL, handling pagination patterns, and verifying improvements via comprehensive metrics before and after.

EXPLAIN ANALYZEIndex OptimizationMySQL
0 likes · 12 min read
Why 70% of System Outages Stem from SQL Performance: A MySQL Index Optimization Guide
Java Architect Handbook
Java Architect Handbook
Jul 26, 2026 · Databases

Interview Question: What Problems Arise After Sharding? List the Key Issues

The article outlines six major challenges introduced by database sharding—cross‑database joins, pagination, distributed transactions, global ID generation, data migration, and aggregation—along with practical solutions such as binding tables, cursor pagination, Seata AT mode, Snowflake IDs, dual‑write scaling, and summary tables, providing interview‑ready answers.

SeataSnowflakedatabase partitioning
0 likes · 17 min read
Interview Question: What Problems Arise After Sharding? List the Key Issues
Dabaoshi
Dabaoshi
Jul 26, 2026 · Databases

Practical MySQL SQL Optimization: How to Locate and Rewrite Slow Queries

The article explains how to make MySQL do less work by reducing scanned rows, avoiding back‑and‑forth lookups with covering indexes, and minimizing sorting or temporary tables, while detailing common index pitfalls, deep pagination tricks, COUNT usage, ORDER BY/filesort handling, JOIN strategies, and step‑by‑step methods for finding and fixing slow SQL statements.

Covering IndexEXPLAINJOIN
0 likes · 17 min read
Practical MySQL SQL Optimization: How to Locate and Rewrite Slow Queries
LuTiao Programming
LuTiao Programming
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
Architect Chen
Architect Chen
Jul 9, 2026 · Databases

Essential Elasticsearch Commands (2026 Edition)

This guide walks through the most important Elasticsearch commands, covering cluster health checks, index listing, creation with mappings, deletion, mapping inspection, document insertion (with and without IDs), various query types, updates, deletions, pagination, sorting, and bulk operations, each illustrated with concrete examples and usage notes.

ElasticsearchIndexingMapping
0 likes · 5 min read
Essential Elasticsearch Commands (2026 Edition)
samdeepthink
samdeepthink
Jul 3, 2026 · Backend Development

MyBatis-Flex vs MyBatis-Plus: A Detailed Source‑Code and Feature Comparison

This article walks through a side‑by‑side examination of MyBatis‑Flex and MyBatis‑Plus, covering entity annotations, query construction, pagination, architectural differences, APT‑generated code, multi‑table joins, partial updates, and the trade‑offs of each design, helping developers choose the right ORM for their projects.

Multi-table joinMyBatis-FlexMyBatis-Plus
0 likes · 16 min read
MyBatis-Flex vs MyBatis-Plus: A Detailed Source‑Code and Feature Comparison
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jul 2, 2026 · Backend Development

Why Spring Boot Prefers Slice Over Page for Massive Data Sets

The article analyzes Spring Data JPA's Page and Slice pagination options, explains the hidden COUNT(*) overhead of Page, demonstrates both approaches with code examples, compares performance and UX impacts, and provides guidance on when to choose Slice for large‑scale or infinite‑scroll scenarios.

BackendPerformanceSpring Boot
0 likes · 11 min read
Why Spring Boot Prefers Slice Over Page for Massive Data Sets
Linyb Geek Road
Linyb Geek Road
Jun 30, 2026 · Backend Development

How to Design Pagination for Billion‑Row Sharded Databases in an Interview

The article systematically breaks down pagination challenges in billion‑row sharded databases, compares common sharding strategies and middleware architectures, analyzes the performance drawbacks of a naïve global‑query approach, and presents several practical alternatives—including keyset pagination, two‑stage queries, index‑table tricks, and external search or NewSQL solutions—while highlighting their trade‑offs for interview discussions.

PerformanceSQLdistributed databases
0 likes · 24 min read
How to Design Pagination for Billion‑Row Sharded Databases in an Interview
Linyb Geek Road
Linyb Geek Road
Jun 30, 2026 · Databases

Implementing Efficient Pagination Across Sharded Databases

The article analyzes why traditional LIMIT/OFFSET pagination fails when data is split across multiple databases, presents a global query approach with its trade‑offs, and proposes an optimized "no‑skip" method plus practical tips using ShardingSphere and Elasticsearch.

ElasticsearchShardingSpheredatabase
0 likes · 7 min read
Implementing Efficient Pagination Across Sharded Databases
CodeSmart Hoops
CodeSmart Hoops
Jun 22, 2026 · Backend Development

MyBatis-Plus Interview Self-Test: Full Core Analysis and Pitfall Checklist

This article presents a comprehensive interview self‑test for MyBatis‑Plus, covering its relationship with MyBatis, BaseMapper CRUD implementation, SqlMethod and AbstractMethod roles, MapperProxy interception, LambdaQueryWrapper type safety, Wrapper condition handling, interceptor chain, pagination mechanisms, logical delete rewriting, MetaObjectHandler fill timing, thread‑safety pitfalls, and best‑practice recommendations.

BaseMapperInterceptorLambdaQueryWrapper
0 likes · 22 min read
MyBatis-Plus Interview Self-Test: Full Core Analysis and Pitfall Checklist
CodeSmart Hoops
CodeSmart Hoops
Jun 17, 2026 · Backend Development

Hands‑On Unit Testing of MyBatis‑Plus with Spring Boot 3

This guide demonstrates how to set up a Spring Boot 3.x project with MyBatis‑Plus, configure Maven dependencies, H2 database, and JPA, then write comprehensive JUnit 5 tests covering CRUD, LambdaQueryWrapper queries, pagination, logical deletion, and automatic timestamp filling, with step‑by‑step commands to run the tests.

JUnit 5MyBatis-PlusORM
0 likes · 20 min read
Hands‑On Unit Testing of MyBatis‑Plus with Spring Boot 3
Top Architect
Top Architect
Jun 11, 2026 · Backend Development

How to Speed Up Large-Scale Queries with MyBatisPlus

The article analyzes why conventional MyBatisPlus queries become slow and memory‑intensive when handling millions of rows, then demonstrates three alternatives—regular pagination, stream query, and cursor query—showing their implementation, trade‑offs, and practical tips for avoiding OOM and improving performance.

CursorLarge DataMySQL
0 likes · 10 min read
How to Speed Up Large-Scale Queries with MyBatisPlus
liandk
liandk
May 19, 2026 · Frontend Development

Full Vue 3 + Element Plus Component: Layout, Table, Pagination, Forms, Dialogs, Breadcrumbs, Skeleton, Upload & Tree Menu

This article provides a complete Vue 3 single‑file component using Element Plus that demonstrates a unified layout container with breadcrumbs, a searchable table, pagination, form validation, dialogs, file upload, and a tree‑style menu, all ready to copy and use without configuration.

Element PlusForm ValidationLayout
0 likes · 11 min read
Full Vue 3 + Element Plus Component: Layout, Table, Pagination, Forms, Dialogs, Breadcrumbs, Skeleton, Upload & Tree Menu
Cloud Architecture
Cloud Architecture
May 16, 2026 · Databases

MySQL 8.x Large Pagination Guide: From OFFSET Performance Pitfalls to Production‑Ready Cursor Pagination

This article explains why deep OFFSET pagination in MySQL 8.x forces the database to scan, sort and discard massive rows, outlines four categories of pagination bottlenecks, and presents a step‑by‑step engineering roadmap—including covering indexes, delayed joins, cursor pagination, Elasticsearch integration, API contracts, and production‑grade Spring Boot/MyBatis code—to eliminate the performance black‑hole and build a scalable pagination architecture.

CursorElasticsearchMySQL
0 likes · 35 min read
MySQL 8.x Large Pagination Guide: From OFFSET Performance Pitfalls to Production‑Ready Cursor Pagination
Java Tech Enthusiast
Java Tech Enthusiast
May 2, 2026 · Backend Development

10 Common MyBatis‑Plus Pitfalls and How to Avoid Them

This article enumerates ten frequent pitfalls when using MyBatis‑Plus—such as incorrect total counts in pagination, pagination interceptor misconfiguration, logical‑delete failures, auto‑fill issues, optimistic‑lock mismatches, null handling in query wrappers, poor batch‑insert performance, enum mapping errors, type‑handler problems, and overall pros and cons—providing concrete examples, root‑cause analysis, and practical solutions for each.

BatchInsertEnumMappingLogicalDelete
0 likes · 20 min read
10 Common MyBatis‑Plus Pitfalls and How to Avoid Them
IT Services Circle
IT Services Circle
Apr 29, 2026 · Backend Development

10 Common MyBatis-Plus Pitfalls and How to Avoid Them

This article analyzes ten frequent pitfalls when using MyBatis-Plus—such as incorrect pagination totals, pagination plugin misconfiguration, logical delete failures, auto‑fill issues, optimistic‑lock mismatches, null handling in QueryWrapper, batch‑insert performance, enum mapping errors, wrapper condition overrides, and type‑handler problems—provides root‑cause explanations, concrete code examples, and practical solutions to help developers write more robust and efficient Java backend code.

Batch InsertEnum MappingMyBatis-Plus
0 likes · 19 min read
10 Common MyBatis-Plus Pitfalls and How to Avoid Them
Java Backend Technology
Java Backend Technology
Apr 28, 2026 · Backend Development

10 Common MyBatis-Plus Pitfalls and How to Avoid Them

This article examines ten frequent pitfalls when using MyBatis-Plus—such as incorrect pagination counts, disabled pagination, logical‑delete mishandling, auto‑fill failures, optimistic‑lock issues, batch‑insert slowness, enum mapping errors, JSON type‑handler problems, and query‑wrapper quirks—explains their causes, and provides concrete code‑level solutions and best‑practice recommendations.

Batch InsertEnum MappingJSON TypeHandler
0 likes · 18 min read
10 Common MyBatis-Plus Pitfalls and How to Avoid Them
Su San Talks Tech
Su San Talks Tech
Apr 27, 2026 · Backend Development

10 Common Pitfalls in MyBatis-Plus and How to Avoid Them

The article enumerates ten typical traps when using MyBatis-Plus—such as incorrect pagination counts, ineffective pagination plugins, logical delete mishandling, auto‑fill failures, optimistic‑lock issues, null‑value conditions, batch‑insert slowness, enum mapping errors, wrapper overwrites, and type‑handler problems—explains why they occur, and provides concrete code‑level solutions and best‑practice recommendations.

Batch InsertEnum MappingMyBatis-Plus
0 likes · 19 min read
10 Common Pitfalls in MyBatis-Plus and How to Avoid Them
Top Architect
Top Architect
Apr 24, 2026 · Backend Development

How MyBatis‑Plus Handles Slow Queries on Massive Datasets

The article explains why ordinary MyBatisPlus pagination becomes slow and memory‑hungry when processing millions of rows, and demonstrates three alternatives—regular query, stream query, and cursor query—detailing their implementations, trade‑offs, and practical code snippets for MySQL and Oracle environments.

CursorLarge DataMybatisPlus
0 likes · 10 min read
How MyBatis‑Plus Handles Slow Queries on Massive Datasets
Architecture & Thinking
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 PaginationMySQLPerformance
0 likes · 30 min read
Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It
Tech Ocean
Tech Ocean
Apr 16, 2026 · Backend Development

Eliminate Repeated Auth and Pagination Code with FastAPI Dependency Injection

This article shows how FastAPI's dependency injection can centralize authentication, permission checks, database connection lifecycles, and pagination logic, removing duplicated code across endpoints by defining reusable dependencies, sub‑dependencies, and yield‑based resources, with concrete code examples and test results.

AuthenticationBackendDependency Injection
0 likes · 5 min read
Eliminate Repeated Auth and Pagination Code with FastAPI Dependency Injection
Java Tech Workshop
Java Tech Workshop
Apr 1, 2026 · Backend Development

Complete Guide to Integrating SpringBoot with MyBatis

This article walks through a full SpringBoot‑MyBatis integration, covering Maven dependencies, application.yml configuration, database schema, entity definition, mapper XML, service layer with transactions and pagination, REST controller endpoints, key features, and common pitfalls.

CRUDSpringBootjava
0 likes · 13 min read
Complete Guide to Integrating SpringBoot with MyBatis
LuTiao Programming
LuTiao Programming
Mar 14, 2026 · Backend Development

Why Your Spring Boot App Freezes at One Million Records – 5 Proven Techniques to Double Performance

When a Spring Boot application reaches millions of rows, it often suffers from OutOfMemoryErrors, slow queries, and high CPU, but by applying five proven strategies—pagination, streaming, batch processing, indexing, and asynchronous execution—you can halve memory usage and achieve up to ten‑fold speed gains.

Asynchronous ExecutionBatch ProcessingIndexing
0 likes · 11 min read
Why Your Spring Boot App Freezes at One Million Records – 5 Proven Techniques to Double Performance
Selected Java Interview Questions
Selected Java Interview Questions
Mar 9, 2026 · Databases

How to Paginate Efficiently Across Sharded Databases Without OOM

This article explains why pagination only becomes complex when querying across sharded databases, compares three common solutions—including global search, sequential ID‑based paging, and the discouraged secondary query method—provides practical SQL examples, outlines pros and cons, and offers a STAR‑style interview answer.

SQLpaginationsharding
0 likes · 6 min read
How to Paginate Efficiently Across Sharded Databases Without OOM
ITPUB
ITPUB
Mar 2, 2026 · Backend Development

Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems

This article explains why traditional offset‑based pagination can cause duplicate or missing records when data changes, compares three practical solutions—including cursor pagination with timestamp + unique key, fixed‑window timestamp filtering, and Elasticsearch’s search_after/scroll methods—detailing their implementation, pros, cons, and suitable scenarios.

BackendCursorElasticsearch
0 likes · 14 min read
Eliminate Unstable Pagination Anchors: Reliable Cursor and Timestamp Strategies for Backend Systems
Code Mala Tang
Code Mala Tang
Feb 22, 2026 · Backend Development

Why FastAPI Slows Down with Millions of Rows—and How to Keep It Fast

FastAPI feels lightning‑fast on small datasets, but returning millions of rows can exhaust memory, block the event loop, and cripple the database; this article explains why that happens and provides concrete design rules—selective fields, pagination, cursor‑based queries, streaming, and chunked processing—to keep APIs stable at scale.

FastAPIStreaminglarge datasets
0 likes · 9 min read
Why FastAPI Slows Down with Millions of Rows—and How to Keep It Fast
dbaplus Community
dbaplus Community
Feb 10, 2026 · Backend Development

How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems

This article explains why offset‑based pagination can cause duplicate or missing records in backend list queries, illustrates real‑world cases, analyzes the root causes, and presents three practical solutions—including cursor pagination, timestamp windows, and Elasticsearch search_after—along with their trade‑offs and implementation details.

CursorElasticsearchPerformance
0 likes · 12 min read
How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems
Selected Java Interview Questions
Selected Java Interview Questions
Feb 4, 2026 · Databases

How to Handle Pagination Across Sharded Databases Without Performance Pitfalls

This article explains why pagination only becomes complex when queries span multiple database shards, compares three mainstream solutions—including middleware, open‑source frameworks, and business compromises—highlights the pitfalls of global search for deep pages, and recommends sequential paging based on the previous page’s max ID, with interview‑ready STAR guidance.

PerformanceSQLinterview
0 likes · 7 min read
How to Handle Pagination Across Sharded Databases Without Performance Pitfalls
Architect's Guide
Architect's Guide
Jan 17, 2026 · Backend Development

How We Split a 500M‑Row MySQL Table: Lessons and Strategies

Facing a 50‑million‑row financial transaction table that grew 600,000 rows each month, the team designed a sharding solution using sharding‑jdbc, tackled multi‑datasource transaction and pagination challenges, and executed a staged migration that kept the system stable while eliminating MySQL performance bottlenecks.

data-migrationpaginationsharding
0 likes · 13 min read
How We Split a 500M‑Row MySQL Table: Lessons and Strategies
SpringMeng
SpringMeng
Jan 16, 2026 · Backend Development

What Unexpected Pitfalls PageHelper Can Teach You After Years of Use

The article recounts a developer’s painful experience with PageHelper, detailing how duplicate registrations, truncated result sets, and password‑update errors stem from the plugin’s ThreadLocal pagination handling, and explains the underlying code paths and safe usage practices.

BackendSQLThreadLocal
0 likes · 13 min read
What Unexpected Pitfalls PageHelper Can Teach You After Years of Use
macrozheng
macrozheng
Jan 6, 2026 · Backend Development

Why PageHelper Can Break Your MyBatis Queries and How to Fix It

The article examines unexpected bugs caused by PageHelper’s hidden LIMIT clause injection in MyBatis projects, explains how ThreadLocal pagination parameters persist across requests, and provides practical guidelines and code examples to avoid and clean up these issues.

ThreadLocaljavamybatis
0 likes · 13 min read
Why PageHelper Can Break Your MyBatis Queries and How to Fix It
Top Architect
Top Architect
Jan 2, 2026 · Databases

Boost MySQL Performance: Master Pagination, Indexes, JOINs, and Query Rewrite Techniques

This article walks through common MySQL performance pitfalls such as inefficient pagination, implicit type conversion, costly UPDATE/DELETE subqueries, mixed sorting, and EXISTS clauses, and demonstrates practical rewrites—including index usage, JOIN conversion, condition push‑down, early LIMIT, and WITH‑clauses—to transform slow queries into millisecond‑level executions.

JOINMySQLQuery Rewrite
0 likes · 13 min read
Boost MySQL Performance: Master Pagination, Indexes, JOINs, and Query Rewrite Techniques
Java Companion
Java Companion
Dec 29, 2025 · Backend Development

Avoid OOM: EasyExcel Best Practices for Exporting Millions of Rows (with Ready‑to‑Use Helper)

This article explains why exporting large Excel files with EasyExcel can cause OOM, CPU blockage, and slow responses, and demonstrates a pagination‑query plus batch‑write solution with reusable helper classes, performance benchmarks, dynamic page sizing, async export, multi‑sheet and template techniques, and a concise best‑practice checklist.

@AsyncEasyExcelExcel Export
0 likes · 15 min read
Avoid OOM: EasyExcel Best Practices for Exporting Millions of Rows (with Ready‑to‑Use Helper)
php Courses
php Courses
Dec 23, 2025 · Backend Development

How to Reduce Server Load with PHP: Caching, Pagination, and Result Caching Techniques

Learn practical PHP strategies to lower server load—including using Memcached or Redis for data caching, implementing pagination to limit query size, and caching computational results—complete with clear code snippets and guidance on adapting these techniques to improve performance and stability.

backend optimizationpaginationserver performance
0 likes · 4 min read
How to Reduce Server Load with PHP: Caching, Pagination, and Result Caching Techniques
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Dec 23, 2025 · Frontend Development

Generate Multi‑Page PDFs Directly in the Browser with dompdf.js

dompdf.js v1.1.0 lets developers convert HTML to searchable, lightweight, multi‑page PDFs entirely on the front end, fixing blur, large size, and inaccurate pagination issues, and provides features such as custom headers/footers, encryption, compression, font handling, and browser‑compatible rendering options.

JavaScriptPDF generationdompdf.js
0 likes · 12 min read
Generate Multi‑Page PDFs Directly in the Browser with dompdf.js
Su San Talks Tech
Su San Talks Tech
Dec 18, 2025 · Backend Development

Which Elasticsearch Pagination Method Is Best? from/size, search_after, Scroll API & PIT

This guide compares Elasticsearch’s four common pagination techniques—`from/size`, `search_after`, Scroll API, and Point in Time—detailing their syntax, advantages, drawbacks, and ideal use‑cases, helping developers select the most efficient method based on pagination depth, consistency requirements, and resource constraints.

BackendElasticsearchpagination
0 likes · 10 min read
Which Elasticsearch Pagination Method Is Best? from/size, search_after, Scroll API & PIT
DevOps Coach
DevOps Coach
Dec 11, 2025 · Backend Development

Designing Clear and Consistent RESTful APIs: Best Practices

This guide teaches you how to design clean, consistent RESTful APIs by following proven best practices for resource modeling, URL design, filtering, sorting, pagination, proper HTTP methods, status codes, error handling, and versioning to avoid common pitfalls and improve maintainability.

API DesignFilteringHTTP
0 likes · 5 min read
Designing Clear and Consistent RESTful APIs: Best Practices
macrozheng
macrozheng
Dec 8, 2025 · Databases

Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It

This tutorial demonstrates how MySQL LIMIT pagination performs on tables with millions of rows, measures query times for various offsets and batch sizes, and presents practical optimization techniques such as sub‑queries, ID‑range filtering, and column selection to improve speed.

LIMITMySQLOptimization
0 likes · 9 min read
Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It
Ray's Galactic Tech
Ray's Galactic Tech
Dec 7, 2025 · Databases

Mastering MySQL Large-Scale Pagination: Ultimate Optimized Techniques

This article examines why traditional MySQL LIMIT offset pagination degrades performance on massive tables and presents five database‑level solutions plus engineering best practices—including delayed joins, covering indexes, cursor pagination, window functions, and partitioning—to achieve fast, scalable paging.

CursorIndexingMySQL
0 likes · 8 min read
Mastering MySQL Large-Scale Pagination: Ultimate Optimized Techniques
Code Ape Tech Column
Code Ape Tech Column
Dec 5, 2025 · Big Data

Optimizing 100K Record Retrieval from 10M‑Row Pools: ClickHouse, ES Scroll, ES+HBase, RediSearch

This article examines several engineering solutions for extracting up to 100,000 records from a ten‑million‑row pool, comparing multi‑threaded ClickHouse pagination, Elasticsearch scroll‑scan, an ES‑plus‑HBase hybrid, and RediSearch + RedisJSON, and presents performance measurements and practical trade‑offs.

ClickHouseElasticsearchHBase
0 likes · 12 min read
Optimizing 100K Record Retrieval from 10M‑Row Pools: ClickHouse, ES Scroll, ES+HBase, RediSearch
php Courses
php Courses
Dec 1, 2025 · Frontend Development

How to Accurately Calculate and Display Pagination Indexes in JavaScript

This guide explains common pagination index problems in web apps and provides a step‑by‑step JavaScript solution—including a reusable function, a full HTML component, handling of empty and dynamic data sets, best‑practice tips, and complete code examples—for seamless user navigation.

Index CalculationJavaScriptfrontend
0 likes · 8 min read
How to Accurately Calculate and Display Pagination Indexes in JavaScript
Java Architect Handbook
Java Architect Handbook
Nov 30, 2025 · Databases

When Sharding Fails: Debugging Pagination Bugs and Optimizing MySQL for Massive Tables

The article recounts a real‑world case where a massive device table (over 500 million rows) suffered from sharding and Elasticsearch integration issues, describes a pagination bug caused by Sharding‑JDBC, and presents a comprehensive set of hardware, software, and SQL optimization techniques—including MySQL configuration examples—to improve performance.

ElasticsearchMySQLSharding-JDBC
0 likes · 13 min read
When Sharding Fails: Debugging Pagination Bugs and Optimizing MySQL for Massive Tables
Programmer1970
Programmer1970
Nov 25, 2025 · Databases

10 Essential MySQL Interview Queries (Part 3) – Solutions and Explanations

This article presents ten practical MySQL interview questions covering consecutive‑login detection, efficient pagination, top‑salary per department, customers without orders, cumulative sales, recursive cycle detection, pivoting rows to columns, duplicate removal, and user retention, each with complete SQL statements, underlying principles, and performance considerations.

CTEMySQLSQL
0 likes · 11 min read
10 Essential MySQL Interview Queries (Part 3) – Solutions and Explanations
Su San Talks Tech
Su San Talks Tech
Nov 24, 2025 · Backend Development

Choosing the Right Elasticsearch Pagination Method: from/size, search_after, Scroll API, and PIT

This article examines the four primary Elasticsearch pagination techniques—using from/size, search_after, the Scroll API, and Point in Time—detailing their syntax, advantages, disadvantages, suitable scenarios, and provides guidance on selecting the optimal method based on depth, consistency, and resource constraints.

Backend Developmentpaginationpoint in time
0 likes · 10 min read
Choosing the Right Elasticsearch Pagination Method: from/size, search_after, Scroll API, and PIT
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Nov 7, 2025 · Backend Development

Unlock 6 Powerful Spring Data JPA Features for Faster Development

This article introduces Spring Data JPA and demonstrates six advanced capabilities—including Optional return types, Stream API, asynchronous CompletableFuture queries, offset‑based scrolling, and keyset‑based scrolling—each illustrated with concise code examples and execution results to boost productivity and performance.

@AsyncKeyset ScrollingOptional
0 likes · 8 min read
Unlock 6 Powerful Spring Data JPA Features for Faster Development
Top Architect
Top Architect
Nov 4, 2025 · Backend Development

Master MyBatis-Plus in Spring Boot: From Setup to Advanced Features

This tutorial walks you through integrating MyBatis-Plus with Spring Boot, covering environment preparation, Maven dependencies, configuration of data sources, entity annotations, CRUD operations, pagination, logical deletion, enum handling, automatic field filling, multi‑datasource support, and testing with a REST controller.

CRUDEnum MappingMulti-DataSource
0 likes · 18 min read
Master MyBatis-Plus in Spring Boot: From Setup to Advanced Features
Architect
Architect
Oct 9, 2025 · Databases

How to Implement Pagination and Fuzzy Search in Redis Efficiently

This article explains how to achieve conditional queries and pagination in Redis using Sorted Sets and Hashes, outlines the implementation steps for pagination, fuzzy multi‑condition search, their combination, and discusses performance optimizations such as expiration and real‑time data handling.

RedisSorted Setfuzzy search
0 likes · 11 min read
How to Implement Pagination and Fuzzy Search in Redis Efficiently
Su San Talks Tech
Su San Talks Tech
Sep 30, 2025 · Databases

Mastering Sharded Pagination: 3 Proven Techniques to Avoid Performance Pitfalls

This article explains why using traditional LIMIT pagination on sharded databases can cause full‑shard scans and memory‑intensive sorting, and introduces three practical alternatives—anchor pagination, shard‑mark pagination, and reverse pagination—detailing their implementation steps, performance benefits, and common pitfalls to avoid.

SQLdatabasepagination
0 likes · 10 min read
Mastering Sharded Pagination: 3 Proven Techniques to Avoid Performance Pitfalls
Lobster Programming
Lobster Programming
Sep 28, 2025 · Databases

Mastering Pagination in Sharded Databases: Global Query and No‑Skip Strategies

With massive data growth, sharding databases introduces pagination challenges; this article explains the root cause of pagination issues in sharded environments, presents the global query method, its pros and cons, and introduces the no‑skip optimization to improve performance while maintaining data accuracy.

distributed databasesglobal queryno-skip optimization
0 likes · 7 min read
Mastering Pagination in Sharded Databases: Global Query and No‑Skip Strategies
Senior Brother's Insights
Senior Brother's Insights
Sep 25, 2025 · Databases

Offset/Limit vs Cursor Pagination in MySQL: When and How to Choose

This article explains why selecting only needed columns and ensuring deterministic ordering are essential for MySQL queries, then compares Offset/Limit pagination with cursor‑based pagination, detailing their syntax, advantages, drawbacks such as data drift and performance issues, and offers practical optimization tips.

MySQLOFFSET LIMITdeterministic ordering
0 likes · 12 min read
Offset/Limit vs Cursor Pagination in MySQL: When and How to Choose
Ray's Galactic Tech
Ray's Galactic Tech
Sep 23, 2025 · Backend Development

Master MyBatis-Plus: Quick Start, Core Features, and Best Practices

This guide walks through adding MyBatis-Plus to a Spring Boot project, configuring basic settings, using CRUD operations, condition builders, pagination, advanced features like auto‑fill, logical delete, optimistic locking, code generation, common pitfalls, and practical recommendations for effective usage.

CRUDMyBatis-PlusORM
0 likes · 7 min read
Master MyBatis-Plus: Quick Start, Core Features, and Best Practices
Architects Research Society
Architects Research Society
Sep 12, 2025 · Backend Development

5 Proven API Performance Hacks for High‑Concurrency Systems

This article presents five practical API performance optimization techniques for high‑concurrency environments, covering pagination with cursor queries, asynchronous logging, multi‑level caching, data compression, and connection‑pool tuning, along with key configuration tips and a golden rule to monitor before optimizing.

APICachingOptimization
0 likes · 2 min read
5 Proven API Performance Hacks for High‑Concurrency Systems
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.

MySQLPostgreSQLSQL
0 likes · 8 min read
Why OFFSET Slows Your API and How Keyset Pagination Boosts Speed
Architect's Tech Stack
Architect's Tech Stack
Sep 1, 2025 · Backend Development

Boost Your Java Backend with MyBatisPlusPro: A Complete CRUD Controller Guide

This article walks through building a reusable BaseController using MyBatisPlusPro in a Spring Boot application, covering dependency setup, utility methods for query conversion, generic CRUD endpoints, pagination configuration, and how to extend the controller for specific entities, providing ready‑to‑use code snippets for each step.

Backend DevelopmentCRUDMybatisPlus
0 likes · 10 min read
Boost Your Java Backend with MyBatisPlusPro: A Complete CRUD Controller Guide
Architecture Digest
Architecture Digest
Aug 25, 2025 · Backend Development

Boost Your Spring Boot Apps with a Reusable MyBatisPlus Controller Layer

This article walks through creating a reusable MyBatisPlus‑based controller framework for Spring Boot, covering dependency setup, utility methods for query building and reflection, a generic BaseController with full CRUD endpoints, pagination configuration, and concrete controller extensions, enabling rapid development of RESTful APIs.

CRUDControllerMybatisPlus
0 likes · 9 min read
Boost Your Spring Boot Apps with a Reusable MyBatisPlus Controller Layer
macrozheng
macrozheng
Jul 28, 2025 · Databases

Why MySQL Pagination Slows Down at Scale and How to Speed It Up

This article examines how MySQL pagination performance degrades as table size grows, presents benchmark results for various offsets, defines slow SQL thresholds, and offers three optimization strategies—including selecting only primary keys, ID‑based filtering, and leveraging Elasticsearch—to dramatically improve query speed.

ElasticsearchMySQLdatabase
0 likes · 10 min read
Why MySQL Pagination Slows Down at Scale and How to Speed It Up
Java Web Project
Java Web Project
Jul 26, 2025 · Backend Development

How a Simple Pagination Change Triggered a P0 Outage and What We Learned

A seemingly trivial pagination update in a Java order service caused a P0 outage, leading to a 73‑minute disruption, 156 user complaints, and an estimated 650,000 CNY GMV loss; the post details the root cause, impact analysis, emergency response, and concrete process improvements to prevent recurrence.

BackendMicroservicesincident management
0 likes · 14 min read
How a Simple Pagination Change Triggered a P0 Outage and What We Learned
Code Mala Tang
Code Mala Tang
Jul 12, 2025 · Frontend Development

Master Data Fetching in React with TanStack Query: From Simple Queries to Optimistic Updates

This guide walks you through using TanStack Query in React, covering simple queries, custom hooks, selectors, dependent queries, pagination, infinite scrolling, query key factories, mutations, query invalidation, conditional fetching, optimistic updates, and global error handling with Suspense, all illustrated with clear code examples.

Data FetchingOptimistic UpdateReAct
0 likes · 7 min read
Master Data Fetching in React with TanStack Query: From Simple Queries to Optimistic Updates
IT Services Circle
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 PaginationDatabase IndexingMySQL
0 likes · 8 min read
Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques
Java Captain
Java Captain
Jun 28, 2025 · Backend Development

How to Add a Creator Province Filter to a To-Do Page and Fix Pagination Bugs

This article walks through adding a creator‑province dropdown filter to a to‑do list page, updating both front‑end components and back‑end APIs, handling status count changes, implementing reset logic, and debugging a pagination bug caused by incorrect start‑row calculations.

APISQLfrontend
0 likes · 9 min read
How to Add a Creator Province Filter to a To-Do Page and Fix Pagination Bugs
Java Captain
Java Captain
Jun 16, 2025 · Backend Development

Master MyBatis-Plus with Spring Boot: CRUD, Pagination & Multi-DataSource Guide

A comprehensive step‑by‑step tutorial shows how to integrate MyBatis‑Plus into a Spring Boot project, covering dependencies, configuration, entity annotations, CRUD operations, pagination, logical deletion, enum handling, automatic field filling, multi‑datasource support, and testing.

CRUDMulti-DataSourceMyBatis-Plus
0 likes · 13 min read
Master MyBatis-Plus with Spring Boot: CRUD, Pagination & Multi-DataSource Guide
Java Web Project
Java Web Project
Jun 8, 2025 · Backend Development

How to Build a Reusable CRUD BaseController with MyBatis‑Plus in Spring Boot

This tutorial walks through creating a generic BaseController that provides CRUD, list, pagination, and count operations for any entity by adding MyBatis‑Plus, writing a utility class for query building, configuring a pagination interceptor, and extending the base class in concrete controllers, all illustrated with complete Java code snippets.

BaseControllerCRUDMyBatis-Plus
0 likes · 8 min read
How to Build a Reusable CRUD BaseController with MyBatis‑Plus in Spring Boot
Top Architect
Top Architect
May 24, 2025 · Databases

Implementing Pagination and Multi‑Condition Fuzzy Search in Redis

This article explains how to use Redis Sorted Sets and Hashes to achieve efficient pagination, fuzzy multi‑condition queries, and their combination, while also discussing performance‑optimisation strategies such as temporary ZSet expiration and data‑freshness handling, before concluding with a brief promotional segment.

RedisSorted Setdatabase
0 likes · 12 min read
Implementing Pagination and Multi‑Condition Fuzzy Search in Redis
Java Architect Essentials
Java Architect Essentials
May 15, 2025 · Backend Development

How @PageableDefault Simplifies SpringBoot Pagination

The article explains how the SpringBoot @PageableDefault annotation automatically provides default pagination parameters, reducing boilerplate code, improving readability, and offering flexible control for various query endpoints in Java backend development.

BackendSpringBootannotation
0 likes · 6 min read
How @PageableDefault Simplifies SpringBoot Pagination
Java Tech Enthusiast
Java Tech Enthusiast
May 15, 2025 · Backend Development

Automate CRUD with a Generic BaseController in Spring Boot

This guide shows how to create a reusable BaseController using MyBatis‑Plus, reflection utilities, and Spring Boot annotations to provide automatic CRUD, list, pagination and count endpoints for any entity with minimal code.

CRUDGeneric ControllerMyBatis-Plus
0 likes · 10 min read
Automate CRUD with a Generic BaseController in Spring Boot
Cognitive Technology Team
Cognitive Technology Team
May 15, 2025 · Databases

How to Solve MySQL Deep Pagination Performance Issues

This article analyzes why large OFFSET values cause severe MySQL performance degradation and presents multiple optimization techniques—including range queries, subqueries, delayed joins, covering indexes, sharding, caching, and search engine integration—along with their advantages, limitations, and practical recommendations.

CachingIndexingMySQL
0 likes · 11 min read
How to Solve MySQL Deep Pagination Performance Issues
Lin is Dream
Lin is Dream
May 8, 2025 · Backend Development

Boost Large-Scale Excel Exports in Java with a Multi-Threaded EasyExcel Template

This article introduces a reusable Java template that leverages EasyExcel v3.3.2 to efficiently export massive backend datasets—such as orders or financial records—to Excel, supporting both multi‑threaded and synchronous modes, pagination, sheet splitting, and customizable query logic, thereby reducing repetitive code and improving performance.

EasyExcelExcel Exportjava
0 likes · 11 min read
Boost Large-Scale Excel Exports in Java with a Multi-Threaded EasyExcel Template
Java Captain
Java Captain
Apr 27, 2025 · Backend Development

Parallel Pagination Query Interceptor for MyBatis-Plus in Spring Boot

This article explains how to implement a custom MyBatis-Plus pagination interceptor that parallelizes COUNT and data queries using CompletableFuture and a configurable thread pool in Spring Boot, suitable for large single-table and complex multi-table pagination scenarios, and provides detailed configuration and code examples.

MyBatis-PlusParallel QuerySpring Boot
0 likes · 13 min read
Parallel Pagination Query Interceptor for MyBatis-Plus in Spring Boot
Selected Java Interview Questions
Selected Java Interview Questions
Apr 10, 2025 · Backend Development

Understanding PageHelper Issues and ThreadLocal Pitfalls in MyBatis

This article analyzes unexpected behaviors caused by PageHelper in a Java backend project, such as duplicate user registration, limited query results, and password‑reset errors, and explains how ThreadLocal pagination parameters, startPage(), and cleanup mechanisms lead to these problems while offering practical debugging tips.

BackendSQLThreadLocal
0 likes · 11 min read
Understanding PageHelper Issues and ThreadLocal Pitfalls in MyBatis
Java Backend Full-Stack
Java Backend Full-Stack
Mar 27, 2025 · Databases

Hands‑On Sharding: Implementing Database and Table Partitioning with Spring Boot and Sharding‑JDBC

This article walks through a complete sharding implementation that splits a user table across four MySQL databases and sixteen tables, discusses challenges such as distributed IDs, transactions, data migration and pagination, and provides full Spring Boot, Sharding‑JDBC, Elasticsearch and Redis configurations with code examples.

ElasticsearchMySQLRedis
0 likes · 10 min read
Hands‑On Sharding: Implementing Database and Table Partitioning with Spring Boot and Sharding‑JDBC
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Mar 26, 2025 · Backend Development

Solving Marketing Activity Product Search with Elasticsearch: When to Use Join

The article examines why front‑end product search fails during large marketing events, evaluates Elasticsearch's join feature and its drawbacks, compares nested, reverse‑modeling and flattened approaches, recommends reverse modeling for massive activity‑product data, and provides concrete DSL code, pagination and caching tips.

ElasticsearchJOINdata modeling
0 likes · 10 min read
Solving Marketing Activity Product Search with Elasticsearch: When to Use Join
dbaplus Community
dbaplus Community
Mar 12, 2025 · Databases

Why Does LIMIT Pagination Slow Down? Deep Dive and Optimizations

This article reproduces a slow‑query scenario caused by deep pagination with LIMIT, explains the underlying index mechanics, and presents several practical SQL techniques—subquery, INNER JOIN, and anchor‑record methods—to dramatically reduce execution time.

Back-tableINNER JOINIndex Optimization
0 likes · 11 min read
Why Does LIMIT Pagination Slow Down? Deep Dive and Optimizations
Architect's Guide
Architect's Guide
Mar 6, 2025 · Databases

Common Practices for Database Sharding and Pagination Optimization

This article explains typical sharding strategies—hash, range, and middle‑table—describes SDK, Proxy, and Sidecar middleware forms, and presents several pagination optimization techniques such as global query rewriting, average pagination, disabling cross‑page queries, secondary queries, and using intermediate tables to improve performance in distributed databases.

SQLdatabasepagination
0 likes · 17 min read
Common Practices for Database Sharding and Pagination Optimization
Programmer XiaoFu
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
php Courses
php Courses
Jan 16, 2025 · Backend Development

Using PHP's array_slice() Function: Syntax, Parameters, and Practical Examples

This tutorial explains PHP's array_slice() function, covering its syntax, parameters, and practical examples—including extracting specific elements, preserving keys, and using it for pagination—while highlighting that it returns a new array without altering the original.

Backendarray manipulationarray_slice
0 likes · 5 min read
Using PHP's array_slice() Function: Syntax, Parameters, and Practical Examples