BestHub
Sign in
Tagged articles
1036 articles
Page 4 of 11
Code Ape Tech Column
Code Ape Tech Column
Dec 18, 2023 · Databases

13 Redis Performance Optimization Rules for High‑Throughput Applications

This article presents thirteen practical Redis performance‑optimization rules, covering avoidance of slow commands, proper key expiration handling, data‑structure selection, persistence tuning, hardware considerations, pipeline usage, client‑side improvements, and distributed architectures such as replication, sentinel and Redis Cluster, to help developers achieve significant speed gains.

databaseoptimizationperformance
0 likes · 13 min read
13 Redis Performance Optimization Rules for High‑Throughput Applications
php Courses
php Courses
Dec 14, 2023 · Backend Development

Optimizing PHP Performance with Faster Built-in Functions

This article explains how to boost PHP web application performance by replacing inefficient built-in functions such as count(), array_search(), preg_replace(), and mysqli_fetch_array() with faster alternatives like strlen(), in_array(), str_replace(), and mysqli_fetch_assoc(), and demonstrates memory release using unset() through clear code examples.

PHPoptimization
0 likes · 6 min read
Optimizing PHP Performance with Faster Built-in Functions
dbaplus Community
dbaplus Community
Dec 12, 2023 · Databases

Why Does MySQL Replication Lag? Causes and Practical Fixes

This article explains the fundamentals of MySQL master‑slave replication, identifies why replication lag occurs—including single‑threaded processing, lock contention, network issues, and outdated versions—and offers concrete strategies such as hardware upgrades, configuration tweaks, and architectural changes to minimize the delay.

Lagdatabasesmysql
0 likes · 7 min read
Why Does MySQL Replication Lag? Causes and Practical Fixes
Test Development Learning Exchange
Test Development Learning Exchange
Dec 12, 2023 · Fundamentals

Python Memory Management and Optimization Techniques

Python automatically manages memory through garbage collection, and this article explains how the garbage collector works and presents ten practical techniques—including manual gc calls, generators, sys.getsizeof, slice copying, del statements, sys.intern, NumPy, pandas, reference counting, and __slots__—to reduce memory usage and improve performance.

Garbage CollectionMemory ManagementPython
0 likes · 5 min read
Python Memory Management and Optimization Techniques
php Courses
php Courses
Dec 12, 2023 · Backend Development

Optimizing PHP Performance with Efficient Built-in Functions

This article explains how to improve PHP web application performance by replacing slower built‑in functions such as count(), array_search(), preg_replace(), and mysqli_fetch_array() with faster alternatives like strlen() with implode(), in_array(), str_replace(), and mysqli_fetch_assoc(), and also shows how to free memory using unset().

PHPbuilt-in functionsoptimization
0 likes · 6 min read
Optimizing PHP Performance with Efficient Built-in Functions
Alibaba Cloud Developer
Alibaba Cloud Developer
Dec 12, 2023 · Backend Development

Why GCC’s Loop Vectorization Crashed My Code and How to Fix It

A client‑reported segmentation fault was traced to changing GCC’s optimization level from -O2 to -O3, revealing a bug in the -ftree-loop-vectorize option that miscalculates struct sizes, and the article explains the analysis, assembly inspection, NEON details, and a practical workaround.

AssemblyDebuggingNEON
0 likes · 28 min read
Why GCC’s Loop Vectorization Crashed My Code and How to Fix It
Python Programming Learning Circle
Python Programming Learning Circle
Dec 11, 2023 · Fundamentals

Six Techniques to Improve Python Code Performance

This article introduces six practical techniques—including profiling with timeit, memory and line profilers, using built‑in functions, f‑strings, list comprehensions, and lru_cache—as well as algorithm and data‑structure choices to help Python developers significantly boost the execution speed of their code.

Profilingbest-practicescode
0 likes · 9 min read
Six Techniques to Improve Python Code Performance
Java Architect Essentials
Java Architect Essentials
Dec 10, 2023 · Fundamentals

Common For‑Loop Optimizations in Java

This article presents more than ten practical techniques for writing faster, cleaner Java for‑loops, covering basic size caching, reverse iteration, iterator usage, enhanced for‑loops, nested loop reduction, exception handling placement, and method‑call minimization to improve overall program performance.

Javacoding best practicesfor loop
0 likes · 8 min read
Common For‑Loop Optimizations in Java
OPPO Kernel Craftsman
OPPO Kernel Craftsman
Dec 8, 2023 · Mobile Development

Android Audio Smoothness: Performance Analysis and Optimization Guide

This guide helps Android audio developers understand and eliminate stutter, pop noise, and other glitches by examining audio formats, pipeline components, CPU scheduling, common failure cases, and offering concrete optimization steps such as proper thread priorities, reduced API blocking, and efficient frame‑count configuration.

AndroidSchedulingaudio
0 likes · 18 min read
Android Audio Smoothness: Performance Analysis and Optimization Guide
JD Retail Technology
JD Retail Technology
Nov 30, 2023 · Frontend Development

Front‑End Performance Optimization: Understanding Browser Rendering, Web Vitals, and Practical Solutions

This article examines front‑end performance issues such as page freeze caused by heavy JavaScript computation, explains browser rendering threads, processes, and key Web Vitals (LCP, FID, CLS), and provides practical optimization techniques including code splitting, Web Workers, CDN usage, and build‑time configurations.

Web Workeroptimizationweb-vitals
0 likes · 26 min read
Front‑End Performance Optimization: Understanding Browser Rendering, Web Vitals, and Practical Solutions
Architect
Architect
Nov 27, 2023 · Backend Development

Why 500 req/s Became 50 req/s: A Deep Dive into Spring Bean Creation Bottlenecks

