BestHub
Sign in
Tagged articles
1036 articles
Page 3 of 11
Architecture Digest
Architecture Digest
Oct 11, 2024 · Backend Development

Common Interface Performance Optimization Techniques

This article outlines a series of backend interface performance optimization strategies—including batch processing, asynchronous execution, caching, preprocessing, pooling, parallelization, indexing, transaction management, program structure refactoring, deep pagination, SQL tuning, and lock granularity—to help developers reduce latency and improve system efficiency.

AsynchronousBatch Processingcaching
0 likes · 9 min read
Common Interface Performance Optimization Techniques
Test Development Learning Exchange
Test Development Learning Exchange
Oct 11, 2024 · Fundamentals

Fundamentals of Performance Testing: Concepts, Metrics, Tools, and Best Practices

This article provides a comprehensive overview of performance testing fundamentals, covering core concepts, key metrics, common testing tools, test design, load generation, result analysis, bottleneck identification, optimization techniques, cloud and micro‑service testing, monitoring, reporting, challenges, and cost‑benefit considerations.

BenchmarkingLoad TestingPerformance Testing
0 likes · 12 min read
Fundamentals of Performance Testing: Concepts, Metrics, Tools, and Best Practices
Model Perspective
Model Perspective
Oct 11, 2024 · Fundamentals

Beyond Maximizing: Exploring Diverse Decision‑Making Perspectives

This article examines how decision makers can move beyond a single "maximization" goal by considering satisficing, risk minimization, multi‑objective optimization, and regret minimization, offering a richer set of viewpoints for tackling complex, uncertain choices.

decision makingmulti-objectiveoptimization
0 likes · 10 min read
Beyond Maximizing: Exploring Diverse Decision‑Making Perspectives
Selected Java Interview Questions
Selected Java Interview Questions
Oct 6, 2024 · Backend Development

Comprehensive Nginx Configuration Guide: Basics, Optimization, and Deployment

This article provides a detailed walkthrough of Nginx configuration, explaining the global, events, and http blocks, offering simple deployment steps, and covering common optimizations such as history‑mode handling, reverse proxy setup, gzip compression, maintenance pages, multi‑site hosting, static‑dynamic separation, and essential command‑line operations.

optimizationreverse proxy
0 likes · 12 min read
Comprehensive Nginx Configuration Guide: Basics, Optimization, and Deployment
Java Tech Enthusiast
Java Tech Enthusiast
Oct 3, 2024 · Databases

Understanding MySQL Architecture and SQL Execution Flow

The article outlines MySQL’s layered architecture—connector, parser, optimizer, executor, and binary log in the server layer and pluggable storage engines like InnoDB—then walks through the step‑by‑step processing of SELECT and UPDATE statements, highlighting permission checks, caching, plan selection, redo and binlog handling for crash‑safe durability.

Database ArchitectureInnoDBQuery Processing
0 likes · 11 min read
Understanding MySQL Architecture and SQL Execution Flow
Model Perspective
Model Perspective
Oct 3, 2024 · Operations

When Winning Tactics Undermine Strategy: A Mathematical Perspective

The article examines why short‑term tactical victories can paradoxically lead to strategic failure, using definitions, local‑versus‑global optimum analysis, Nash equilibrium examples, and resource‑allocation trade‑offs to illustrate the hidden costs of over‑optimizing tactics.

Game Theoryoptimizationresource allocation
0 likes · 9 min read
When Winning Tactics Undermine Strategy: A Mathematical Perspective
Top Architect
Top Architect
Sep 27, 2024 · Backend Development

Comprehensive Guide to Nginx Configuration, Optimization, and Deployment

This article provides a step‑by‑step tutorial on understanding, simplifying, annotating, and optimizing Nginx configuration files, covering global, events, and http blocks, practical deployment tips, reverse‑proxy setup, gzip compression, maintenance pages, multi‑site hosting, static‑dynamic separation, and essential command‑line operations for Linux servers.

BackendDeploymentGzip
0 likes · 20 min read
Comprehensive Guide to Nginx Configuration, Optimization, and Deployment
Top Architect
Top Architect
Sep 23, 2024 · Backend Development

Understanding Nginx Architecture, Process Model, FastCGI Integration, and Performance Optimization

This article provides a comprehensive overview of Nginx's high‑performance architecture, including its core, basic, and third‑party modules, master‑worker process model, asynchronous non‑blocking I/O mechanisms, FastCGI and PHP‑FPM integration, and practical configuration and tuning tips for optimal server operation.

BackendNginxOperations
0 likes · 46 min read
Understanding Nginx Architecture, Process Model, FastCGI Integration, and Performance Optimization
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 21, 2024 · Backend Development

Backend Anti‑Patterns and Optimization Strategies for MySQL, Redis, and Thread Pools

This article examines common backend anti‑patterns such as inefficient MySQL for‑loops, heavy multi‑query methods, full‑table scans, improper thread‑pool creation, and long‑running transactions, and provides practical optimization recommendations including query consolidation, caching, indexing, and proper resource management.

Anti-PatternsBackendmysql
0 likes · 12 min read
Backend Anti‑Patterns and Optimization Strategies for MySQL, Redis, and Thread Pools
Model Perspective
Model Perspective
Sep 16, 2024 · Operations

Can 0‑1 Knapsack Modeling Turn You Into a Time‑Management Master?

This article applies 0‑1 knapsack and multi‑objective optimization models to illustrate how students and professionals can allocate limited daily hours among competing tasks, using weighted importance and urgency to devise optimal schedules illustrated with real‑world case studies.

0-1 knapsackmulti-objectiveoptimization
0 likes · 7 min read
Can 0‑1 Knapsack Modeling Turn You Into a Time‑Management Master?
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 15, 2024 · Frontend Development

Three.js Tutorial: Installation, Scene Setup, Model Loading, Interaction, and Optimization

This article provides a step‑by‑step guide on using three.js—including installing the library, creating a scene with an orthographic camera, loading GLTF models, implementing touch‑based rotation, zoom, and pan interactions, adding lighting and rendering optimizations, and handling iOS Safari scaling issues.

