BestHub
Sign in
Tag

Database Optimization

1 views collected around this technical thread.

php中文网 Courses
php中文网 Courses
May 29, 2025 · Backend Development

6 Practical PHP Performance Optimization Techniques

This article outlines six practical PHP performance optimization techniques—including opcode caching, database query tuning, reducing redundant calculations, choosing efficient data structures, employing lazy loading, and leveraging built‑in functions—to help developers significantly improve the speed and scalability of their backend applications.

Database OptimizationOpCachePHP
0 likes · 5 min read
6 Practical PHP Performance Optimization Techniques
Selected Java Interview Questions
Selected Java Interview Questions
May 20, 2025 · Databases

Understanding Index Condition Pushdown (ICP) in MySQL: Theory, Usage, and Performance Comparison

Index Condition Pushdown (ICP) is a MySQL 5.6 feature that pushes part of WHERE filtering to the storage engine, reducing row reads and I/O; this article explains its principles, activation, usage examples, performance testing, and conditions under which ICP can be applied.

Database OptimizationICPIndex Condition Pushdown
0 likes · 10 min read
Understanding Index Condition Pushdown (ICP) in MySQL: Theory, Usage, and Performance Comparison
Aikesheng Open Source Community
Aikesheng Open Source Community
May 13, 2025 · Databases

Visualizing MySQL Execution Plans with Flame Graphs

This article explains how to use Flame Graphs to visualize MySQL execution plans, discusses the limitations of traditional EXPLAIN output, introduces the EXPLAIN ANALYZE feature in MySQL 8.0, provides sample SQL and command‑line usage, and shows how the visual tool helps quickly identify performance bottlenecks.

Database OptimizationExplain AnalyzeFlame Graph
0 likes · 11 min read
Visualizing MySQL Execution Plans with Flame Graphs
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 1, 2025 · Databases

Common Scenarios Where MySQL Indexes Fail

This article explains various situations that cause MySQL indexes to become ineffective—such as leading wildcard LIKE queries, calculations on indexed columns, use of functions, data type mismatches, improper use of composite indexes, and character set differences—providing example SQL, execution plans, and practical testing steps.

Database OptimizationMySQLPerformance Tuning
0 likes · 7 min read
Common Scenarios Where MySQL Indexes Fail
Cognitive Technology Team
Cognitive Technology Team
May 1, 2025 · Databases

MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios

This article systematically examines MySQL optimization techniques for both read‑many/write‑few and write‑many/read‑few business scenarios, covering architecture design, caching, sharding, asynchronous processing, monitoring, and emerging NewSQL/HTAP solutions to achieve high performance, consistency, and scalability.

Database OptimizationMySQLPerformance Tuning
0 likes · 9 min read
MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios
JD Tech Talk
JD Tech Talk
Apr 21, 2025 · Databases

Optimizing Supply Chain Planning Systems: ClickHouse ReplacingMergeTree and Local Join Solutions

This article discusses solutions to system bottlenecks in supply chain planning business development, focusing on ClickHouse ReplacingMergeTree table creation, local join optimization, and real-time data synchronization between TiDB and ClickHouse to improve query performance and system stability.

ClickHouseData SynchronizationDatabase Optimization
0 likes · 10 min read
Optimizing Supply Chain Planning Systems: ClickHouse ReplacingMergeTree and Local Join Solutions
Code Ape Tech Column
Code Ape Tech Column
Apr 10, 2025 · Databases

Comprehensive Guide to SQL Optimization Steps and Common Scenarios

This article explains why SQL statements become performance bottlenecks as data grows, outlines a systematic optimization workflow—including slow‑query identification, EXPLAIN analysis, profiling, and tracing—and discusses practical solutions for index usage, query rewriting, pagination, range queries, and large‑scale data handling in MySQL.

Database OptimizationEXPLAINIndexes
0 likes · 12 min read
Comprehensive Guide to SQL Optimization Steps and Common Scenarios
Architect
Architect
Apr 9, 2025 · Backend Development

Merging Requests and Batch Querying in Spring Boot to Reduce Database Connections

This article explains how to merge concurrent user requests into a single batch SQL query using Java's LinkedBlockingQueue, ScheduledThreadPoolExecutor and CompletableFuture in a Spring Boot application, thereby saving database connections and improving performance under high concurrency.

Database OptimizationJava ConcurrencySpring Boot
0 likes · 13 min read
Merging Requests and Batch Querying in Spring Boot to Reduce Database Connections
Java Captain
Java Captain
Apr 4, 2025 · Backend Development

High Concurrency: Principles, Impacts, and Practical Solutions for Backend Systems

This comprehensive guide explains the nature of high concurrency, distinguishes it from parallelism, outlines its potential consequences across application, database, and service layers, and presents a systematic set of mitigation strategies—including rate limiting, asynchronous processing, redundancy, caching, and queue‑based designs—supported by real‑world case studies and code examples.

Database OptimizationRate LimitingRedis
0 likes · 27 min read
High Concurrency: Principles, Impacts, and Practical Solutions for Backend Systems
Sohu Tech Products
Sohu Tech Products
Mar 19, 2025 · Databases

Redis Vector Search Technology for AI Applications: Implementation and Best Practices