A ToB system that seemed able to handle 500 requests per second stalled at 50 req/s due to hidden lock contention in prototype‑scoped Spring beans, slow SQL updates, excessive logging, and thread‑pool misconfiguration, prompting a step‑by‑step performance investigation and multiple optimizations.

JavaLoad TestingSQL
0 likes · 16 min read
Why 500 req/s Became 50 req/s: A Deep Dive into Spring Bean Creation Bottlenecks
MaGe Linux Operations
MaGe Linux Operations
Nov 27, 2023 · Databases

Why Does MySQL Master‑Slave Replication Lag? Causes and Fixes

This article explains why MySQL master‑slave replication can become delayed, outlines the differences between DDL and DML, shows how to diagnose lag with show slave status, and provides architectural, hardware, and configuration solutions—including semi‑synchronous replication and tuning parameters—to reduce latency.

Master‑SlaveReplicationdatabase
0 likes · 9 min read
Why Does MySQL Master‑Slave Replication Lag? Causes and Fixes
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 27, 2023 · Backend Development

Boost Java Logging Performance: Practical Tips and Configurations

This article explores Java logging performance by analyzing the logging pipeline, presenting measurements of log size impact, and offering concrete optimization techniques such as reducing log payload, compressing logger and exception output, using asynchronous logging, and configuring rolling files to minimize both visible business overhead and hidden system costs.

AsyncJavalog4j2
0 likes · 20 min read
Boost Java Logging Performance: Practical Tips and Configurations
ITPUB
ITPUB
Nov 25, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Faster Queries

This article examines eight frequent MySQL performance problems—including misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS, condition push‑down, early limiting, and intermediate result push‑down—and provides concrete rewrite techniques and example code that dramatically reduce execution time.

LimitsSQLindexes
0 likes · 13 min read
8 Common SQL Pitfalls and How to Optimize Them for Faster Queries
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 24, 2023 · Operations

What Is an Optimization Solver? A Beginner’s Guide to Solving Real‑World Problems

This article explains what an optimization solver is, defines key terminology, walks through simple equation‑based examples like the chicken‑rabbit problem, expands to real‑world scenarios such as ad allocation and employee benefits, and outlines common solution methods and how to choose appropriate solvers.

Linear ProgrammingModelingOperations Research
0 likes · 17 min read
What Is an Optimization Solver? A Beginner’s Guide to Solving Real‑World Problems
Ctrip Technology
Ctrip Technology
Nov 23, 2023 · Big Data

Optimizing Data Warehouse Timeliness Using Metadata Lineage

This article presents a metadata‑driven approach to improve data warehouse timeliness by extracting upstream lineage, identifying over‑layered, duplicate, and critical‑path tasks, and applying targeted scheduling and code‑level optimizations, demonstrated with a hotel order wide‑table case study.

DAGData WarehouseLineage
0 likes · 7 min read
Optimizing Data Warehouse Timeliness Using Metadata Lineage
Efficient Ops
Efficient Ops
Nov 20, 2023 · Databases

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

This article explains why Redis may become slower, covering benchmark testing, high‑complexity commands, big keys, concentrated expirations, memory limits, fork overhead, huge pages, AOF settings, CPU binding, swap usage, memory fragmentation, and lazy‑free mechanisms, and provides practical optimization steps.

optimizationperformanceredis
0 likes · 34 min read
Why Is My Redis Slowing Down? 10 Common Causes and How to Fix Them
php Courses
php Courses
Nov 4, 2023 · Databases

Common Causes of MySQL Database Crashes and Their Solutions

This article outlines the typical reasons MySQL databases crash—such as hardware failures, software issues, external attacks, and poor design—and provides practical remedies including regular backups, using myisamchk for repair, leveraging binary logs, optimizing schemas, and upgrading to newer MySQL versions.

BackupDatabase CrashRepair
0 likes · 4 min read
Common Causes of MySQL Database Crashes and Their Solutions
Java Interview Crash Guide
Java Interview Crash Guide
Nov 1, 2023 · Backend Development

10+ Proven Ways to Supercharge Java for‑Loops for Faster Code

This article outlines over ten practical techniques for optimizing Java for‑loops, including caching list size, using reverse iteration, employing iterators, leveraging enhanced for‑each loops, minimizing method calls, and handling exceptions efficiently, helping developers write cleaner and more performant code.

best-practicescodingfor loop
0 likes · 7 min read
10+ Proven Ways to Supercharge Java for‑Loops for Faster Code
Beijing SF i-TECH City Technology Team
Beijing SF i-TECH City Technology Team
Oct 31, 2023 · Mobile Development

Performance Metrics and Optimization Strategies for WeChat Mini Programs

This article explains the startup process and lifecycle of WeChat mini programs, defines key performance measurement indicators such as launch time, first render time, and first screen load time, and provides detailed optimization techniques to address long startup, page load, and UI lag issues.

Mobile DevelopmentWeChat Mini Programoptimization
0 likes · 13 min read
Performance Metrics and Optimization Strategies for WeChat Mini Programs
JD Retail Technology
JD Retail Technology
Oct 31, 2023 · Databases

How to Identify and Eliminate Redis BigKey Bottlenecks

This article explains what constitutes a Redis BigKey, why oversized keys degrade performance through data skew, network blocking, slow queries and CPU pressure, and provides practical detection methods, open‑source tooling, and mitigation techniques such as lazy‑free deletion, incremental scans, and key sharding.

BigKeyDELETESCAN
0 likes · 21 min read
How to Identify and Eliminate Redis BigKey Bottlenecks
Architecture Digest
Architecture Digest
Oct 31, 2023 · Backend Development

Performance Troubleshooting and Optimization of a ToB System: From Low Throughput to Improved CPU Utilization

This article documents a step‑by‑step investigation of a Java Spring backend that initially achieved only 50 requests per second under load, detailing how slow SQL, excessive logging, thread‑pool misconfiguration, bean‑creation overhead and CPU‑bound operations were identified and mitigated to roughly double the throughput while reducing response latency.