3d-modelThree.jsinteraction
0 likes · 11 min read
Three.js Tutorial: Installation, Scene Setup, Model Loading, Interaction, and Optimization
Top Architect
Top Architect
Sep 12, 2024 · Operations

Comprehensive Nginx Configuration Guide: From Basics to Optimization

This article provides a step‑by‑step walkthrough of Nginx configuration, covering the original nginx.conf structure, a cleaned‑up version with annotations, the three main blocks (global, events, http), simple site deployment, common optimizations such as history‑mode handling, reverse proxy, gzip compression, maintenance pages, multi‑site hosting, static‑dynamic separation, and essential commands for installation, start, reload and shutdown.

ConfigurationDeploymentGzip
0 likes · 18 min read
Comprehensive Nginx Configuration Guide: From Basics to Optimization
iQIYI Technical Product Team
iQIYI Technical Product Team
Sep 12, 2024 · Artificial Intelligence

Intelligent Compute Allocation in Advertising: Value Quantification, Elastic Elimination, and Dynamic Optimization

iQIYI’s ad engine team introduced an intelligent compute allocation system that quantifies traffic value and unified compute cost, uses elastic elimination and a dynamic allocation framework to maximize revenue under fixed compute limits, delivering over 30% inventory growth, modest consumption rise, and near‑perfect availability.

PID controldynamic allocationintelligent compute
0 likes · 11 min read
Intelligent Compute Allocation in Advertising: Value Quantification, Elastic Elimination, and Dynamic Optimization
Java High-Performance Architecture
Java High-Performance Architecture
Sep 12, 2024 · Operations

Master Nginx: From Basic Config to Advanced Optimizations

This article walks front‑end developers through the essential Nginx concepts, from understanding the original nginx.conf file and its annotated version to practical deployment steps, key optimizations like gzip, reverse proxy, static‑dynamic separation, and essential command‑line operations for installing, managing, and tuning the server.

ConfigurationDeploymentGzip
0 likes · 15 min read
Master Nginx: From Basic Config to Advanced Optimizations
Sanyou's Java Diary
Sanyou's Java Diary
Sep 9, 2024 · Databases

Master MySQL Indexes: B+Tree, Hash, Clustering & Optimization

This article provides a comprehensive guide to MySQL indexing, covering index types, data structures, clustering and non‑clustering indexes, hash indexes, B+Tree mechanics, index lookup, covering indexes, index push‑down, index merge, cost‑based index selection, common pitfalls, and best practices for designing effective indexes.

databaseindexmysql
0 likes · 34 min read
Master MySQL Indexes: B+Tree, Hash, Clustering & Optimization
Python Programming Learning Circle
Python Programming Learning Circle
Sep 7, 2024 · Fundamentals

Performance Comparison of while and for Loops in Python

This article examines the speed differences between Python's while and for loops by benchmarking summation tasks, explains why for loops are faster due to fewer Python‑level operations, and demonstrates how built‑in functions or mathematical formulas can achieve dramatically higher performance, ultimately concluding that avoiding explicit loops yields the best results.

Benchmarkbuilt-in functionsloop performance
0 likes · 6 min read
Performance Comparison of while and for Loops in Python
Java Architect Essentials
Java Architect Essentials
Aug 31, 2024 · Backend Development

Java Backend Performance Optimization: Parallel Processing, Transaction Scope, Caching, Thread Pools, and Concurrency

This article provides a comprehensive guide to improving Java backend performance by explaining parallel processing with CompletableFuture, minimizing transaction scope, effective caching strategies, proper thread‑pool configuration, cache‑line alignment, reducing object creation, lock granularity, copy‑on‑write collections, asynchronous patterns, loop optimizations, network payload reduction, and minimizing inter‑service dependencies.

JavaThreadPoolcaching
0 likes · 33 min read
Java Backend Performance Optimization: Parallel Processing, Transaction Scope, Caching, Thread Pools, and Concurrency
Python Programming Learning Circle
Python Programming Learning Circle
Aug 26, 2024 · Fundamentals

Six Techniques to Improve Python Code Performance

This article explains why Python may run slower than compiled languages, introduces methods for detecting performance bottlenecks, and presents six practical techniques—including using timeit, memory_profiler, line_profiler, built‑in functions, f‑strings, list comprehensions, and lru_cache—to significantly speed up Python programs.

Profilingbest-practicescode
0 likes · 9 min read
Six Techniques to Improve Python Code Performance
JD Tech Talk
JD Tech Talk
Aug 21, 2024 · Frontend Development

Browser Navigation Process and Performance Optimization Techniques

This article explains the complete browser navigation flow from URL entry to page rendering and provides practical optimization strategies for DNS resolution, HTTP protocols, CDN usage, and front‑end resources such as HTML, CSS, JavaScript, images, and fonts to improve performance and user experience.

BrowserCDNHTTP
0 likes · 13 min read
Browser Navigation Process and Performance Optimization Techniques
JD Cloud Developers
JD Cloud Developers
Aug 21, 2024 · Frontend Development

Unlock Faster Page Loads: Mastering Browser Rendering and Performance Optimizations

This article explains the complete browser navigation process—from URL entry, DNS resolution, TCP and HTTP communication, to resource loading and page rendering—and presents practical optimization techniques such as DNS prefetch, HTTP/2, CDN usage, and HTML, CSS, JavaScript, and image improvements to boost frontend performance.

BrowserCDNHTTP
0 likes · 17 min read
Unlock Faster Page Loads: Mastering Browser Rendering and Performance Optimizations
dbaplus Community
dbaplus Community
Aug 20, 2024 · Databases

How REDgraph Cut Multi‑Hop Query Latency by 50% with Distributed Parallel Execution

Xiaohongshu's REDgraph graph database faced high latency for multi‑hop queries, so the storage team redesigned the query framework using MPP‑inspired distributed parallel execution, edge‑partitioning, operator forwarding, and caching, achieving over 50% latency reduction and making three‑hop queries viable for online services.

Distributed QueryREDgraphgraph-database
0 likes · 30 min read
How REDgraph Cut Multi‑Hop Query Latency by 50% with Distributed Parallel Execution
Baidu Geek Talk
Baidu Geek Talk
Aug 19, 2024 · Artificial Intelligence

