BestHub
Sign in
Tagged articles
14 articles
Page 1 of 1
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
Architect's Tech Stack
Architect's Tech Stack
Nov 14, 2025 · Databases

8 MySQL Optimizations to Slash Query Times from Seconds to Milliseconds

This article presents eight practical MySQL performance‑tuning techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting updates and deletes with JOIN, handling mixed ordering, replacing EXISTS with JOIN, pushing conditions down, early range reduction, and using WITH clauses—to transform slow queries into millisecond‑level executions.

Query RewriteSQL Optimizationindexes
0 likes · 14 min read
8 MySQL Optimizations to Slash Query Times from Seconds to Milliseconds
macrozheng
macrozheng
Aug 7, 2025 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT clauses and implicit type conversions to suboptimal JOIN updates, mixed sorting, EXISTS usage, condition pushdown, early result limiting, and intermediate result set handling—offering rewritten queries and execution plan analyses that dramatically improve execution times.

Database IndexesQuery RewriteSQL Optimization
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Jul 3, 2024 · Databases

How WeTune 2.0 Automates SQL Query Rewrite for GaussDB Performance Boost

WeTune 2.0, a revolutionary tool developed by Shanghai Jiao Tong University and GaussDB experts, automatically discovers and validates SQL rewrite rules, dramatically improving query performance in Huawei Cloud GaussDB by eliminating manual rule creation, supporting extensive rule enumeration, equivalence verification, and cost‑based evaluation, while addressing scalability challenges.

GaussDBQuery RewriteSQL Optimization
0 likes · 11 min read
How WeTune 2.0 Automates SQL Query Rewrite for GaussDB Performance Boost
Liangxu Linux
Liangxu Linux
Apr 14, 2024 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article presents eight practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting joins, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, pre‑filtering data, and using WITH clauses—to dramatically reduce query execution time.

Query RewriteSQL Optimizationindexes
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
Java Backend Technology
Java Backend Technology
Feb 20, 2024 · Databases

7 Proven MySQL Query Optimizations to Slash Execution Time

This article examines common MySQL performance pitfalls—such as large OFFSET limits, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, and condition push‑down—and demonstrates concise rewrites, including JOINs, UNION ALL, early range reduction, and WITH clauses that can reduce query execution from seconds to milliseconds.

Query RewriteSQL Optimizationmysql
0 likes · 13 min read
7 Proven MySQL Query Optimizations to Slash Execution Time
Laravel Tech Community
Laravel Tech Community
Aug 28, 2023 · Databases

Common MySQL Performance Issues and Their Optimization Techniques

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, and intermediate result handling, and provides concrete SQL rewrites and execution‑plan analyses to dramatically improve query speed.

Performance OptimizationQuery RewriteSQL
0 likes · 13 min read
Common MySQL Performance Issues and Their Optimization Techniques
StarRocks
StarRocks
Nov 15, 2022 · Databases

How StarRocks 2.5 Improves Materialized Views for Real‑Time and Offline Queries

This article analyzes the requirements, design choices, and implementation details of materialized views in StarRocks, covering demand analysis, synchronous and asynchronous refresh solutions, partition binding, task scheduling, partition‑refresh maintenance, Insert‑Overwrite mechanics, view invalidation handling, and the upcoming features planned for version 2.5.

Async RefreshInsert OverwriteQuery Rewrite
0 likes · 14 min read
How StarRocks 2.5 Improves Materialized Views for Real‑Time and Offline Queries
Liangxu Linux
Liangxu Linux
Jul 28, 2022 · Databases

Why Your MySQL Queries Are Slow and How to Fix Common Mistakes

This article examines frequent MySQL performance pitfalls—such as misuse of LIMIT, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, and condition push‑down failures—and demonstrates how rewriting queries with proper indexes, JOINs, early range reduction, and WITH statements can dramatically reduce execution time.

Index UsageQuery RewriteSQL Optimization
0 likes · 15 min read
Why Your MySQL Queries Are Slow and How to Fix Common Mistakes
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 15, 2020 · Databases

Using MySQL 8.0 Statement Digest and Digest Text Functions for SQL Summarization

The article explains MySQL 8.0's new statement_digest() and statement_digest_text() functions, showing how they generate normalized SQL texts and SHA2 hashes to group similar queries, and demonstrates practical applications in performance schema analysis and query‑rewrite plugins with concrete code examples.

Database OptimizationQuery RewriteSQL Performance
0 likes · 8 min read
Using MySQL 8.0 Statement Digest and Digest Text Functions for SQL Summarization
ITPUB
ITPUB
Jul 31, 2019 · Databases

8 MySQL Query Optimizations to Slash Execution Time

This article presents practical MySQL performance tricks—including smarter LIMIT usage, avoiding implicit type conversion, rewriting UPDATE/DELETE with JOIN, handling mixed ordering, replacing EXISTS with JOIN, pushing down conditions, narrowing result sets early, and leveraging WITH clauses—to dramatically reduce query execution times.

Query RewriteSQL Optimizationdatabase
0 likes · 14 min read
8 MySQL Query Optimizations to Slash Execution Time
Architecture Digest
Architecture Digest
Apr 2, 2017 · Artificial Intelligence

Mogujie's Search System Architecture and Online Request Flow

This article introduces Mogujie's end‑to‑end search system architecture, detailing its online and offline components such as Topn, ABTest, QR, fine‑ranking, search engine, UPS, and feature platforms, and then walks through a real‑world online request example to illustrate how queries are processed, rewritten, personalized, and finally ranked.

MogujieQuery RewriteSearch Architecture
0 likes · 11 min read
Mogujie's Search System Architecture and Online Request Flow