JavaProfilingThroughput
0 likes · 14 min read
Performance Troubleshooting and Optimization of a ToB System: From Low Throughput to Improved CPU Utilization
DaTaobao Tech
DaTaobao Tech
Oct 30, 2023 · Frontend Development

Understanding and Improving Front-End User Experience

Front‑end developers should view user experience as a core responsibility, focusing on four objective pillars—stability (including code and UI consistency across devices), performance (first‑screen, runtime, and interface efficiency), visual style (smooth animations and feedback), and product scheme collaboration—to deliver reliable, fast, and engaging H5 pages while balancing short‑term gains with long‑term maintainability.

User experienceanimationoptimization
0 likes · 29 min read
Understanding and Improving Front-End User Experience
IT Services Circle
IT Services Circle
Oct 29, 2023 · Fundamentals

Maximum Sum Submatrix – Solution Using 2D Prefix Sum

This article explains the maximum‑sum submatrix problem, presents a brute‑force enumeration, introduces a 2‑dimensional prefix‑sum technique to compute submatrix sums in O(1), and provides a complete Python implementation with complexity analysis.

2D prefix sumPythonalgorithm
0 likes · 9 min read
Maximum Sum Submatrix – Solution Using 2D Prefix Sum
Selected Java Interview Questions
Selected Java Interview Questions
Oct 27, 2023 · Backend Development

Diagnosing and Optimizing Throughput and CPU Usage in a Java Spring Backend Service

The article details a step‑by‑step investigation of a Java Spring backend that initially achieved only 50 req/s under load, identifies bottlenecks such as slow SQL, excessive logging, thread‑pool misconfiguration and costly Spring bean creation, and demonstrates how targeted optimizations roughly doubled throughput while reducing response times.

CPUJavaProfiling
0 likes · 14 min read
Diagnosing and Optimizing Throughput and CPU Usage in a Java Spring Backend Service
Model Perspective
Model Perspective
Oct 26, 2023 · Fundamentals

Modeling Classic Afanti Tales: Donkey, Oil, and Meal Fee Puzzles

This article explores how mathematical modeling and graph‑theoretic methods can rigorously solve three classic Afanti folk stories—dividing donkeys, splitting oil, and a meal‑fee dispute—illustrating the power of formal models for everyday problem solving.

folk talesgraph theorymathematical modeling
0 likes · 15 min read
Modeling Classic Afanti Tales: Donkey, Oil, and Meal Fee Puzzles
php Courses
php Courses
Oct 16, 2023 · Backend Development

Techniques to Optimize PHP and MySQL Access Speed

This article presents practical methods—including indexing, query consolidation, field selection, PHP code refinements, and caching strategies with Redis and page caching—to significantly improve the performance of PHP‑MySQL applications, accompanied by concrete code examples.

PHPcachingdatabase
0 likes · 6 min read
Techniques to Optimize PHP and MySQL Access Speed
php Courses
php Courses
Oct 9, 2023 · Backend Development

Debugging and Optimizing Database Connections in PHP

This article explains how to debug and optimize PHP database connections using PDO and mysqli, demonstrates error handling and logging techniques, and presents performance improvements such as persistent connections, connection pooling, and query optimization with practical code examples.

Connection PoolDebuggingPDO
0 likes · 6 min read
Debugging and Optimizing Database Connections in PHP
DataFunTalk
DataFunTalk
Oct 8, 2023 · Big Data

Full-Process DataOps Practices for Large-Scale Business Data Reporting at Baidu

This article reveals how Baidu implements end‑to‑end DataOps for its commercial data products, covering challenges of massive report generation, the design of a layered data architecture, platform‑wide automation, serverless deployment, risk control, monitoring, and optimization to achieve scalable, reliable data pipelines.

Big DataDataOpsServerless
0 likes · 13 min read
Full-Process DataOps Practices for Large-Scale Business Data Reporting at Baidu
php Courses
php Courses
Oct 7, 2023 · Backend Development

PHP Performance Optimization Techniques and Functions

This article outlines key PHP performance optimization strategies—including caching with Memcache or Redis, using efficient database access via PDO, selecting optimal loop constructs like foreach and array_map, and avoiding redundant function calls—to improve execution speed and user experience.

LoopsPHPcaching
0 likes · 5 min read
PHP Performance Optimization Techniques and Functions
Liangxu Linux
Liangxu Linux
Oct 2, 2023 · Databases

Essential MySQL Optimization Tips: From EXPLAIN to Index Strategies

This guide presents a comprehensive set of MySQL performance‑tuning techniques—including proper use of EXPLAIN, limiting IN lists, selecting specific columns, avoiding costly ORDER BY RAND(), choosing UNION ALL over UNION, distinguishing IN from EXISTS, employing full‑text indexes, respecting left‑most prefix rules, and leveraging FORCE INDEX or STRAIGHT_JOIN—to help developers write faster, more efficient queries.

SQLindexingmysql
0 likes · 12 min read
Essential MySQL Optimization Tips: From EXPLAIN to Index Strategies
Model Perspective
Model Perspective
Sep 25, 2023 · Fundamentals

How Mathematical Modeling Turns Data into Money: From Finance to E‑Commerce

This article explores how mathematical modeling serves as a profit‑driving tool across finance, industry, e‑commerce and personal finance, explaining core concepts, classic models like Black‑Scholes, optimization techniques, recommendation algorithms, and practical formulas for individual wealth planning.

financeindustrial engineeringmathematical modeling
0 likes · 8 min read
How Mathematical Modeling Turns Data into Money: From Finance to E‑Commerce
php Courses
php Courses
Sep 22, 2023 · Frontend Development

19 Common JavaScript Performance Pitfalls and How to Avoid Them