The article explains how Redis vector search, powered by RedisSearch’s FLAT and HNSW algorithms and supporting various data types and precisions, enables fast AI-driven similarity queries for text, image, and audio, and provides implementation guidance, optimization tips, and a real‑world customer‑service use case.

AI applicationsDatabase OptimizationHNSW
0 likes · 17 min read
Redis Vector Search Technology for AI Applications: Implementation and Best Practices
Selected Java Interview Questions
Selected Java Interview Questions
Mar 7, 2025 · Backend Development

12 MyBatis‑Plus Optimization Tips for Efficient Database Operations

This article presents twelve practical MyBatis‑Plus optimization techniques—including avoiding isNull checks, specifying select fields, batch operations, using exists subqueries, safe ordering, lambda queries, enum mapping, logical deletion, optimistic locking, and increment/decrement methods—to improve code readability, performance, and maintainability in Java backend development.

Database OptimizationJavaMyBatisPlus
0 likes · 16 min read
12 MyBatis‑Plus Optimization Tips for Efficient Database Operations
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jan 29, 2025 · Backend Development

Mastering MyBatisPlus: 12 Practical Tips to Unlock New Knowledge

This article presents twelve practical MyBatisPlus optimization techniques—including avoiding isNull, specifying select fields, batch operations, using EXISTS, safe ordering, LambdaQuery, between, index‑aware sorting, pagination, null‑handling, performance tracking, enum mapping, logical deletion, and optimistic locking—to help Java developers write cleaner, more efficient backend code.

Database OptimizationJavaMyBatisPlus
0 likes · 14 min read
Mastering MyBatisPlus: 12 Practical Tips to Unlock New Knowledge
Architect
Architect
Jan 26, 2025 · Databases

Optimizing Redis Cluster Slot Migration to Reduce Latency and Improve High Availability

This article analyzes the latency and availability problems of native Redis cluster slot migration, proposes a master‑slave synchronization based redesign that batches slot transfers, reduces ask‑move and topology‑change overhead, and validates the solution with performance tests showing smoother latency and higher reliability.

ClusterDatabase OptimizationHigh Availability
0 likes · 16 min read
Optimizing Redis Cluster Slot Migration to Reduce Latency and Improve High Availability
Selected Java Interview Questions
Selected Java Interview Questions
Jan 19, 2025 · Databases

Understanding MySQL Covering Indexes, Table Lookups, and the Leftmost Prefix Rule

This article explains MySQL covering indexes, how table lookups (back‑table operations) work, and the leftmost prefix rule for composite indexes, providing practical examples and tips for optimizing query performance in interview scenarios.

Back TableDatabase OptimizationIndexing
0 likes · 8 min read
Understanding MySQL Covering Indexes, Table Lookups, and the Leftmost Prefix Rule
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jan 8, 2025 · Backend Development

Eight High‑Performance Architecture Solutions for Large‑Scale Systems

This article outlines eight essential high‑performance architecture techniques—including load balancing, asynchronous processing, database optimization, caching, distributed clusters, CDN, microservices, and rate‑limiting/circuit‑breaking—to improve scalability, availability, and responsiveness of large‑scale backend systems.

Database OptimizationLoad BalancingMicroservices
0 likes · 9 min read
Eight High‑Performance Architecture Solutions for Large‑Scale Systems
JD Tech
JD Tech
Dec 26, 2024 · Databases

Optimizing Query Performance for JD's BIP Procurement System with JED, JimKV, and Elasticsearch

This article details how JD's BIP procurement system tackled massive query‑performance challenges by segmenting order data, leveraging the JED distributed MySQL solution, introducing JimKV for hot‑data caching, and offloading complex searches to Elasticsearch, resulting in dramatically reduced load and faster user experiences.

Database OptimizationDistributed StorageJD.com
0 likes · 11 min read
Optimizing Query Performance for JD's BIP Procurement System with JED, JimKV, and Elasticsearch
Efficient Ops
Efficient Ops
Dec 24, 2024 · Databases

Why Is My Redis Slowing Down? 10 Common Causes and How to Fix Them

Redis can appear slow for many reasons—including baseline latency differences, high‑complexity commands, big keys, concentrated expirations, memory limits, fork overhead, huge pages, CPU binding, swap usage, memory fragmentation, and AOF configuration—so this guide explains each cause, how to diagnose it, and practical optimization steps.

Database OptimizationMemory ManagementPerformance Tuning
0 likes · 34 min read
Why Is My Redis Slowing Down? 10 Common Causes and How to Fix Them
Architect
Architect
Dec 24, 2024 · Backend Development

12 MyBatisPlus Optimization Techniques for Efficient Database Operations

This article presents twelve practical MyBatisPlus optimization techniques—including avoiding isNull checks, specifying select fields, batch operations, using EXISTS, safe ordering, LambdaQuery, between, index-aware sorting, pagination, null handling, performance tracking, enum mapping, logical deletion, optimistic locking, and increment/decrement—to write cleaner, faster, and more maintainable backend code.

Database OptimizationJavaMyBatisPlus
0 likes · 16 min read
12 MyBatisPlus Optimization Techniques for Efficient Database Operations