PaddlePaddle Neural Network Compiler (CINN): Architecture, Optimization Techniques, and Performance Gains

The PaddlePaddle Neural Network Compiler (CINN) combines a PIR‑based frontend that performs graph‑level optimizations such as constant folding, dead‑code elimination and operator fusion with a backend that applies schedule transformations and auto‑tuning, delivering up to 4× faster RMSNorm kernels and 30‑60% overall speed‑ups for generative AI and scientific‑computing workloads.

CINNDeep LearningGPU
0 likes · 18 min read
PaddlePaddle Neural Network Compiler (CINN): Architecture, Optimization Techniques, and Performance Gains
Su San Talks Tech
Su San Talks Tech
Aug 18, 2024 · Big Data

How to Crush the One Billion Row Java Challenge: From 14 Minutes to Sub‑2‑Second Runtime

This article walks through the One Billion Row Challenge, explaining the problem, baseline solution, and a series of performance optimizations—from JVM selection and parallel I/O to custom hash tables, unsafe memory access, and SIMD techniques—that shrink execution time from minutes to under two seconds.

Big DataJavaOne Billion Row Challenge
0 likes · 20 min read
How to Crush the One Billion Row Java Challenge: From 14 Minutes to Sub‑2‑Second Runtime
JD Tech
JD Tech
Aug 15, 2024 · Frontend Development

Understanding Browser Rendering Process and Performance Optimization Techniques

This article explains the complete browser rendering pipeline—from URL entry, DNS resolution, TCP/HTTP communication, resource loading, DOM/CSSOM construction, to page painting—and presents practical optimization strategies such as DNS prefetching, HTTP/2, CDN usage, and HTML/CSS/JS best practices to improve frontend performance.

BrowserRenderingoptimization
0 likes · 14 min read
Understanding Browser Rendering Process and Performance Optimization Techniques
Top Architect
Top Architect
Aug 15, 2024 · Backend Development

Understanding Nginx Architecture, Process Model, FastCGI Integration, and Performance Optimization

This article provides a comprehensive overview of Nginx's high‑performance architecture, including its core, basic and third‑party modules, master‑worker process model, asynchronous event handling with epoll, FastCGI and PHP‑FPM integration, as well as detailed configuration and optimization techniques for production deployments.

BackendNginxWeb server
0 likes · 47 min read
Understanding Nginx Architecture, Process Model, FastCGI Integration, and Performance Optimization
DaTaobao Tech
DaTaobao Tech
Aug 12, 2024 · Artificial Intelligence

Challenges and Optimization Techniques for Retrieval‑Augmented Generation (RAG)

Deploying large language models faces domain gaps, hallucinations, and high barriers, so Retrieval‑Augmented Generation (RAG) combines retrieval with generation, and advanced optimizations—such as RAPTOR’s hierarchical clustering, Self‑RAG’s self‑reflective retrieval, CRAG’s corrective evaluator, proposition‑level Dense X Retrieval, sophisticated chunking, query rewriting, and hybrid sparse‑dense methods—are essential for improving accuracy, reducing hallucinations, and achieving efficient, scalable performance.

AIRAGRetrieval Augmented Generation
0 likes · 22 min read
Challenges and Optimization Techniques for Retrieval‑Augmented Generation (RAG)
Python Programming Learning Circle
Python Programming Learning Circle
Aug 6, 2024 · Fundamentals

Four Time‑Saving Python Tricks to Boost Execution Speed

This article presents four practical Python performance tricks—including list reversal with slicing versus reverse(), one‑line variable swapping, moving loops inside functions, and reducing function calls—each demonstrated with code examples and timing results that show measurable speed improvements.

Loop Optimizationlist reversaloptimization
0 likes · 5 min read
Four Time‑Saving Python Tricks to Boost Execution Speed
Selected Java Interview Questions
Selected Java Interview Questions
Aug 5, 2024 · Backend Development

Backend Interface Performance Optimization Techniques

This article presents a thorough collection of practical techniques for optimizing backend interface performance, covering index management, SQL tuning, parallel remote calls, asynchronous processing, transaction handling, lock granularity, caching strategies, sharding, and monitoring tools, offering actionable guidance for developers to improve service efficiency.

cachingdistributed-systemsoptimization
0 likes · 27 min read
Backend Interface Performance Optimization Techniques
Model Perspective
Model Perspective
Aug 2, 2024 · Artificial Intelligence

Unlocking Problem Solving: 7 Powerful Heuristic Algorithms Explained

This article introduces heuristic algorithms—strategies that use experience and trial to quickly find approximate solutions for complex, often NP‑hard problems—detailing seven popular methods such as Greedy, Tabu Search, Simulated Annealing, Ant Colony, Genetic, Particle Swarm, and Artificial Bee Colony, and highlighting their principles, steps, and real‑world insights.

AIMetaheuristicsheuristic algorithms
0 likes · 10 min read
Unlocking Problem Solving: 7 Powerful Heuristic Algorithms Explained
Model Perspective
Model Perspective
Aug 1, 2024 · Fundamentals

How to Make Optimal Decisions When Time Is Limited

The article explains why effective decision‑making must consider contextual constraints—especially time—illustrates the impact of ample versus scarce decision time, and presents simple mathematical models to help individuals and organizations choose the best actions under pressure.

Leadershipdecision makingmathematical modeling
0 likes · 7 min read
How to Make Optimal Decisions When Time Is Limited
DataFunTalk
DataFunTalk
Jul 29, 2024 · Operations

Operations Research and AI Frontiers Workshop – August 4‑5, 2024 (Zhejiang University)

The two‑day workshop hosted by Zhejiang University Management School and Shanghai Jiao Tong University brings leading scholars and industry experts to present cutting‑edge research on operations research, large‑scale optimization, AI, graph neural networks, and supply‑chain applications, with detailed speaker bios, talk titles, abstracts, and registration information.

Operations ResearchSupply Chainconference
0 likes · 19 min read
Operations Research and AI Frontiers Workshop – August 4‑5, 2024 (Zhejiang University)
ITPUB
ITPUB
Jul 27, 2024 · Databases