This article identifies nineteen common performance pitfalls in JavaScript and Node.js applications—ranging from improper variable scope and inefficient DOM manipulation to blocking I/O, unoptimized loops, and excessive dependencies—providing illustrative code examples and actionable solutions to improve speed and responsiveness.

JavaScriptNode.jsbest practices
0 likes · 16 min read
19 Common JavaScript Performance Pitfalls and How to Avoid Them
Model Perspective
Model Perspective
Sep 21, 2023 · Fundamentals

Unlock the Jargon: Essential Terms Every Math Modeling Beginner Must Know

This comprehensive guide demystifies over one hundred core mathematical modeling terms—from basic concepts like models and abstraction to advanced topics such as optimization, dynamic systems, stochastic processes, statistical methods, and machine learning—helping newcomers confidently navigate the field.

machine learningmathematical modelingmodeling terminology
0 likes · 20 min read
Unlock the Jargon: Essential Terms Every Math Modeling Beginner Must Know
MaGe Linux Operations
MaGe Linux Operations
Sep 11, 2023 · Backend Development

How to Cut HttpClient Latency by 70% with Connection Pooling and Keep-Alive

By refactoring a high‑traffic Java service to use a singleton HttpClient, enable connection pooling with a custom keep‑alive strategy, and fine‑tune timeout and retry settings, the average request time dropped from 250 ms to about 80 ms, dramatically improving throughput and stability.

Connection PoolingHttpClientKeep-Alive
0 likes · 13 min read
How to Cut HttpClient Latency by 70% with Connection Pooling and Keep-Alive
Model Perspective
Model Perspective
Sep 8, 2023 · Operations

Optimizing Lake Sheep Farm Space and Boosting Annual Lamb Production

This article presents an operations‑research model for a Lake Sheep farm, detailing how to determine ram and ewe numbers, estimate annual lamb output, address space‑utilization gaps, and incorporate uncertainty through Monte‑Carlo simulation to devise flexible, loss‑minimizing production plans.

Monte Carlo simulationlivestock managementoptimization
0 likes · 14 min read
Optimizing Lake Sheep Farm Space and Boosting Annual Lamb Production
FunTester
FunTester
Sep 7, 2023 · Backend Development

Performance Best Practices and Java Performance Testing Guidelines

This article explains what performance best practices are, why they matter, and provides a comprehensive list of general and Java‑specific techniques—including code optimization, resource management, concurrency, caching, and JVM GC tuning—to help developers build faster, more reliable backend systems.

Javaoptimizationperformance
0 likes · 15 min read
Performance Best Practices and Java Performance Testing Guidelines
DataFunSummit
DataFunSummit
Sep 6, 2023 · Operations

Dispatch Decision in New Power Systems: From Mathematical Programming to Artificial Intelligence

This presentation by Prof. Li Zuyi of Zhejiang University reviews the evolution of power‑system dispatch from traditional mathematically‑based scheduling to modern challenges posed by high renewable penetration, discussing stochastic and robust optimization, SCUC/SCED methods, and emerging AI‑driven frameworks for feasible, efficient, and optimal decision making.

DispatchSCUCoptimization
0 likes · 23 min read
Dispatch Decision in New Power Systems: From Mathematical Programming to Artificial Intelligence
HomeTech
HomeTech
Sep 6, 2023 · Frontend Development

Performance Optimization and Element‑Embedding for Flutter Web (FFW)

This article analyzes the performance drawbacks of Flutter For Web's two rendering modes, presents practical optimization techniques for both HTML and CanvasKit renderers, introduces the new element‑embedding feature, and proposes a seamless AB‑switching solution to combine fast initial load with smooth interactive performance.

CanvasKitelement-embeddinghtml-renderer
0 likes · 12 min read
Performance Optimization and Element‑Embedding for Flutter Web (FFW)
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Aug 25, 2023 · Frontend Development

Optimizing a Web Frontend Workflow Engine: Reducing Load Time, Input Lag, and Memory Usage

This article details a systematic investigation and optimization of a web‑based workflow engine, addressing slow initial rendering, input lag in Element UI components, and excessive memory consumption that caused browser crashes, and presents concrete solutions such as data pruning, Object.freeze, lazy loading, and event cleanup.

frontendlazy loadingmemory leak
0 likes · 9 min read
Optimizing a Web Frontend Workflow Engine: Reducing Load Time, Input Lag, and Memory Usage
Zhengtong Technical Team
Zhengtong Technical Team
Aug 23, 2023 · Game Development

Enhancing Bloom Effect in WebGL: Implementation, Optimization, and Performance Comparison

This article explains why enhancing bloom (glow) effects is important for visual attention and scene aesthetics, outlines a generic WebGL implementation pipeline, discusses factors influencing bloom quality, and presents the Crystal WebGL engine's optimizations and performance comparisons between traditional and mipmap‑based approaches.

BloomGraphicsRendering
0 likes · 7 min read
Enhancing Bloom Effect in WebGL: Implementation, Optimization, and Performance Comparison
Python Programming Learning Circle
Python Programming Learning Circle
Aug 23, 2023 · Fundamentals

Python Code Optimization Techniques for Faster Execution

This article presents a comprehensive guide to accelerating Python code by applying optimization principles such as avoiding global variables, minimizing attribute access, eliminating unnecessary abstractions and data copies, leveraging built‑in functions like join, using loop optimizations, and employing tools like numba.jit, with concrete code examples and performance measurements.

best practicesoptimization
0 likes · 19 min read
Python Code Optimization Techniques for Faster Execution
Architect
Architect
Aug 21, 2023 · Backend Development

Java Performance Optimization Tips: 34 Best Practices for Faster, Cleaner Code

This article presents 34 practical Java performance optimization guidelines—ranging from proper use of singletons and static variables to avoiding excessive object creation, leveraging final modifiers, preferring primitives, minimizing synchronization, and employing efficient collections—to help developers write faster, more memory‑efficient code.

