BestHub
Sign in
Tagged articles
311 articles
Page 1 of 4
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.

BatchInsertEnumMappingJava
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 MappingJava
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 MappingJava
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.

CursorJavaLarge Data
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.

Golangcursor paginationmysql
0 likes · 30 min read
Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It
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.

CursorElasticsearchSQL
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.

SQLinterviewpagination
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.

BackendJavaMyBatis
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.

JavaMyBatisThreadLocal
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.

JOINQuery RewriteSQL Optimization
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.

AsyncJavaeasyexcel
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.

JavaScriptdompdf.jsencryption
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.

Error HandlingHTTPURL Modeling
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.

LIMITSQLlarge datasets
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.

Big DataClickHouseElasticsearch
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 CalculationJavaScriptWeb Development
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.

Database OptimizationElasticsearchSharding-JDBC
0 likes · 13 min read
When Sharding Fails: Debugging Pagination Bugs and Optimizing MySQL for Massive Tables
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 ScrollingStream API
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 MappingLogical Delete
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.

HashSorted 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.

OFFSET LIMITdeterministic orderingmysql
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.

CRUDCode GenerationJava
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.

Database OptimizationKeyset PaginationPostgreSQL
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 DevelopmentCRUDJava
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.

CRUDControllerJava
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.

Elasticsearchdatabasemysql
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.

BackendJavaMicroservices
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.

CacheData FetchingOptimistic Update
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.

CRUDJavaMulti-DataSource
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.

BaseControllerCRUDJava
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.

HashSorted 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.

BackendJavaSpringBoot
0 likes · 6 min read
How @PageableDefault Simplifies SpringBoot Pagination
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.

Database Optimizationcachingindexing
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.

Javaeasyexcelexcel-export
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.

JavaParallel 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.

BackendMyBatisSQL
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.

ElasticsearchSharding-JDBCSpring Boot
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
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
Su San Talks Tech
Su San Talks Tech
Jan 7, 2025 · Databases

7 Common Pitfalls of Database Sharding and How to Solve Them

This article examines seven typical challenges that arise after implementing database sharding—such as global ID conflicts, cross‑shard queries, distributed transactions, shard‑key design, data migration, pagination, and operational overhead—and provides practical solutions and code examples to address each issue.

Distributed SystemsID generationdatabase scaling
0 likes · 12 min read
7 Common Pitfalls of Database Sharding and How to Solve Them
Top Architect
Top Architect
Dec 20, 2024 · Databases

Database Optimization, Sharding, and Pagination Issues: Lessons from a Large‑Scale MySQL Deployment

The article shares a senior architect’s experience with large‑scale MySQL tables, discussing why sharding and Elasticsearch were introduced, the pagination bug caused by Sharding‑JDBC, and a comprehensive set of hardware, software, and SQL tuning recommendations, including a full MySQL configuration example.

Elasticsearchmysqloptimization
0 likes · 14 min read
Database Optimization, Sharding, and Pagination Issues: Lessons from a Large‑Scale MySQL Deployment
Architect
Architect
Dec 16, 2024 · Backend Development

How to Build a Scalable Feed Stream: Architecture, Models, and Best Practices

This article explains what a feed stream is, why it exists, how it evolved from RSS to modern social feeds, classifies different feed models, outlines the challenges of real‑time delivery, and provides a detailed backend architecture, data structures, storage design, pagination strategy, and core publish‑read workflows to help engineers build reliable, high‑performance feed systems.

Backend ArchitectureMessage QueueRead‑Write Diffusion
0 likes · 23 min read
How to Build a Scalable Feed Stream: Architecture, Models, and Best Practices
macrozheng
macrozheng
Dec 4, 2024 · Databases

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

This article examines how pagination queries on large MySQL tables become dramatically slower as the offset grows, presents real‑world performance measurements, and offers three practical optimization strategies—including selecting only primary keys, range‑based filtering, and using ElasticSearch—to keep query latency low.

BackendDatabase OptimizationSQL
0 likes · 10 min read
Why MySQL Pagination Slows Down at Scale and How to Speed It Up
Goodme Frontend Team
Goodme Frontend Team
Dec 2, 2024 · Frontend Development

How to Generate Paginated PDFs from HTML with html2canvas and jsPDF

This article explains how to convert HTML content—including text, images, and tables—into PDF files using html2canvas and jsPDF, and details a dynamic pagination technique to prevent content truncation across pages, while also covering performance and export considerations.

JavaScriptfrontendhtml2canvas
0 likes · 19 min read
How to Generate Paginated PDFs from HTML with html2canvas and jsPDF
High Availability Architecture
High Availability Architecture
Nov 22, 2024 · Backend Development

Designing a High‑Availability, Scalable Feed Stream System

This article introduces feed streams, explains their evolution from RSS to modern social feeds, classifies them by aggregation logic and display, discusses challenges such as real‑time performance and massive data, and presents a backend architecture with data models, pagination, write/read diffusion, and core publishing/reading workflows.

Backend ArchitectureScalabilitydata modeling
0 likes · 21 min read
Designing a High‑Availability, Scalable Feed Stream System
Tencent Cloud Developer
Tencent Cloud Developer
Nov 21, 2024 · Backend Development

Design and Architecture of Feed Stream Systems

The article surveys feed‑stream systems—from their RSS roots to modern social‑media timelines—explaining classifications, core terminology, and a high‑performance architecture that uses Redis ZSET inboxes, write‑ and read‑diffusion, soft‑delete consistency, and last‑id pagination to handle massive real‑time writes, big‑V fan‑out, and efficient publishing and reading.

Message Queuefeed streampagination
0 likes · 21 min read
Design and Architecture of Feed Stream Systems
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 MergingJavaconcurrency
0 likes · 16 min read
Optimizing Excel Export with EasyExcel: Performance, Pagination, Concurrency, and Cell‑Merging Strategies
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.

BackendSQLpagination
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.

BackendMongoDBcaching
0 likes · 36 min read
Tencent Meeting "My Recordings" List Optimization Practice
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.

Large TablesSQL Optimizationdata deletion
0 likes · 8 min read
How to Efficiently Delete Massive MySQL Logs While Preserving Critical Types
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.

Database Optimizationdata cleanuplarge table deletion
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.

BinlogFull Table UpdatePerformance Optimization
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.

SQLdatabasemysql
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.

BackendDesign PatternsJava
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.

BackendJavaMyBatis
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.

CursorLIMITOFFSET
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.

CTEJoinsindexing
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.

BackendJavaThreadPool
0 likes · 6 min read
Multithreaded Pagination Query with Java ThreadPoolExecutor: Principles, Parameters, and Usage