How to Diagnose and Optimize Extremely Slow MySQL Queries

This article explains what constitutes a slow SQL query, how to detect and analyze it using MySQL tools, and provides practical optimization steps—including indexing, business logic review, caching, scheduling, and partitioning—to dramatically reduce execution time.

SQLdatabaseindexing
0 likes · 7 min read
How to Diagnose and Optimize Extremely Slow MySQL Queries
Architecture & Thinking
Architecture & Thinking
Jul 24, 2024 · Databases

Why MySQL Pagination Slows Down and How to Speed It Up

This article examines why MySQL pagination using large LIMIT OFFSET values becomes increasingly slow, explains the underlying scanning behavior, and presents six practical optimization techniques—including indexed subqueries, cursor‑based pagination, column selection, partitioning, caching, and hardware considerations—to dramatically improve query performance on massive tables.

SQLdatabasemysql
0 likes · 7 min read
Why MySQL Pagination Slows Down and How to Speed It Up
Python Programming Learning Circle
Python Programming Learning Circle
Jul 17, 2024 · Fundamentals

Simple Techniques to Speed Up Python For Loops by Up to 970×

This article demonstrates a collection of straightforward Python performance tricks—such as list comprehensions, external length calculation, set usage, loop skipping, code inlining, generators, map(), memoization, vectorization, filterfalse, and string joining—that together can accelerate for‑loops from modest 1.3× gains to dramatic 970× speed‑ups, with detailed benchmark results and code examples.

BenchmarkingLoopscode
0 likes · 15 min read
Simple Techniques to Speed Up Python For Loops by Up to 970×
Bilibili Tech
Bilibili Tech
Jul 9, 2024 · Operations

Standardizing VOD CDN Backsource Architecture: Issues, Strategies, and Optimizations

The article outlines how a VOD provider standardized its multi‑vendor CDN back‑source architecture by classifying videos as hot or cold, prioritizing fragment‑level pulls, throttling full‑file transfers, implementing real‑time monitoring, decoupling storage buckets, and adding OSIG authentication to reduce latency, bandwidth pressure, and security risks.

BacksourceCDNSecurity
0 likes · 7 min read
Standardizing VOD CDN Backsource Architecture: Issues, Strategies, and Optimizations
Liangxu Linux
Liangxu Linux
Jul 8, 2024 · Operations

7 Practical Linux Performance Optimization Tips Every Engineer Should Know

This article compiles seven hands‑on Linux performance‑optimization practices, covering key factors such as CPU, memory, disk I/O, network, swap usage, and TCP tuning, and provides concrete commands and step‑by‑step troubleshooting methods for system administrators and DevOps engineers.

LinuxSwapTCP
0 likes · 19 min read
7 Practical Linux Performance Optimization Tips Every Engineer Should Know
IT Architects Alliance
IT Architects Alliance
Jul 7, 2024 · Backend Development

Java Backend Performance Optimization: Parallel Processing, Thread Pools, Caching, and Concurrency Techniques

This article presents a comprehensive guide to improving Java backend performance by using parallel processing with CompletableFuture, minimizing transaction scope, applying effective caching strategies, configuring thread pools, reducing object creation, and employing various concurrency controls such as volatile, CAS, and read‑write locks.

JavaThreadPoolconcurrency
0 likes · 34 min read
Java Backend Performance Optimization: Parallel Processing, Thread Pools, Caching, and Concurrency Techniques
Architect
Architect
Jul 3, 2024 · Backend Development

How to Supercharge Java Backend Performance: Parallelism, Thread Pools, Caching, and More

This article walks through practical Java backend performance techniques—including parallel processing with CompletableFuture, fine‑tuned thread‑pool configuration, transaction scope minimization, cache‑line awareness, object‑pool usage, lock granularity, copy‑on‑write collections, and network payload reduction—backed by concrete code samples, benchmark results, and step‑by‑step analysis of trade‑offs and best practices.

JavaThreadPoolcaching
0 likes · 36 min read
How to Supercharge Java Backend Performance: Parallelism, Thread Pools, Caching, and More
Model Perspective
Model Perspective
Jun 23, 2024 · Artificial Intelligence

Mastering Multi-Objective Optimization with NSGA-II: Theory and Python Example

This article introduces the fundamentals of multi‑objective optimization, explains the NSGA‑II algorithm’s non‑dominated sorting, crowding distance, and selection mechanisms, and demonstrates its application to a production‑line case study with a complete Python implementation and visualized Pareto front.

Evolutionary AlgorithmsNSGA-IIPareto Front
0 likes · 10 min read
Mastering Multi-Objective Optimization with NSGA-II: Theory and Python Example
DaTaobao Tech
DaTaobao Tech
Jun 21, 2024 · Big Data

Flink Real-Time Data Development: Cases on Data Skew, Watermark Failure, and GroupBy Issues

The article walks through three Flink streaming pitfalls—data‑skew‑induced back‑pressure, lost watermarks after interval joins, and ineffective group‑by causing duplicate rows—and shows how to resolve them with two‑stage distinct aggregation, hash‑based key distribution, processing‑time windows or split jobs, and mini‑batch buffering.

Data SkewFlinkReal-Time
0 likes · 14 min read
Flink Real-Time Data Development: Cases on Data Skew, Watermark Failure, and GroupBy Issues
Code Mala Tang
Code Mala Tang
Jun 20, 2024 · Frontend Development

Essential Latency Numbers Every Web Developer Must Know

This article explores critical latency metrics—from nanosecond-level CPU operations to intercontinental network delays—illustrating how each contributes to web performance, and provides real‑world measurements for various connection types, data processing tasks, and user‑perceived response times to help developers optimize user experience.

LatencyWeb Performancefrontend
0 likes · 6 min read
Essential Latency Numbers Every Web Developer Must Know
AI Architecture Hub
AI Architecture Hub
Jun 20, 2024 · Big Data

How GeoHash Powers Efficient Large-Scale Location Queries Without Pagination