BackendJavabest practices
0 likes · 18 min read
Java Performance Optimization Tips: 34 Best Practices for Faster, Cleaner Code
Model Perspective
Model Perspective
Aug 17, 2023 · Artificial Intelligence

Can Math Build the Ultimate Pokémon Dream Team? A Data‑Driven Analysis

This article uses a Kaggle Pokémon dataset of 802 creatures to explore statistical correlations, build a random‑forest classifier for legendary status, assess type strengths, and apply optimization techniques—including integer linear programming, greedy selection, and simulated annealing—to propose an optimal six‑Pokémon dream team.

data analysismachine learningoptimization
0 likes · 23 min read
Can Math Build the Ultimate Pokémon Dream Team? A Data‑Driven Analysis
Architect's Guide
Architect's Guide
Aug 12, 2023 · Databases

Why Redis Becomes Slow and How to Optimize It

This article explains the common reasons why Redis performance degrades—such as network latency, high‑complexity commands, big keys, concentrated expirations, memory limits, fork overhead, huge pages, AOF settings, CPU binding, swap usage, and memory fragmentation—and provides detailed optimization and troubleshooting steps to restore low latency.

LatencyMemorydatabase
0 likes · 34 min read
Why Redis Becomes Slow and How to Optimize It
Tencent Database Technology
Tencent Database Technology
Aug 10, 2023 · Databases

Optimizing Buffer Pool Memory Management in TDSQL-C Serverless

This article explains the architecture of TDSQL-C Serverless buffer pool, details how InnoDB buffer pool resize works, analyzes performance bottlenecks such as IO and mutex contention, and presents optimization techniques like chunk pre‑allocation, delayed release, and hash‑resize improvements that make serverless scaling more stable.

Memory ManagementServerlessTDSQL-C
0 likes · 11 min read
Optimizing Buffer Pool Memory Management in TDSQL-C Serverless
php Courses
php Courses
Aug 3, 2023 · Backend Development

Common PHP Performance Optimization and Tuning Techniques

This article presents several practical PHP performance optimization methods—including caching, avoiding duplicate database queries, merging and compressing assets, using MySQL query cache, and efficient database operations—accompanied by clear code examples to help developers improve web application speed.

databaseoptimization
0 likes · 5 min read
Common PHP Performance Optimization and Tuning Techniques
DevOps
DevOps
Jul 28, 2023 · Operations

The Temporary End of Moore’s Law and the Revival of “Systems Performance”

The article discusses the renewed relevance of performance engineering amid the slowdown of Moore’s Law, highlighting the Chinese edition of "Systems Performance: Enterprise and the Cloud," modern observability tools like eBPF, the "golden 60‑second" analysis, and the push toward continuous performance monitoring and expert systems.

ObservabilitySystemseBPF
0 likes · 7 min read
The Temporary End of Moore’s Law and the Revival of “Systems Performance”
Java Interview Crash Guide
Java Interview Crash Guide
Jul 25, 2023 · Databases

Why MySQL Indexes Fail and How to Make Them Work

This article explains common MySQL index‑inefficiency scenarios—including left‑most prefix violations, range queries, functions, LIKE patterns, OR/IN misuse, and ORDER BY—provides concrete SQL examples, visual illustrations of B+‑tree indexing, and practical tips such as index jump scans, ICP, and query rewriting to ensure optimal index usage.

SQLindexmysql
0 likes · 20 min read
Why MySQL Indexes Fail and How to Make Them Work
Java High-Performance Architecture
Java High-Performance Architecture
Jul 19, 2023 · Databases

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

This article explains the typical reasons why a Redis instance becomes slow—such as high latency, expensive commands, big keys, concentrated expirations, memory limits, fork overhead, huge pages, AOF settings, CPU binding, swap usage, and memory fragmentation—and provides concrete diagnostics and optimization steps to resolve each issue.

optimizationredistroubleshooting
0 likes · 34 min read
Why Is Redis Slowing Down? 11 Common Causes and How to Fix Them
Sohu Tech Products
Sohu Tech Products
Jul 12, 2023 · Mobile Development

Measuring and Locating Android App Jank Using JankStats and Stack‑Dump Techniques

This article explains how to quantify Android UI jank by calculating a jank rate, uses Jetpack's JankStats library to collect frame‑level metrics, and presents two practical methods—stack dumping and bytecode instrumentation—to pinpoint the slow functions causing stutter, complete with Kotlin code examples and performance considerations.

AndroidJankKotlin
0 likes · 12 min read
Measuring and Locating Android App Jank Using JankStats and Stack‑Dump Techniques
Baidu Geek Talk
Baidu Geek Talk
Jul 10, 2023 · Mobile Development

How Baidu App Accelerated Android Startup: A Deep Dive into Launch Optimization

This article analyzes Baidu App's Android launch performance, explaining the startup process, identifying bottlenecks, and detailing practical optimizations—including task scheduling, KV storage redesign, lock improvements, and low‑level system tweaks—backed by code samples and measurable results.

AndroidLock RefactoringSharedPreferences
0 likes · 21 min read
How Baidu App Accelerated Android Startup: A Deep Dive into Launch Optimization
JD.com Experience Design Center
JD.com Experience Design Center
Jul 7, 2023 · Frontend Development

How to Boost Front‑End Performance by 279%: A Step‑by‑Step Optimization Guide

This article walks through a real‑world front‑end performance overhaul, explaining how Lighthouse metrics revealed major bottlenecks, detailing practical optimizations such as code splitting, lazy loading, image format changes, and CSP setup, and showing how monitoring tools keep the site fast over time.

LighthouseSEOfrontend
0 likes · 11 min read
How to Boost Front‑End Performance by 279%: A Step‑by‑Step Optimization Guide
Goodme Frontend Team
Goodme Frontend Team
Jul 6, 2023 · Frontend Development

