Tagged articles

SQL pagination

3 articles · Page 1 of 1

Nov 22, 2025 · Databases

Why ShardingJDBC Can Be a Trap: Rethinking Sharding‑Based Database Optimization

The article recounts a real‑world case where using ShardingJDBC, Elasticsearch and Logstash dramatically increased system complexity and caused a pagination bug, then walks through hardware, software and SQL‑level optimization techniques and suggests more balanced alternatives to blind sharding.

ElasticsearchLogstashMySQL

0 likes · 12 min read

Why ShardingJDBC Can Be a Trap: Rethinking Sharding‑Based Database Optimization

Architect's Tech Stack

Mar 17, 2025 · Backend Development

Comprehensive Interface Performance Optimization Strategies

This article presents a systematic guide to improving API response times by applying batch processing, asynchronous execution, caching, pooling, parallelism, indexing, transaction management, pagination, SQL tuning, and proper lock granularity, supplemented with practical Java code examples and diagrams.

AsynchronousBatch ProcessingLock Granularity

0 likes · 10 min read

Comprehensive Interface Performance Optimization Strategies

政采云技术

Nov 8, 2023 · Databases

Understanding MySQL ORDER BY and LIMIT: Execution Principles, Sorting Algorithms, and Pagination Optimization

This article provides a comprehensive technical analysis of how MySQL processes ORDER BY and LIMIT clauses during pagination queries, detailing index utilization, filesort mechanisms, memory-based sorting algorithms, and practical optimization strategies for resolving deep pagination performance bottlenecks.

Filesort AlgorithmMySQLQuery Performance Tuning

0 likes · 11 min read

Understanding MySQL ORDER BY and LIMIT: Execution Principles, Sorting Algorithms, and Pagination Optimization