This article explains the GeoHash algorithm, shows how it converts latitude‑longitude pairs into compact binary strings, demonstrates the encoding process with a concrete example, and discusses how the resulting prefixes can be used to quickly locate nearby users in massive datasets while highlighting remaining edge‑case challenges.

Big DataGeoHashLocation Query
0 likes · 7 min read
How GeoHash Powers Efficient Large-Scale Location Queries Without Pagination
21CTO
21CTO
Jun 17, 2024 · Fundamentals

How Cython, SPy, and Sub‑Interpreters Are Supercharging Python Performance

At PyCon 2024, experts demonstrated how static typing, Cython compilation, static‑linked C extensions, and sub‑interpreter architectures can dramatically accelerate Python code, reduce runtime overhead, and mitigate GIL limitations, offering practical pathways for faster, more scalable Python applications.

CythonGILoptimization
0 likes · 11 min read
How Cython, SPy, and Sub‑Interpreters Are Supercharging Python Performance
Architect's Guide
Architect's Guide
Jun 16, 2024 · Operations

How to Diagnose and Resolve 900% CPU Spikes in MySQL and Java Processes

This article explains common scenarios that cause MySQL or Java processes to consume 900% CPU, walks through step‑by‑step diagnosis using Linux tools, and provides concrete optimization techniques such as indexing, caching, thread analysis, and code adjustments to bring CPU usage back to normal levels.

CPUJavaLinux
0 likes · 11 min read
How to Diagnose and Resolve 900% CPU Spikes in MySQL and Java Processes
php Courses
php Courses
May 29, 2024 · Backend Development

PHP Performance Monitoring and Optimization Techniques

This article explains how to monitor and improve website performance in PHP by measuring script execution time, memory usage, database query efficiency, code execution, and HTTP request latency, and provides practical code examples for each technique.

PHPPerformance MonitoringWeb Development
0 likes · 5 min read
PHP Performance Monitoring and Optimization Techniques
dbaplus Community
dbaplus Community
May 27, 2024 · Backend Development

How to Optimize Java Logging for Maximum Performance

This article explains why Java logging can become a performance bottleneck, identifies common misuse patterns, and provides practical steps—such as dynamic log levels, avoiding string concatenation, selective location info, and cautious async logging—to dramatically improve throughput and latency.

AsyncBackendJava
0 likes · 6 min read
How to Optimize Java Logging for Maximum Performance
JD Cloud Developers
JD Cloud Developers
May 21, 2024 · Databases

How to Refactor Complex SQL Like Java Code: A Real‑World Case Study

This article demonstrates how to refactor a complex, production‑level SQL query used in a routing system by formatting, decomposing into layers, merging temporary tables, pushing predicates, optimizing joins, and validating performance, ultimately reducing nesting from four levels to one and cutting execution time from 4.75 s to 0.6 s.

JOINSQLdatabase
0 likes · 15 min read
How to Refactor Complex SQL Like Java Code: A Real‑World Case Study
ITPUB
ITPUB
May 19, 2024 · Databases

Why Redis Can Slow Down Your App and How to Fix It

This article explains common Redis performance pitfalls—including per‑command network latency, expensive commands like SUNION and KEYS, mass key expiration spikes, and big‑key deletions—and provides practical techniques such as MSET batching, randomizing expirations, and using UNLINK to keep your backend fast.

databaseoptimizationperformance
0 likes · 8 min read
Why Redis Can Slow Down Your App and How to Fix It
21CTO
21CTO
May 18, 2024 · Artificial Intelligence

What Makes GPT‑4o Faster, Smarter, and More Multimodal Than GPT‑4?

This article examines OpenAI's GPT‑4o, outlining its key performance, speed, accuracy, latency, multimodal, and resource‑efficiency improvements over GPT‑4, and explains why these enhancements broaden the model's applicability across various AI‑driven applications.

AI modelGPT-4omultimodal
0 likes · 6 min read
What Makes GPT‑4o Faster, Smarter, and More Multimodal Than GPT‑4?
Python Programming Learning Circle
Python Programming Learning Circle
May 17, 2024 · Databases

SQL Optimization Tips and Best Practices

This article presents a comprehensive collection of MySQL performance guidelines, covering query writing, index usage, join strategies, data types, batch operations, and execution plan analysis to help developers write faster and more reliable SQL statements.

SQLbest practicesindexes
0 likes · 19 min read
SQL Optimization Tips and Best Practices
Liangxu Linux
Liangxu Linux
May 12, 2024 · Operations

7 Practical Linux Performance Optimization Tips Every Engineer Should Know

This guide explains the key factors that affect Linux system performance, provides step‑by‑step troubleshooting methods for CPU, memory, disk I/O and network issues, shows how to identify top resource‑hungry processes, clarifies memory reporting differences, discusses swap usage scenarios, and offers concrete TCP tuning parameters for production environments.

LinuxTCPmonitoring
0 likes · 20 min read
7 Practical Linux Performance Optimization Tips Every Engineer Should Know
MaGe Linux Operations
MaGe Linux Operations
May 4, 2024 · Databases

Unlocking Redis Memory: How Its Internal Model Impacts Performance

This article explains Redis's memory model—including memory statistics, allocation, internal data structures, object types, and encoding—while showing practical examples for estimating usage, optimizing consumption, and troubleshooting fragmentation in high‑concurrency environments.

Data StructuresMemory Managementjemalloc
0 likes · 34 min read
Unlocking Redis Memory: How Its Internal Model Impacts Performance
Model Perspective
Model Perspective
May 4, 2024 · Operations

How to Make Smarter Decisions with Math: 5 Essential Steps

This article explains how a clear, efficient decision‑making process—defining SMART goals, allocating resources with constraints, evaluating alternatives using tools like linear programming and decision trees, executing plans, and iterating through reflection—can be mathematically modeled to improve quality and outcomes.

Operations ManagementSMART goalsdecision making
0 likes · 10 min read
How to Make Smarter Decisions with Math: 5 Essential Steps
Baidu Geek Talk
Baidu Geek Talk
Apr 17, 2024 · Industry Insights

Mastering Multi-CPU Performance: Challenges and One-Click Tuning with Btune