How to Speed Up an Electron App Startup from 10 seconds to 1 second

This article explains how to measure, analyze, and optimize the startup performance of an Electron‑based cash‑register application, covering main‑process timing, renderer white‑screen reduction, code‑splitting, tree‑shaking, require caching, V8 snapshots, and user‑perceived improvements such as skeleton screens.

ElectronNodefrontend
0 likes · 17 min read
How to Speed Up an Electron App Startup from 10 seconds to 1 second
Baidu App Technology
Baidu App Technology
Jul 5, 2023 · Mobile Development

Baidu App Android Startup Performance Optimization: Theory, Tools, and Practical Implementations

Baidu dramatically accelerated its Android app’s launch by dissecting the cold‑start sequence, applying full‑path analysis, leveraging tracing tools, introducing a priority‑aware task‑scheduling framework, replacing SharedPreferences with the binary UniKV store, eliminating lock contention, and tightening thread, I/O, and library loading, which together cut ANR rates and boosted user retention.

ANRAndroidKV storage
0 likes · 24 min read
Baidu App Android Startup Performance Optimization: Theory, Tools, and Practical Implementations
dbaplus Community
dbaplus Community
Jun 28, 2023 · Operations

Identify and Fix System Performance Bottlenecks: Key Metrics and Optimization

The article outlines common system performance bottlenecks such as CPU, memory, disk I/O, network, exceptions, and databases, explains how to measure response time, TPS, and resource utilization, and provides a step‑by‑step bottom‑up and top‑down approach for testing, diagnosing, and optimizing Java‑based services.

bottleneckmonitoringoptimization
0 likes · 11 min read
Identify and Fix System Performance Bottlenecks: Key Metrics and Optimization
Top Architect
Top Architect
Jun 27, 2023 · Databases

Redis Performance Degradation: Root Causes and Optimization Techniques

This article explains how to benchmark Redis latency, identify common reasons for slowdowns such as high‑complexity commands, big keys, concentrated expirations, memory limits, fork overhead, swap usage, and CPU binding, and provides detailed configuration and operational steps to monitor and resolve each issue.

AOFLatencyMemory
0 likes · 34 min read
Redis Performance Degradation: Root Causes and Optimization Techniques
Architect
Architect
Jun 26, 2023 · Databases

Why Redis Becomes Slow and How to Optimize Its Performance

The article explains common reasons why Redis latency increases, such as intrinsic latency, high‑complexity commands, big keys, expiration spikes, memory limits, fork overhead, huge pages, AOF configuration, CPU binding, swap usage and memory fragmentation, and provides detailed troubleshooting steps and optimization techniques.

LatencyMemoryoptimization
0 likes · 33 min read
Why Redis Becomes Slow and How to Optimize Its Performance
Code Ape Tech Column
Code Ape Tech Column
Jun 23, 2023 · Databases

Chat2DB: An Open-Source AI-Powered Multi-Database Client – Installation, Configuration, and Usage Guide

This article introduces Chat2DB, an open‑source AI‑enhanced multi‑database client, explains how to download, install and configure it with OpenAI keys, demonstrates creating data sources and sample tables, and showcases natural‑language‑to‑SQL, SQL explanation, and optimization features with practical examples.

AIChat2DBSQL
0 likes · 11 min read
Chat2DB: An Open-Source AI-Powered Multi-Database Client – Installation, Configuration, and Usage Guide
DataFunSummit
DataFunSummit
Jun 19, 2023 · Artificial Intelligence

Overview of Decision Intelligence and Reinforcement Learning

This article provides a comprehensive overview of decision intelligence, distinguishing predictive and decision tasks, classifies decision environments, and delves into reinforcement learning fundamentals, algorithms such as SARSA, deep reinforcement learning, and discusses current applications, challenges, and future research directions.

artificial intelligencedecision intelligenceoptimization
0 likes · 12 min read
Overview of Decision Intelligence and Reinforcement Learning
JD Tech
JD Tech
Jun 14, 2023 · Big Data

Understanding and Solving Data Skew in Offline Big Data Development (Hive & Spark)

This article explains the concept of data skew in offline big‑data jobs, describes its symptoms and root causes, and provides practical optimization techniques for Hive and Spark—including partitioning strategies, map‑join usage, adaptive query settings, and monitoring approaches—to prevent performance degradation and runtime failures.

Data SkewHiveSQL
0 likes · 17 min read
Understanding and Solving Data Skew in Offline Big Data Development (Hive & Spark)
Ctrip Technology
Ctrip Technology
Jun 8, 2023 · Frontend Development

Optimizing CSS Animation Performance: Techniques and Best Practices

This article explains how to improve CSS animation performance by understanding the browser rendering pipeline, using GPU‑accelerated transforms, avoiding costly properties and complex selectors, leveraging will‑change and requestAnimationFrame, and preferring CSS over JavaScript for smoother, lower‑latency visual effects.

CSSGPUfrontend
0 likes · 13 min read
Optimizing CSS Animation Performance: Techniques and Best Practices
Aotu Lab
Aotu Lab
Jun 1, 2023 · Frontend Development

How We Built a 3D Web Shopping Experience with Babylon.js and React

This article details a step‑by‑step case study of creating a web‑based 3D shopping scene, covering framework selection, rendering layer architecture, collision handling, asset pipelines, performance optimizations, and future iteration plans for lazy loading and real‑time lighting.

3DWebGLbabylonjs
0 likes · 17 min read
How We Built a 3D Web Shopping Experience with Babylon.js and React
DaTaobao Tech
DaTaobao Tech
May 24, 2023 · Mobile Development

Understanding and Optimizing Mobile Page Performance and Jank

