BestHub
Sign in
Tag

SQL indexing

1 views collected around this technical thread.

Java Tech Enthusiast
Java Tech Enthusiast
Jun 7, 2025 · Databases

How to Optimize Multi-Table Joins in MySQL: Practical Strategies

This article explains why excessive MySQL joins can cause performance problems and provides a comprehensive set of techniques—including query splitting, temporary tables, denormalization, index tuning, query rewriting, result‑set reduction, configuration tweaks, big‑data tools, and summary tables—to effectively optimize multi‑table join queries.

Join OptimizationMySQLSQL indexing
0 likes · 10 min read
How to Optimize Multi-Table Joins in MySQL: Practical Strategies
macrozheng
macrozheng
Mar 28, 2025 · Backend Development

Boost API Performance: 12 Proven Backend Optimization Techniques

This article presents a comprehensive set of backend optimization strategies—including batch processing, asynchronous execution, caching, pre‑processing, pooling, parallelism, indexing, transaction management, program refactoring, pagination, SQL tuning, and fine‑grained locking—to dramatically reduce API latency and improve system efficiency.

API optimizationCachingSQL indexing
0 likes · 10 min read
Boost API Performance: 12 Proven Backend Optimization Techniques
Architecture Digest
Architecture Digest
Apr 26, 2023 · Backend Development

Common API Performance Optimization Strategies

This article outlines a comprehensive set of backend API performance optimization techniques—including batch processing, asynchronous execution, caching, pre‑processing, pooling, parallelization, indexing, transaction handling, SQL tuning, and lock granularity—to reduce latency and improve system efficiency.

API performanceAsynchronous ExecutionCaching
0 likes · 9 min read
Common API Performance Optimization Strategies