The talk outlines how modern data centers host diverse CPUs (Intel, AMD, Ampere, ARM), the multi‑layer performance‑tuning challenges this creates, and how Baidu Cloud’s one‑click Btune suite automates metric collection, bottleneck identification, and optimization across hardware, kernel, runtime, and application layers.

BtuneCPUData center
0 likes · 19 min read
Mastering Multi-CPU Performance: Challenges and One-Click Tuning with Btune
Code Ape Tech Column
Code Ape Tech Column
Apr 17, 2024 · Backend Development

Spring Boot Startup Configuration Principles, Extension Points, and Performance Optimizations

This article explains the core principles of Spring Boot startup configuration, demonstrates how to intervene using ApplicationContextInitializer, SpringApplicationRunListener, ApplicationRunner, and CommandLineRunner, and provides practical optimization techniques to significantly reduce application launch time.

ApplicationContextInitializerApplicationRunnerBackend
0 likes · 32 min read
Spring Boot Startup Configuration Principles, Extension Points, and Performance Optimizations
JavaEdge
JavaEdge
Apr 13, 2024 · Backend Development

Mastering System Performance: Metrics, Strategies, and Real‑World Implementation

This article explains why performance optimization is essential for growing systems, introduces key metrics such as response time and concurrency, outlines systematic thinking and concrete techniques—including caching, parallelism, and async processing—and demonstrates a live‑streaming case study with actionable solutions.

Scalabilitycachingconcurrency
0 likes · 15 min read
Mastering System Performance: Metrics, Strategies, and Real‑World Implementation
Open Source Linux
Open Source Linux
Apr 11, 2024 · Operations

7 Practical Linux Performance Optimization Techniques Every Engineer Should Know

This article consolidates community‑sourced Linux performance optimization practices, covering key factors that affect system speed, rapid troubleshooting steps for CPU, memory, disk and network issues, load‑analysis methods, top‑resource identification commands, memory‑stat nuances, swap usage scenarios, and detailed TCP tuning recommendations.

LinuxTCPoptimization
0 likes · 20 min read
7 Practical Linux Performance Optimization Techniques Every Engineer Should Know
DeWu Technology
DeWu Technology
Apr 10, 2024 · Frontend Development

Frontend Performance Optimization for Transaction Backend

The article details a micro‑frontend transaction backend case study where code‑splitting, CDN delivery, caching, lazy‑loading, and idle‑time loading reduced first‑screen JavaScript size, cut FCP below one second and LCP below two seconds, and improved first‑screen open rate by 15% while halving TTI.

Webfrontendmicrofrontend
0 likes · 9 min read
Frontend Performance Optimization for Transaction Backend
macrozheng
macrozheng
Apr 10, 2024 · Backend Development

18 Proven Strategies to Supercharge Backend API Performance

This article shares a comprehensive set of practical techniques—including batch processing, asynchronous handling, caching, prefetching, pooling, event callbacks, parallel calls, lock granularity, pagination fixes, indexing, SQL tuning, transaction management, and system‑level tweaks—to dramatically reduce API latency and improve overall backend throughput.

optimization
0 likes · 19 min read
18 Proven Strategies to Supercharge Backend API Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries

This article analyzes a slow NOT IN subquery that OceanBase rewrites into a NESTED‑LOOP ANTI JOIN, explains why HASH ANTI JOIN is not chosen due to NULL‑sensitive semantics and missing NOT NULL constraints, compares the behavior with Oracle's Null‑Aware Anti Join, and provides practical rewrite and hint‑based optimization recommendations.

Anti JoinOceanBaseOracle
0 likes · 17 min read
Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Mar 26, 2024 · Frontend Development

Zustand Best Practices: Optimization, Persistence, Debugging, and Multi‑Instance Management

This article shares practical insights and best‑practice techniques for using the Zustand state‑management library in React, covering component re‑render optimization, selective persistence, debugging with dev‑tools, handling multiple store instances, custom selectors, and a Vite plugin for automatic selector injection.

PersistenceReactState Management
0 likes · 13 min read
Zustand Best Practices: Optimization, Persistence, Debugging, and Multi‑Instance Management
Top Architect
Top Architect
Mar 25, 2024 · Backend Development

Backend Interface Performance Optimization: Common Issues and Practical Solutions

This article summarizes the typical causes of slow backend interfaces—such as MySQL slow queries, complex business logic, thread‑pool misconfiguration, lock contention and machine‑level problems—and provides concrete optimization techniques, code examples, and best‑practice recommendations for Java services.

Backendcachingoptimization
0 likes · 20 min read
Backend Interface Performance Optimization: Common Issues and Practical Solutions
Liangxu Linux
Liangxu Linux
Mar 21, 2024 · Frontend Development

How to Understand and Reduce Web Latency: Practical Tips for Faster Apps

This article explains what latency is, how it occurs in web interactions, the main factors that contribute to it, common tools for measuring it, and a set of practical optimization techniques such as HTTP/2, CDN usage, caching, and efficient coding practices.

LatencyWeb Performancefrontend
0 likes · 8 min read
How to Understand and Reduce Web Latency: Practical Tips for Faster Apps
JD Retail Technology
JD Retail Technology
Mar 14, 2024 · Frontend Development

Performance Optimization of JD Star Store Mini‑Program: Practices, Results, and Future Outlook

This article details how JD Retail's technology team identified performance bottlenecks in the Star Store mini‑program, applied systematic monitoring, daily walkthroughs, and targeted code, packaging, and rendering optimizations—reducing JS error rates by 81%, cutting page load times by up to 28% and shrinking bundle size by nearly 10%—and outlines future plans for continued user‑experience improvements.

jsmini-programoptimization
0 likes · 14 min read
Performance Optimization of JD Star Store Mini‑Program: Practices, Results, and Future Outlook
Go Development Architecture Practice
Go Development Architecture Practice
Mar 14, 2024 · Backend Development

How to Process One Billion CSV Rows in Go: 9 Optimized Solutions

This article walks through nine progressively faster Go implementations for the One Billion Row Challenge, detailing baseline measurements, map optimizations, custom parsing, integer arithmetic, scanner removal, custom hash tables, and parallel processing that ultimately reduce processing time from 1 minute 45 seconds to under 4 seconds.