Effective mobile page performance requires identifying three jank types—screen tearing, frame drops, and long unresponsiveness—monitoring metrics such as response time, animation latency, idle time, and SM, understanding the CPU‑GPU rendering pipeline, and applying optimizations like hardware acceleration, transform‑based animations, reduced layout thrashing, task slicing, and GPU‑friendly techniques.

Browser RenderingGPU AccelerationJank
0 likes · 13 min read
Understanding and Optimizing Mobile Page Performance and Jank
WeChat Backend Team
WeChat Backend Team
May 24, 2023 · Databases

Boost ClickHouse Bitmap Queries 10x with BitBooster: Techniques & Results

This article explains how the BitBooster suite accelerates ClickHouse bitmap (BitMap) queries by up to tenfold, covering background, performance bottlenecks, single‑node and read optimizations, layout and instruction‑set enhancements, encoding dictionaries, multi‑node scaling, and real‑world benchmark results.

BitmapClickHouseoptimization
0 likes · 23 min read
Boost ClickHouse Bitmap Queries 10x with BitBooster: Techniques & Results
Didi Tech
Didi Tech
May 23, 2023 · Artificial Intelligence

Driver‑Passenger Matching in Didi’s Ride‑Hailing Market: Algorithms and Techniques

The article surveys Didi’s driver‑passenger matching challenges and presents a suite of solutions—from greedy nearest‑driver and Kuhn‑Munkres bipartite matching to stable marriage, dynamic and one‑to‑many assignments, reinforcement‑learning, routing and queueing models—while validating assumptions statistically, integrating preference‑aware machine learning, and outlining multi‑objective and digital‑twin future research.

Ride Hailingalgorithmmatching
0 likes · 23 min read
Driver‑Passenger Matching in Didi’s Ride‑Hailing Market: Algorithms and Techniques
58UXD
58UXD
May 17, 2023 · Product Management

Redesigning Ganji’s Enterprise Job Search: Boosting Intent and Differentiation

This case study details how the Ganji team re‑engineered the Enterprise Job Search section of its mobile app, using data‑driven analysis, strategic and structural redesign, and new content taxonomy to boost high‑intent conversions, differentiate the experience, and deliver measurable performance improvements.

Product DesignUX ResearchUser experience
0 likes · 13 min read
Redesigning Ganji’s Enterprise Job Search: Boosting Intent and Differentiation
Tencent Architect
Tencent Architect
May 16, 2023 · Fundamentals

Optimizing Network Latency in TencentOS: Kernel SoftIRQ and ksoftirqd Tuning

This article details a systematic investigation and multi‑stage optimization of TencentOS network latency, uncovering kernel soft‑interrupt bottlenecks, proposing and upstreaming patches to net_rx_action, RPS handling, and ksoftirqd scheduling, ultimately reducing handshake failures by over 80% while sharing practical insights for Linux kernel developers.

Linux kernelksoftirqdnetwork performance
0 likes · 15 min read
Optimizing Network Latency in TencentOS: Kernel SoftIRQ and ksoftirqd Tuning
Data Thinking Notes
Data Thinking Notes
May 10, 2023 · Big Data

Mastering Hive Small File Management: Strategies to Boost Performance

This article explains why tiny Hive files degrade storage and query efficiency, outlines how they are created, and presents practical Spark and Hive configuration techniques—including dynamic partitioning, AQE, Reduce tuning, and automated daily merge jobs—to effectively consolidate small files and improve overall data‑warehouse performance.

HiveSmall FilesSpark
0 likes · 10 min read
Mastering Hive Small File Management: Strategies to Boost Performance
HomeTech
HomeTech
May 10, 2023 · Frontend Development

Comprehensive Guide to H5 Page Load Performance Optimization

This article details comprehensive strategies for accelerating H5 page load times, covering background analysis, performance metrics, loading strategies, preload/prefetch, DNS prefetch, preconnect, skeleton screens, image compression with WebP, CDN caching, bundle optimization with Vite/Webpack, and provides practical code examples and configuration snippets.

H5Viteoptimization
0 likes · 15 min read
Comprehensive Guide to H5 Page Load Performance Optimization
DaTaobao Tech
DaTaobao Tech
May 10, 2023 · Mobile Development

Multi-Code Scanning Framework and Optimization for Mobile Apps

The article details how a mobile app’s scanner was re‑engineered from single‑code to multi‑code detection by overhauling the logic pipeline, adding UI overlays, implementing a rotation‑and‑scale transformation algorithm, integrating iOS Vision alongside the existing SDK, applying confidence filtering, deduplication, edge‑intelligence prediction, and memory‑optimized caching, ultimately boosting recognition rates by over 30 percentage points and reducing miss‑detections.

Barcode ScanningMobile DevelopmentVision
0 likes · 11 min read
Multi-Code Scanning Framework and Optimization for Mobile Apps
Top Architect
Top Architect
May 9, 2023 · Databases

Performance Testing and Optimization of MySQL Pagination for Large Datasets

This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures the latency of ordinary LIMIT pagination, analyzes the impact of offset size and result set size, and presents practical optimization techniques such as sub‑query pagination and ID‑range filtering to dramatically improve query speed.

Large DataSQLmysql
0 likes · 12 min read
Performance Testing and Optimization of MySQL Pagination for Large Datasets
Java High-Performance Architecture
Java High-Performance Architecture
May 9, 2023 · Databases

How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations

This article walks through creating a 10‑million‑row MySQL table, measuring pagination query times under different offsets and result sizes, and presents practical optimizations such as sub‑queries, ID‑range filtering, and column selection to dramatically improve performance while explaining why using SELECT * is discouraged.

Large DataSQLmysql
0 likes · 11 min read
How to Efficiently Paginate 10 Million MySQL Records: Real‑World Tests & Optimizations
DataFunSummit
DataFunSummit
May 8, 2023 · Fundamentals

Understanding Data Distributions: Normal vs. Power Law in Content Ecosystems