1BRCconcurrencyhash table
0 likes · 20 min read
How to Process One Billion CSV Rows in Go: 9 Optimized Solutions
Open Source Tech Hub
Open Source Tech Hub
Mar 12, 2024 · Backend Development

How I Cut a 1‑Billion‑Row PHP Parser from 25 Minutes to 27 Seconds

This article walks through a step‑by‑step performance engineering journey for the 1 billion‑row challenge in PHP, starting with a naïve CSV parser, replacing fgetcsv with fgets, applying reference operators, type casting, enabling JIT, and finally using multithreaded parallel processing to shrink runtime from 25 minutes to under 30 seconds.

1BRCJITParallel
0 likes · 13 min read
How I Cut a 1‑Billion‑Row PHP Parser from 25 Minutes to 27 Seconds
Selected Java Interview Questions
Selected Java Interview Questions
Mar 11, 2024 · Databases

Key MySQL Interview Questions and Answers: Joins, Indexes, Transactions, and Optimization

This article provides a comprehensive overview of essential MySQL interview topics, covering join types, differences among DROP, DELETE, TRUNCATE, UNION vs UNION ALL, CHAR vs VARCHAR, transaction properties and isolation levels, database normalization, index types and usage, query execution flow, storage engine differences, and practical SQL optimization techniques.

SQLindexoptimization
0 likes · 20 min read
Key MySQL Interview Questions and Answers: Joins, Indexes, Transactions, and Optimization
High Availability Architecture
High Availability Architecture
Mar 6, 2024 · Backend Development

Performance Optimization Techniques: Replacing Protobuf with C++ Classes, Cache‑Friendly Structures, jemalloc, and Lock‑Free Designs

This article presents practical performance‑optimization strategies for high‑throughput C++ services, including replacing Protobuf with hand‑written classes, adopting cache‑friendly data structures, using jemalloc/tcmalloc instead of the default allocator, employing lock‑free double‑buffer designs, tailoring data formats for specific workloads, and leveraging profiling tools to measure gains.

CCache FriendlyProtobuf
0 likes · 17 min read
Performance Optimization Techniques: Replacing Protobuf with C++ Classes, Cache‑Friendly Structures, jemalloc, and Lock‑Free Designs
MaGe Linux Operations
MaGe Linux Operations
Feb 14, 2024 · Operations

Master Linux Performance: Key Factors and Essential Optimization Tools

This article examines the various hardware and OS resources that affect Linux performance—including CPU, memory, disk I/O, and network bandwidth—then details practical optimization techniques and essential monitoring tools such as vmstat, iostat, free, sar, and netstat to diagnose and improve system efficiency.

LinuxSysadminmonitoring
0 likes · 16 min read
Master Linux Performance: Key Factors and Essential Optimization Tools
DataFunSummit
DataFunSummit
Feb 11, 2024 · Artificial Intelligence

GPU-Accelerated Model Service and Optimization Practices at Xiaohongshu

This article details Xiaohongshu's end‑to‑end GPU‑based transformation of its recommendation and search models, covering background, model characteristics, training and inference frameworks, system‑level and GPU‑level optimizations, compilation tricks, hardware upgrades, and future directions for large‑scale machine‑learning infrastructure.

GPUModel ServingTraining
0 likes · 18 min read
GPU-Accelerated Model Service and Optimization Practices at Xiaohongshu
Python Programming Learning Circle
Python Programming Learning Circle
Feb 5, 2024 · Fundamentals

Performance Comparison of Python while and for Loops and Faster Alternatives

This article analyzes why Python's while and for loops are relatively slow, benchmarks their execution times with timeit, demonstrates how additional operations further degrade performance, and shows that using built‑in functions like sum or a direct mathematical formula can accelerate the same computation by orders of magnitude.

LoopsSumfundamentals
0 likes · 8 min read
Performance Comparison of Python while and for Loops and Faster Alternatives
JD Tech
JD Tech
Feb 5, 2024 · Frontend Development

Systematic Performance Optimization of JD Shopping Mini Program for Billion‑User Scale

This article details how JD's massive‑scale shopping mini program achieved a two‑fold performance boost through systematic front‑end optimizations—including code‑package reduction, independent sub‑packages, async loading, pre‑download, selective code injection, first‑screen rendering tricks, and release‑frequency management—providing practical guidance for developers targeting large‑user bases.

JDMini ProgramWeChat
0 likes · 13 min read
Systematic Performance Optimization of JD Shopping Mini Program for Billion‑User Scale
JD Tech
JD Tech
Jan 31, 2024 · Frontend Development

Performance Optimization Practices for JD's Tongtian Tower Frontend Project

This article shares the 2023 performance‑optimization experience of JD's Tongtian Tower front‑end project, explaining how reducing page load time, improving interaction response, and applying systematic analysis tools and best‑practice techniques can boost first‑screen speed by nearly 60 % while maintaining stable, iterative development.

bundle-analysiscachingfrontend
0 likes · 20 min read
Performance Optimization Practices for JD's Tongtian Tower Frontend Project
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jan 18, 2024 · Frontend Development

Comprehensive Guide to Front-End Performance Optimization

This article systematically outlines common front‑end performance optimization techniques, explains key web performance metrics such as Speed Index, FCP, CLS, LCP and TBT, and provides practical strategies for resource compression, network and code optimization, as well as monitoring and measurement best practices.

Resource Compressionmonitoringnetwork
0 likes · 20 min read
Comprehensive Guide to Front-End Performance Optimization
360 Smart Cloud
360 Smart Cloud
Jan 15, 2024 · Big Data

Design and Optimization of the Ozone Distributed Object Storage System

This article presents a comprehensive overview of Ozone, a Hadoop‑based distributed object storage system, detailing its architecture, metadata management, scalability enhancements, small‑file handling, erasure coding, lifecycle policies, and future improvements aimed at boosting performance and reliability for large‑scale unstructured data workloads.

Big DataDistributed SystemsHadoop
0 likes · 15 min read
Design and Optimization of the Ozone Distributed Object Storage System
Java Tech Enthusiast
Java Tech Enthusiast
Jan 13, 2024 · Databases

Understanding MySQL COUNT() Performance and Optimization Strategies

The article explains why counting rows in large MySQL tables—especially with InnoDB—can become slow, compares COUNT() performance across storage engines and query forms, and offers optimization tactics such as using metadata counts, EXPLAIN estimates, a dedicated counting table, or periodic batch processing for accurate or approximate results.

InnoDB_countdatabase
0 likes · 12 min read
Understanding MySQL COUNT() Performance and Optimization Strategies
JD Retail Technology
JD Retail Technology
Jan 12, 2024 · Frontend Development

Front‑End Performance Optimization: Lessons from a Year of Improving First‑Page Load Speed by 58.8%

This article details a year‑long front‑end performance optimization effort for the Tongtian Tower project, covering analysis tools, caching strategies, code splitting, lazy loading, and business‑logic refinements that together delivered a 58.8% reduction in first‑screen load time.

CDNlazy loadingnetwork analysis
0 likes · 17 min read
Front‑End Performance Optimization: Lessons from a Year of Improving First‑Page Load Speed by 58.8%
Python Programming Learning Circle
Python Programming Learning Circle
Jan 5, 2024 · Fundamentals

Python Code Optimization Techniques for Faster Execution

This article presents practical Python performance‑boosting techniques, covering fundamental optimization principles, avoiding global variables and unnecessary attribute access, reducing data copying, improving loop structures, leveraging short‑circuit logic, using numba JIT compilation, and selecting appropriate built‑in data structures to achieve significant speed gains.

best-practicescodeoptimization
0 likes · 15 min read
Python Code Optimization Techniques for Faster Execution
Tencent Cloud Developer
Tencent Cloud Developer
Jan 4, 2024 · Backend Development

High‑Performance Go Programming: Benchmarks, Profiling, and Optimization Techniques

The article shows how to write high‑performance Go code by spotting bottlenecks, using go‑test benchmarks and pprof profiling, and applying optimizations such as avoiding reflection, preferring strong‑type conversions, selecting appropriate map implementations, zero‑allocation string/slice tricks, efficient loops, generics, stack allocation, data alignment, pre‑allocation, and suitable lock primitives.

BenchmarkGoProfiling
0 likes · 34 min read
High‑Performance Go Programming: Benchmarks, Profiling, and Optimization Techniques
DataFunSummit
DataFunSummit
Dec 31, 2023 · Artificial Intelligence

Intelligent Supply Chain Transformation: From Zero to One and Beyond – Concepts, Technologies, and Case Studies

The article examines how cutting‑edge technologies such as machine learning and operations research can reshape consumer‑retail supply chains, outlining a four‑part framework that covers company background, the evolution from basic to intelligent supply chains, acceleration strategies, and real‑world best‑practice case studies.

AICase StudyDemand Forecasting
0 likes · 20 min read
Intelligent Supply Chain Transformation: From Zero to One and Beyond – Concepts, Technologies, and Case Studies
Alibaba Terminal Technology
Alibaba Terminal Technology
Dec 27, 2023 · Frontend Development

Cut Page Load to 1 Second: Frontend Performance Strategies for Feitian Service Platform

Facing heavy load times on the Feitian Service Platform’s customizable homepage, the team applied a three‑stage front‑end performance overhaul—shrinking resources, prioritizing critical paths with progressive loading, and leveraging caching via SWR and Service Workers—resulting in sub‑second page renders and a smoother user experience.

Webcachingfrontend
0 likes · 11 min read
Cut Page Load to 1 Second: Frontend Performance Strategies for Feitian Service Platform
DataFunSummit
DataFunSummit
Dec 26, 2023 · Artificial Intelligence

Applying Causal Inference Tools for Growth Scenarios in Industry

This article explains why causal inference tools are essential for industrial growth, outlines data‑flow standards such as randomized controlled trials, discusses model selection including causal forests and policy learning, and describes evaluation, offline simulation, and resource‑constrained optimization for deploying causal models in production.

AIModel Selectioncausal forest
0 likes · 12 min read
Applying Causal Inference Tools for Growth Scenarios in Industry
DataFunSummit
DataFunSummit
Dec 23, 2023 · Big Data

Common Optimization Points in Building a User Portrait Platform

The presentation by Zhang Xinglong, head of the user understanding center's portrait platform backend, outlines the platform's overall architecture, core module optimizations, advanced crowd creation techniques, bitmap usage, and industry trends, helping the audience understand platform importance, performance improvements, and future directions.

BackendDistributed Systemsoptimization
0 likes · 3 min read
Common Optimization Points in Building a User Portrait Platform
Tencent Music Tech Team
Tencent Music Tech Team
Dec 19, 2023 · Mobile Development

Understanding and Optimizing Android Jank (Lag) in Mobile Applications

The article explains Android jank, defines Google and PerfDog metrics, identifies direct and indirect causes, recommends profiling tools such as Systrace, Perfetto and APM, and details a Wesing case study where breaking tasks, lazy loading, view‑hierarchy reduction and thread off‑loading cut PerfDog jank by roughly half, concluding with a checklist for systematic detection and mitigation.

AndroidJankMemory
0 likes · 13 min read
Understanding and Optimizing Android Jank (Lag) in Mobile Applications
JD Retail Technology
JD Retail Technology
Dec 18, 2023 · Frontend Development

Performance Optimization of JD LBS Store Detail Mini‑Program: Startup, Interaction, Energy, and Tracking Improvements

The JD LBS store‑detail mini‑program team tackled slow page loads, poor scrolling, cart lag, inaccurate tracking and high energy consumption through a series of frontend optimizations—including asynchronous info loading, on‑demand code injection, package slimming, gesture handling, and energy‑saving measures—resulting in roughly 50% faster startup, a 90 health score, 10% crash reduction and tracking reliability above 95%.

Energymini-programoptimization
0 likes · 19 min read
Performance Optimization of JD LBS Store Detail Mini‑Program: Startup, Interaction, Energy, and Tracking Improvements