This article explores how data in content ecosystems is distributed, contrasting the classic normal distribution with heavy‑tailed power‑law patterns, explains why power‑law appears frequently, discusses its statistical properties and risks, and presents practical optimization and causal‑inference methods applied to creator incentives and platform strategies.

Power LawStatistical Modelingcontent ecosystem
0 likes · 20 min read
Understanding Data Distributions: Normal vs. Power Law in Content Ecosystems
MaGe Linux Operations
MaGe Linux Operations
May 5, 2023 · Operations

Boost Your NGINX Performance: 8 Proven Tuning Tips

This guide explains how to optimize NGINX on Linux by adjusting worker processes, connection limits, GZIP compression, timeout values, buffer sizes, log handling, static content caching, and open file caching, providing step‑by‑step commands and configuration snippets for maximum server efficiency.

ConfigurationLinuxNginx
0 likes · 8 min read
Boost Your NGINX Performance: 8 Proven Tuning Tips
DataFunTalk
DataFunTalk
Apr 30, 2023 · Artificial Intelligence

Integrated Multi‑Relation Graph Neural Network (EMR‑GNN)

This article presents a unified optimization framework for graph neural networks, derives an integrated multi‑relation GNN (EMR‑GNN) with a novel message‑passing mechanism, and demonstrates its theoretical advantages and empirical superiority over existing relational GNN models.

EMR-GNNMulti-Relationmessage passing
0 likes · 15 min read
Integrated Multi‑Relation Graph Neural Network (EMR‑GNN)
DeWu Technology
DeWu Technology
Apr 28, 2023 · Operations

Analysis of Live Streaming Latency Causes and Optimization Strategies

The article examines why live‑streaming latency—averaging about five seconds on the studied platform versus three seconds on top e‑commerce services—remains high, pinpointing encoder, transcoding, CDN GOP‑cache, and player buffering as key contributors, and proposes optimizations such as shrinking GOP size, minimizing CDN cache tiers, tightening player buffers, and adopting ultra‑low‑latency protocols like RTS, RTM, or QUIC to achieve sub‑second delays.

CDNGOPLatency
0 likes · 16 min read
Analysis of Live Streaming Latency Causes and Optimization Strategies
Top Architect
Top Architect
Apr 27, 2023 · Backend Development

Optimizing SpringBoot Startup Performance by Reducing Bean Scanning and Monitoring Bean Initialization

This article explains how to diagnose and dramatically reduce SpringBoot application startup time—from several minutes to seconds—by analyzing the SpringApplicationRunListener and BeanPostProcessor phases, limiting component scanning, customizing bean registration, and handling cache auto‑configuration issues, with detailed code examples and performance measurements.

BeanScanningJavaSpringBoot
0 likes · 20 min read
Optimizing SpringBoot Startup Performance by Reducing Bean Scanning and Monitoring Bean Initialization
Efficient Ops
Efficient Ops
Apr 18, 2023 · Databases

Mastering MongoDB Clusters: Setup, Monitoring, Migration, and Optimization

This comprehensive guide explains MongoDB cluster architecture, component roles, common use cases, monitoring commands, essential maintenance operations, data migration steps, troubleshooting of typical production issues, and practical optimization recommendations for high‑performance deployments.

BackupClusterMongoDB
0 likes · 20 min read
Mastering MongoDB Clusters: Setup, Monitoring, Migration, and Optimization
Aotu Lab
Aotu Lab
Apr 13, 2023 · Frontend Development

How to Triple Your Web App’s Speed: A Front‑End Performance Optimization Playbook

This article walks through a comprehensive front‑end performance optimization process—starting from diagnosing issues with Lighthouse, identifying bottlenecks such as large bundle size and uncompressed assets, applying code splitting, lazy loading, image optimization, CSP, SEO tweaks, and finally setting up continuous monitoring with a custom platform—to achieve a 279% improvement in Lighthouse performance scores and near‑three‑fold speed gains.

LighthouseSEOfrontend
0 likes · 11 min read
How to Triple Your Web App’s Speed: A Front‑End Performance Optimization Playbook
Liangxu Linux
Liangxu Linux
Apr 11, 2023 · Operations

Master Linux Performance Tuning: Practical Steps for Faster Systems

This guide explains why Linux performance depends on both hardware and software, outlines key factors such as CPU, memory, disk I/O, network, OS installation, kernel parameters, file systems, and application design, and provides a step‑by‑step process for administrators, architects, and developers to diagnose and optimize system speed.

HardwareLinuxRAID
0 likes · 16 min read
Master Linux Performance Tuning: Practical Steps for Faster Systems
Laravel Tech Community
Laravel Tech Community
Apr 5, 2023 · Backend Development

PHP Performance Optimization: String Handling, Statements, Functions, Variables, Arrays and Architecture

This article presents a comprehensive set of PHP performance‑optimization techniques, covering efficient string operations, statement usage, function design, variable handling, array manipulation and architectural choices such as compression, static pages and caching, all illustrated with concrete code examples.

BackendMemory Managementcoding practices
0 likes · 14 min read
PHP Performance Optimization: String Handling, Statements, Functions, Variables, Arrays and Architecture
Bilibili Tech
Bilibili Tech
Apr 4, 2023 · Big Data

How Bilibili’s Flink‑Based Real‑Time Incremental Pipeline Cuts Costs and Boosts Latency

This article details Bilibili’s migration from a Spark‑based offline ODS‑to‑DWD sharding process to a Flink real‑time incremental pipeline, explaining the background challenges, the design of multi‑level partitioning, small‑file optimizations, stability enhancements, and the measurable performance gains achieved.

Big DataData WarehouseFlink
0 likes · 19 min read
How Bilibili’s Flink‑Based Real‑Time Incremental Pipeline Cuts Costs and Boosts Latency