BestHub
Sign in
Tagged articles

Optimization

1054 articles · Page 1 of 11
Machine Learning Algorithms & Natural Language Processing
Machine Learning Algorithms & Natural Language Processing
Oct 7, 2026 · Artificial Intelligence

Dream-RSI: Google DeepMind's Recursive Self-Improvement via Evolving Worlds Cuts Compute by Orders of Magnitude

Google DeepMind's Dream-RSI introduces a recursive self-improvement framework that treats historical exploration data as an offline simulator to evolve search strategies, reducing compute costs by 1-2 orders of magnitude across algorithm engineering, mathematical optimization, and GPU kernel generation tasks.

AI agentsCode GenerationDream-RSI
0 likes · 17 min read
Dream-RSI: Google DeepMind's Recursive Self-Improvement via Evolving Worlds Cuts Compute by Orders of Magnitude
Machine Learning Algorithms & Natural Language Processing
Machine Learning Algorithms & Natural Language Processing
Aug 1, 2026 · Artificial Intelligence

Deconstructing Scaling Laws: The Interplay of Optimization, Architecture, and Data

The article breaks down large‑scale neural‑network training into three error components—data, optimization, and architecture—derives a heterogeneous power inequality, and uses it to analyze optimal learning rates, batch sizes, model size, sparsity, and data scaling, linking the results to known laws such as Kaplan, Chinchilla, Step, Microsoft, and DeepSeek.

Optimizationdata efficiencydeep learning
0 likes · 28 min read
Deconstructing Scaling Laws: The Interplay of Optimization, Architecture, and Data
Raymond Ops
Raymond Ops
Jul 18, 2026 · Fundamentals

Why TCP BDP Is the Hidden Killer of Network Latency

The article explains the concept of Bandwidth‑Delay Product (BDP), why an undersized TCP window throttles high‑bandwidth links, and provides step‑by‑step diagnostics, scripts, and practical Linux tuning methods—including window scaling, congestion‑control selection, and real‑world case studies—to eliminate BDP‑related performance bottlenecks.

BDPLinuxOptimization
0 likes · 31 min read
Why TCP BDP Is the Hidden Killer of Network Latency
Architect's Tech Stack
Architect's Tech Stack
Jul 16, 2026 · Databases

Still Using IN and NOT IN in SQL? Here’s Why You Should Think Twice

The article explains that IN is fine for small constant lists, but NOT IN can produce unexpected empty results when NULL values appear, while EXISTS (or NOT EXISTS) often better expresses existence checks; it also stresses the decisive role of proper indexing and using EXPLAIN to verify performance.

NOT INNULLOptimization
0 likes · 10 min read
Still Using IN and NOT IN in SQL? Here’s Why You Should Think Twice
MaGe Linux Operations
MaGe Linux Operations
Jul 8, 2026 · Operations

How I Optimized Nginx to Double My Site’s Concurrency

The article walks through a systematic Nginx performance tuning process that starts with baseline load testing, identifies bottlenecks in worker processes, connection limits, I/O and buffering, and applies targeted configuration changes—such as auto workers, keep‑alive tuning, gzip, and proxy buffers—resulting in a three‑fold increase in concurrent request handling.

LinuxLoad TestingNginx
0 likes · 31 min read
How I Optimized Nginx to Double My Site’s Concurrency
Qborfy AI
Qborfy AI
Jul 2, 2026 · Artificial Intelligence

How Streaming Responses and Performance Tuning Boost LLM API Production

This advanced guide explains why real‑world LLM deployments must focus on user‑perceived latency, streaming chunk handling, timeout and retry strategies, concurrency, batch processing, token optimization, caching, and observability rather than just model accuracy.

APILLMOptimization
0 likes · 23 min read
How Streaming Responses and Performance Tuning Boost LLM API Production
DataFunTalk
DataFunTalk
Jun 21, 2026 · Big Data

How Zhihu Optimized Spark Jobs with Gluten: A Practical Deep‑Dive

This article details Zhihu's end‑to‑end experience of migrating Spark SQL workloads to the open‑source Gluten framework, covering background performance benchmarks, the architecture of Gluten and Velox, consistency and performance challenges encountered during migration, the concrete fixes applied, and the resulting resource savings and future plans.

GlutenOptimizationPerformance
0 likes · 22 min read
How Zhihu Optimized Spark Jobs with Gluten: A Practical Deep‑Dive
Deepin Linux
Deepin Linux
Jun 9, 2026 · Fundamentals

Why Is CPU Computation Lightning‑Fast While Data Lookup So Slow?

CPU arithmetic runs at near‑physical limits because all operations stay on‑chip, but data lookup is throttled by three physical bottlenecks—storage hierarchy, data placement, and addressing rules—forcing the processor to wait for cache, memory or disk transfers and dramatically reducing overall system throughput.

CPUOptimizationPerformance
0 likes · 18 min read
Why Is CPU Computation Lightning‑Fast While Data Lookup So Slow?
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jun 3, 2026 · Backend Development

15 Golden Rules for High‑Performance, Maintainable Java Code

This article presents fifteen concrete Java performance‑optimization rules—from readable code and proper data structures to efficient string handling, database access, caching, multithreading, reflection, JVM tuning, and memory management—each illustrated with before/after code examples and practical advice.

JVMJavaOptimization
0 likes · 14 min read
15 Golden Rules for High‑Performance, Maintainable Java Code
Weekly Large Model Application
Weekly Large Model Application
May 28, 2026 · Artificial Intelligence

Open-Source ASR Optimization: Solving Misrecognition of Proper Nouns and Real-Time Lag

This guide analyzes common deployment problems of open‑source speech‑recognition models—misrecognizing proper nouns and lagging behind spoken input—and presents a decision‑tree‑based, five‑layer optimization framework that balances accuracy and speed through concrete techniques such as hot‑word bias, model fine‑tuning, INT8 quantization, and appropriate runtimes.

ASROptimizationaccuracy
0 likes · 10 min read
Open-Source ASR Optimization: Solving Misrecognition of Proper Nouns and Real-Time Lag
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 25, 2026 · Databases

11 Golden Rules for SQL Performance Optimization

This article explains why inefficient SQL queries cause most database bottlenecks and presents eleven concrete rules—covering indexes, SELECT *, LIMIT, WHERE clause tuning, join strategies, execution‑plan analysis, subqueries, DISTINCT, ORDER BY/GROUP BY, UNION vs UNION ALL, and query decomposition with materialized views—to help developers systematically improve SQL execution speed on MySQL and Oracle.

MySQLOptimizationOracle
0 likes · 16 min read
11 Golden Rules for SQL Performance Optimization
DeepHub IMBA
DeepHub IMBA
May 22, 2026 · Fundamentals

Inside Python’s Automatic Memory Management: Core Mechanisms and Optimization Guide

The article breaks down Python’s memory system layer by layer, explaining stack vs. heap, reference counting, generational garbage collection, the true effect of the del statement, built‑in optimizations like integer caching, string interning and __slots__, and shows how to process a 20 GB CSV efficiently with generators.

OptimizationPythonReference Counting
0 likes · 12 min read
Inside Python’s Automatic Memory Management: Core Mechanisms and Optimization Guide
dbaplus Community
dbaplus Community
May 21, 2026 · Databases

Is count(*) Really the Slowest? MySQL COUNT Performance Debunked

The article explains how MySQL implements COUNT(1), COUNT(*), COUNT(primary_key) and COUNT(column), showing that COUNT(*) and COUNT(1) have identical performance, COUNT(column) is the slowest, and provides indexing and approximation tips for large InnoDB tables.

COUNTInnoDBMySQL
0 likes · 9 min read
Is count(*) Really the Slowest? MySQL COUNT Performance Debunked
MaGe Linux Operations
MaGe Linux Operations
May 19, 2026 · Databases

How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds

This article walks through a real‑world MySQL slow‑query case, showing how to identify the bottleneck with EXPLAIN, design covering and composite indexes, rewrite the SQL, tune InnoDB parameters, and safely deploy the changes, ultimately shrinking execution time from seconds to a few milliseconds.

EXPLAINMySQLOptimization
0 likes · 32 min read
How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds
Machine Heart
Machine Heart
May 18, 2026 · Artificial Intelligence

How LLMs Raised the Steiner Ratio Lower Bound to 0.8559, Closing in on the Gilbert‑Pollak Conjecture

A team from Peking University built an LLM‑driven framework that iteratively generates verification functions and uses a reward model with divide‑and‑conquer to improve the planar Steiner ratio from the long‑standing lower bound of 0.824 to 0.8559, a result accepted at ICML 2026 and verified by human experts.

Gilbert‑Pollak conjectureLLMMathematical AI
0 likes · 9 min read
How LLMs Raised the Steiner Ratio Lower Bound to 0.8559, Closing in on the Gilbert‑Pollak Conjecture
Tencent Architect
Tencent Architect
May 11, 2026 · Backend Development

How Adding Two Brackets Made a Django API 8× Faster: A Real‑World Performance Debugging Tale

When a high‑traffic Django endpoint that returned a 7 MB JSON payload slowed dramatically, the author traced the bottleneck to a misuse of StreamingHttpResponse that iterated over the response string character‑by‑character, and fixing it with a simple list wrapper or HttpResponse yielded up to an eight‑fold speedup.

DjangoJSONORM
0 likes · 17 min read
How Adding Two Brackets Made a Django API 8× Faster: A Real‑World Performance Debugging Tale
Goodme Frontend Team
Goodme Frontend Team
May 11, 2026 · Artificial Intelligence

How Agent Skills Accelerate Backend Page Development with Claude

The article explains the concept of Agent Skills, compares them with the Model Context Protocol (MCP), and details a step‑by‑step workflow for creating and optimizing skills to generate middle‑office pages, highlighting challenges such as token consumption, code redundancy, and component matching, and presenting concrete solutions that halve generation time while improving code quality and maintainability.

AI code generationAgent SkillsBackend Development
0 likes · 16 min read
How Agent Skills Accelerate Backend Page Development with Claude
Deepin Linux
Deepin Linux
May 6, 2026 · Fundamentals

Master Linux Memory Performance: From Theory to Real‑World Optimization

This article systematically breaks down Linux's core memory mechanisms, identifies common performance bottlenecks, and demonstrates how to use tools like numastat, perf, and Valgrind together with kernel parameters such as swappiness and min_free_kbytes to achieve practical memory optimizations.

HugePagesKernelLinux
0 likes · 55 min read
Master Linux Memory Performance: From Theory to Real‑World Optimization
Data Party THU
Data Party THU
Apr 28, 2026 · Artificial Intelligence

Mathematicians Declare an AI Turning Point in Mathematics

The article surveys recent observations from leading mathematicians who report that AI breakthroughs—ranging from solving most IMO problems in 2025 to accelerating research with systems like AlphaEvolve—signal a decisive turning point in how mathematics is explored, proved, and taught.

AIAlphaEvolveOptimization
0 likes · 14 min read
Mathematicians Declare an AI Turning Point in Mathematics
Ops Community
Ops Community
Apr 19, 2026 · Databases

How to Diagnose and Resolve MySQL CPU Spikes: A Complete Step‑by‑Step Guide

This guide walks you through identifying why MySQL CPU usage jumps, from confirming the MySQL process consumes CPU to checking connection counts, slow queries, lock waits, configuration settings, and business‑level traffic, and then provides short‑term mitigations and long‑term solutions such as read‑write splitting, sharding, and caching.

CPUMySQLOptimization
0 likes · 17 min read
How to Diagnose and Resolve MySQL CPU Spikes: A Complete Step‑by‑Step Guide
AI Waka
AI Waka
Mar 23, 2026 · Operations

Solving Nonlinear Programs with Piecewise‑Linear Approximation in Gurobi

This article explains how to transform separable nonlinear programming models into piecewise‑linear (PWL) approximations, use SOS‑type 2 constraints, and implement the whole workflow in Python with Gurobi, illustrating the method with a portfolio‑selection example and showing how breakpoint refinement improves solution accuracy.

GurobiOptimizationPython
0 likes · 15 min read
Solving Nonlinear Programs with Piecewise‑Linear Approximation in Gurobi
Architecture & Thinking
Architecture & Thinking
Mar 18, 2026 · Databases

10 Common MySQL Index Failure Scenarios and How to Fix Them

Even well‑designed indexes can become ineffective in production, leading to full‑table scans; this article systematically examines ten typical MySQL index‑failure cases—ranging from functions on indexed columns to low selectivity—and provides concrete SQL rewrites, performance comparisons, and diagnostic tools to help developers avoid and resolve these issues.

MySQLOptimizationPerformance
0 likes · 17 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2026 · Databases

When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation

This article explains why using SELECT * does not automatically invalidate MySQL indexes, explores common scenarios that cause index loss such as left‑most prefix violations, function calls, implicit type conversions, wildcard LIKE patterns, OR/IN/NOT IN misuse, and ORDER BY pitfalls, and provides practical optimization recommendations with concrete SQL examples and verification methods.

MySQLOptimizationQuery Tuning
0 likes · 14 min read
When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation
DataFunTalk
DataFunTalk
Mar 11, 2026 · Artificial Intelligence

Agent Lightning: Decoupling Optimizers to Empower AI Agents via Reinforcement Learning

Agent Lightning, an open‑source system from Microsoft Research Asia, introduces a novel optimizer‑agent disaggregation architecture that enables any AI agent to benefit from reinforcement learning, offering non‑intrusive experience capture, programmable pipelines, and flexible signal passing, while addressing real‑world challenges of scalability, multi‑step tasks, and zero‑code integration.

Agent LightningExperience CaptureLearning Systems
0 likes · 21 min read
Agent Lightning: Decoupling Optimizers to Empower AI Agents via Reinforcement Learning
Deepin Linux
Deepin Linux
Mar 8, 2026 · Operations

How to Supercharge Linux UDP Receive Performance: Kernel Tweaks and Code Optimizations

This article dissects the Linux kernel's UDP receive path, identifies key bottlenecks such as small socket buffers, system‑call overhead, interrupt storms, and application‑level processing limits, and then presents concrete kernel parameter tweaks, memory‑pool designs, multithreaded I/O, and SO_REUSEPORT techniques with full C code examples to dramatically boost throughput and reduce packet loss.

KernelLinuxNetworking
0 likes · 34 min read
How to Supercharge Linux UDP Receive Performance: Kernel Tweaks and Code Optimizations
Big Data Technology Tribe
Big Data Technology Tribe
Mar 1, 2026 · Backend Development

How Ray Data Turns Logical Plans into Executable Workflows – A Deep Dive

This article provides a comprehensive, step‑by‑step explanation of Ray Data's LogicalPlan architecture, covering its class hierarchy, core methods, logical operators, optimization rules, planning from logical to physical operators, execution binding, metadata inference, lineage serialization, and the full file/module index for developers building scalable data pipelines.

BackendLogicalPlanOptimization
0 likes · 35 min read
How Ray Data Turns Logical Plans into Executable Workflows – A Deep Dive
PaperAgent
PaperAgent
Feb 22, 2026 · Artificial Intelligence

How Skipping 50% of Gradient Updates Supercharges LLM Training (SkipUpdate & Magma)

A recent Google‑Northwestern study reveals that randomly discarding half of parameter updates during training—implemented as the SkipUpdate strategy—consistently outperforms dense optimizers across Llama models, and its extension Magma adds momentum‑gradient alignment to achieve further gains, offering a zero‑overhead, geometry‑aware regularization for large‑scale LLMs.

MagmaOptimizationSkipUpdate
0 likes · 9 min read
How Skipping 50% of Gradient Updates Supercharges LLM Training (SkipUpdate & Magma)
Senior Xiao Ying
Senior Xiao Ying
Feb 18, 2026 · Databases

Beyond SELECT: Creating, Optimizing, and Securing MySQL Views and Materialized Views

This article explains MySQL view fundamentals, outlines update limitations, demonstrates INSTEAD OF triggers and stored procedures as workarounds, details two methods for simulating materialized views—including scheduled table refreshes and trigger‑based real‑time updates—covers optimization techniques, and shows role‑based permission management for both regular and materialized views.

Materialized ViewsMySQLOptimization
0 likes · 13 min read
Beyond SELECT: Creating, Optimizing, and Securing MySQL Views and Materialized Views
Java Tech Enthusiast
Java Tech Enthusiast
Feb 16, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents eleven practical MySQL advanced techniques—including execution‑plan analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—each explained with real‑world examples, code snippets, and performance caveats to help developers move from basic usage to mastery.

MySQLOptimizationSQL
0 likes · 20 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
Raymond Ops
Raymond Ops
Feb 13, 2026 · Operations

10 Proven Nginx Tweaks to Turn Your Server from Slow to Lightning Fast

This guide presents ten practical Nginx optimization techniques—from worker process tuning and connection handling to gzip compression, static file caching, load balancing, security hardening, and HTTP/2/SSL tweaks—illustrated with configuration snippets, real‑world pitfalls, monitoring scripts, and future‑proof recommendations for high‑traffic, cloud‑native environments.

OperationsOptimization
0 likes · 14 min read
10 Proven Nginx Tweaks to Turn Your Server from Slow to Lightning Fast
MaGe Linux Operations
MaGe Linux Operations
Feb 10, 2026 · Cloud Native

How to Push Ingress Nginx to 100k QPS on a Single Pod – Full‑Stack Performance Tuning Guide

This article walks through a systematic, layer‑by‑layer performance tuning of Ingress Nginx on Kubernetes, covering worker process settings, connection and keep‑alive tuning, buffer and timeout adjustments, SSL/TLS optimizations, load‑balancing algorithms, kernel parameters, logging, rate‑limiting, benchmarking methods, troubleshooting tips, and a migration path to the Gateway API, all validated with real‑world load‑test results that achieve over 100 000 QPS on a 4 CPU/8 GiB pod.

KubernetesOptimizationTLS
0 likes · 40 min read
How to Push Ingress Nginx to 100k QPS on a Single Pod – Full‑Stack Performance Tuning Guide
Top Architect
Top Architect
Feb 1, 2026 · Backend Development

10 Proven Techniques to Supercharge API Performance in Java Backends

This article presents a comprehensive, step‑by‑step guide to optimizing API latency in Java backend services, covering batch processing, asynchronous execution, caching, preprocessing, pooling, parallelization, indexing, transaction management, pagination, SQL tuning, and lock granularity, complete with code examples and diagrams.

APIOptimizationPerformance
0 likes · 13 min read
10 Proven Techniques to Supercharge API Performance in Java Backends
Ray's Galactic Tech
Ray's Galactic Tech
Jan 31, 2026 · Databases

Master Elasticsearch Performance: Practical Production‑Level Optimization Guide

This guide presents a production‑grade, step‑by‑step approach to boost Elasticsearch performance, covering advanced index design, mapping best practices, query and aggregation tuning, JVM and cluster settings, bulk write optimization, monitoring, and real‑world log‑system scenarios with concrete code examples and configuration snippets.

JVMOptimizationPerformance
0 likes · 9 min read
Master Elasticsearch Performance: Practical Production‑Level Optimization Guide
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jan 24, 2026 · Backend Development

10 Hidden Spring Boot 3 Settings to Supercharge Your Application Performance

This article reveals ten hidden Spring Boot 3 configuration tricks—from disabling the whitelabel error page and shrinking Tomcat threads to enabling HTTP/2, tuning HikariCP, caching static assets, and leveraging Actuator metrics—each illustrated with code snippets and practical steps to boost application performance.

Backend DevelopmentConfigurationJava
0 likes · 7 min read
10 Hidden Spring Boot 3 Settings to Supercharge Your Application Performance
php Courses
php Courses
Jan 21, 2026 · Backend Development

How PHP 8 JIT Boosts Laravel Performance: Principles, Benchmarks, and Configuration

This article explains PHP 8's Just‑In‑Time compiler, shows how it can accelerate CPU‑intensive tasks by 20‑40% or more, demonstrates real‑world gains in Laravel applications, provides step‑by‑step enabling and tuning instructions, and discusses the scenarios where JIT is most effective or limited.

BackendJITLaravel
0 likes · 8 min read
How PHP 8 JIT Boosts Laravel Performance: Principles, Benchmarks, and Configuration
dbaplus Community
dbaplus Community
Jan 18, 2026 · Databases

Avoid These Common SQL Performance Pitfalls for Faster Queries

This guide enumerates frequent misconceptions in SQL performance—from over‑indexing and SELECT * misuse to improper transaction handling and outdated monitoring practices—explains why they hurt efficiency, and provides concrete, version‑aware solutions to optimize queries, schema design, and database operations.

MySQLOptimizationPerformance
0 likes · 26 min read
Avoid These Common SQL Performance Pitfalls for Faster Queries
Code Wrench
Code Wrench
Jan 9, 2026 · Backend Development

When Does Zero‑Copy Actually Boost Go Performance? Practical Guidelines

This article examines the real impact of zero‑copy in Go, clarifies when the standard library already provides it, identifies three scenarios where it truly matters, and warns against common misconceptions and pitfalls that can waste effort without improving performance.

NetworkingOptimizationzero-copy
0 likes · 9 min read
When Does Zero‑Copy Actually Boost Go Performance? Practical Guidelines
Woodpecker Software Testing
Woodpecker Software Testing
Jan 8, 2026 · Operations

Comparing Optimized Performance Test Results with ChatGPT Insights

The article presents a detailed comparison of two performance test data sets—covering throughput, response time, CPU, disk, memory, and network metrics—after optimization, with ChatGPT analyzing each metric and offering scenario‑based recommendations for e‑commerce systems, while also mentioning a test‑automation product demo.

ChatGPT analysisJMeterOptimization
0 likes · 19 min read
Comparing Optimized Performance Test Results with ChatGPT Insights
Raymond Ops
Raymond Ops
Jan 6, 2026 · Operations

How to Boost Nginx to Over 1 Million QPS: Real‑World Optimization Guide

This guide walks you through a complete Nginx high‑concurrency tuning process—from basic worker and TCP settings to kernel parameters, caching, SSL, and advanced techniques like DPDK and JIT—showing performance improvements from 80 k to over a million QPS with real‑world examples and scripts.

LinuxNginxOptimization
0 likes · 13 min read
How to Boost Nginx to Over 1 Million QPS: Real‑World Optimization Guide
Ray's Galactic Tech
Ray's Galactic Tech
Jan 2, 2026 · Backend Development

12 Proven Backend Optimization Techniques to Boost API Performance

Explore a comprehensive set of backend performance strategies—including asynchronous processing, multi-level caching, batch operations, and space‑time tradeoffs—detailing typical scenarios, implementation methods, and measurable effects to dramatically improve API response speed, throughput, and system stability.

BackendOptimizationPerformance
0 likes · 8 min read
12 Proven Backend Optimization Techniques to Boost API Performance
Su San Talks Tech
Su San Talks Tech
Dec 30, 2025 · Backend Development

How I Cut Category Tree Load Time from 3 Seconds to 30 Milliseconds

A real‑world performance disaster caused by N+1 queries in a SpringBoot project was solved by replacing recursive database calls with a single batch query, building an in‑memory hash map, and adding multi‑level caching, achieving a 100× speedup and dramatically reducing system load.

N+1OptimizationPerformance
0 likes · 19 min read
How I Cut Category Tree Load Time from 3 Seconds to 30 Milliseconds
JavaScript
JavaScript
Dec 25, 2025 · Frontend Development

Boost JavaScript Async Performance by Up to 80% with Advanced Promise Techniques

This article explains why async/await can introduce performance overhead, then presents four optimized Promise‑based patterns—including chain optimization, Promise.all parallelism, batch processing, and pooling—that can improve JavaScript asynchronous code speed by up to 80% in high‑frequency or large‑scale scenarios.

JavaScriptOptimizationPerformance
0 likes · 5 min read
Boost JavaScript Async Performance by Up to 80% with Advanced Promise Techniques
php Courses
php Courses
Dec 25, 2025 · Backend Development

Boost PHP Performance: Faster Alternatives to count(), array_search() and More

This article presents practical PHP performance tips, showing how to replace count() with strlen(implode()), use in_array() instead of array_search(), free memory with unset(), prefer str_replace() over preg_replace(), and choose mysqli_fetch_assoc() over mysqli_fetch_array(), each illustrated with clear code examples.

BackendOptimizationPerformance
0 likes · 6 min read
Boost PHP Performance: Faster Alternatives to count(), array_search() and More
Su San Talks Tech
Su San Talks Tech
Dec 23, 2025 · Backend Development

How to Crush the One Billion Row Challenge: Java Performance Secrets Revealed

This article walks through the One Billion Row Challenge—parsing a 13 GB file of 1 billion temperature records—by examining the baseline Java solution, analyzing top contestants' results, and detailing a step‑by‑step series of low‑level optimizations (JVM choice, parallel I/O, custom parsing, bespoke hash tables, Unsafe and SWAR techniques) that shrink execution time from minutes to under two seconds.

GraalVMJavaOne Billion Row Challenge
0 likes · 20 min read
How to Crush the One Billion Row Challenge: Java Performance Secrets Revealed
Architect Chen
Architect Chen
Dec 23, 2025 · Databases

Boost MySQL to 10k QPS: Multi‑Layer Optimization Strategies

When MySQL QPS reaches 10,000, common bottlenecks include CPU saturation, low buffer pool hit rate, connection limits, and lock contention, which can be mitigated through internal tuning, cache interception, read‑write splitting, and horizontal sharding.

MySQLOptimizationPerformance
0 likes · 4 min read
Boost MySQL to 10k QPS: Multi‑Layer Optimization Strategies
macrozheng
macrozheng
Dec 8, 2025 · Databases

Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It

This tutorial demonstrates how MySQL LIMIT pagination performs on tables with millions of rows, measures query times for various offsets and batch sizes, and presents practical optimization techniques such as sub‑queries, ID‑range filtering, and column selection to improve speed.

LIMITMySQLOptimization
0 likes · 9 min read
Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It
Ray's Galactic Tech
Ray's Galactic Tech
Dec 7, 2025 · Databases

Mastering MySQL Large-Scale Pagination: Ultimate Optimized Techniques

This article examines why traditional MySQL LIMIT offset pagination degrades performance on massive tables and presents five database‑level solutions plus engineering best practices—including delayed joins, covering indexes, cursor pagination, window functions, and partitioning—to achieve fast, scalable paging.

CursorMySQLOptimization
0 likes · 8 min read
Mastering MySQL Large-Scale Pagination: Ultimate Optimized Techniques
macrozheng
macrozheng
Dec 5, 2025 · Databases

Why UUID Primary Keys Slow Down MySQL and How to Optimize Them

This article explains how using UUIDs as primary keys in MySQL can degrade index efficiency, insert and query performance, and cause costly index refreshes on updates, then presents practical techniques such as ordered UUIDs, binary storage, hybrid keys, and partitioning to mitigate these issues.

MySQLOptimizationPerformance
0 likes · 8 min read
Why UUID Primary Keys Slow Down MySQL and How to Optimize Them
Top Architect
Top Architect
Nov 30, 2025 · Databases

Why UUID Primary Keys Slow Down MySQL and How to Fix Them

Using UUIDs as primary keys in MySQL can severely degrade performance due to larger index size, random insertion order, and costly updates, but the article explains the underlying reasons and offers practical optimizations such as ordered UUIDs, binary storage, hybrid auto‑increment keys, and table partitioning.

MySQLOptimizationUUID
0 likes · 8 min read
Why UUID Primary Keys Slow Down MySQL and How to Fix Them
Deepin Linux
Deepin Linux
Nov 28, 2025 · Backend Development

Boosting C++ Thread Pool Performance: Queue and Memory Optimizations

This article explains why C++ thread pools often hit bottlenecks in high‑concurrency scenarios and provides practical techniques—such as lock‑granularity tuning, lock‑free queues, object‑pool reuse, and pre‑allocation—to improve task scheduling and memory management without relying on external frameworks.

C++OptimizationThread Pool
1 likes · 44 min read
Boosting C++ Thread Pool Performance: Queue and Memory Optimizations
Model Perspective
Model Perspective
Nov 21, 2025 · Fundamentals

How to Use Mathematical Modeling to Optimize Everyday Decisions

This article demonstrates how to apply mathematical modeling techniques—such as knapsack optimization, cost‑benefit analysis, graph shortest‑path algorithms, linear programming for nutrition, portfolio theory, and multi‑criteria decision methods—to improve daily time management, shopping, commuting, health, finance, and overall life choices.

AHPDecision MakingLinear Programming
0 likes · 10 min read
How to Use Mathematical Modeling to Optimize Everyday Decisions
Raymond Ops
Raymond Ops
Nov 18, 2025 · Operations

How to Optimize Linux Server Performance: Monitoring, Tuning, and Resource Management

This guide explains how to identify performance bottlenecks on Linux servers and improve stability by adjusting kernel parameters, using monitoring tools like vmstat, mpstat, iostat, and sar, and applying resource‑limit techniques such as ulimit, PAM, and cgroups across CPU, memory, disk, and network subsystems.

LinuxOptimizationResource Limits
0 likes · 39 min read
How to Optimize Linux Server Performance: Monitoring, Tuning, and Resource Management
Raymond Ops
Raymond Ops
Nov 11, 2025 · Operations

Master Nginx Performance: 20+ Proven Optimization Techniques

This guide provides a comprehensive collection of over twenty Nginx performance tuning methods, covering worker processes, CPU affinity, file descriptor limits, event models, gzip compression, caching, security, and system kernel tweaks to maximize web server efficiency.

ConfigurationNginxOptimization
0 likes · 47 min read
Master Nginx Performance: 20+ Proven Optimization Techniques
AsiaInfo Technology: New Tech Exploration
AsiaInfo Technology: New Tech Exploration
Nov 10, 2025 · Industry Insights

How a Generative AI‑Powered Normative Analysis Framework Boosted Decision Efficiency 20× in a Conversational BI Product

This case study examines a normative analysis framework that combines operations research, statistical learning, and large language models to automate end‑to‑end decision making in a ChatBI product, demonstrating up to 20‑fold efficiency gains, cost reductions, and enhanced interpretability across structured optimization and semi‑structured pricing scenarios.

ChatBIDecision IntelligenceOptimization
0 likes · 20 min read
How a Generative AI‑Powered Normative Analysis Framework Boosted Decision Efficiency 20× in a Conversational BI Product
Model Perspective
Model Perspective
Nov 7, 2025 · Fundamentals

How Math Turns Chinese Dinner Parties into Optimization Puzzles

This article explores how combinatorics, multi‑objective optimization, game theory, Markov chains, and expected‑return models can mathematically describe seating, menu selection, bill‑splitting, optimal group size, and topic flow in traditional Chinese dinner gatherings.

Optimizationcombinatoricsgame theory
0 likes · 9 min read
How Math Turns Chinese Dinner Parties into Optimization Puzzles
Architect Chen
Architect Chen
Nov 6, 2025 · Backend Development

Boost Nginx Performance 10×: Auto CPU Affinity, Epoll, and Zero‑Copy Tweaks

This guide explains how to unleash Nginx's full potential on multi‑core Linux servers by configuring automatic CPU affinity, increasing worker connections with epoll, raising system file limits, and enabling zero‑copy transmission, resulting in up to ten‑fold throughput gains and dramatically lower CPU usage.

EpollOptimizationzero-copy
0 likes · 4 min read
Boost Nginx Performance 10×: Auto CPU Affinity, Epoll, and Zero‑Copy Tweaks
Model Perspective
Model Perspective
Nov 3, 2025 · Fundamentals

Why Mathematical Modeling Can’t Always Cure, But It Always Helps and Comforts

Mathematical modeling, like medicine, occasionally provides perfect solutions, frequently offers valuable insights and improvements, and consistently comforts us by fostering rational thinking, order, and a shared language, reminding us that while flawless cures are rare, useful, pragmatic models are essential in navigating an uncertain world.

Decision SupportOptimizationmathematical modeling
0 likes · 7 min read
Why Mathematical Modeling Can’t Always Cure, But It Always Helps and Comforts
php Courses
php Courses
Oct 28, 2025 · Backend Development

How to Diagnose and Fix PHP Performance Issues Without Restarting

Learn practical techniques to monitor OPcache, adjust PHP‑FPM settings, reset caches, employ preload, and use shared memory caching, enabling you to identify and mitigate PHP performance degradation in production without restarting services, ensuring continuous user experience.

BackendOPcacheOptimization
0 likes · 6 min read
How to Diagnose and Fix PHP Performance Issues Without Restarting
php Courses
php Courses
Oct 24, 2025 · Backend Development

How to Supercharge Laravel Performance: A Step‑by‑Step Optimization Guide

This guide walks you through a systematic Laravel performance optimization process—from diagnosing bottlenecks with Debugbar and logs, through database query tuning, caching strategies, code-level refinements, to server‑level tweaks—ensuring faster response times for growing PHP applications.

LaravelOptimizationPHP
0 likes · 7 min read
How to Supercharge Laravel Performance: A Step‑by‑Step Optimization Guide
Model Perspective
Model Perspective
Oct 20, 2025 · Fundamentals

How to Translate Real-World Problems into Precise Mathematical Models

This article explains the essential challenge of mathematical modeling—converting complex real‑world situations into concise mathematical language—by presenting a systematic "reality‑to‑math dictionary" with conversion rules, examples, and a complete SIR epidemic model illustration.

OptimizationSIR modelSystems
0 likes · 10 min read
How to Translate Real-World Problems into Precise Mathematical Models
Open Source Linux
Open Source Linux
Oct 18, 2025 · Operations

Boost Nginx QPS by 500%: Core Configuration Secrets for Enterprise Performance

This guide details enterprise‑grade Nginx optimization techniques, covering worker process tuning, event model settings, network and buffer adjustments, compression, SSL/TLS hardening, load balancing, caching strategies, monitoring, system‑level tweaks, and troubleshooting steps to dramatically increase request throughput and stability.

NginxOptimizationPerformance
0 likes · 12 min read
Boost Nginx QPS by 500%: Core Configuration Secrets for Enterprise Performance
php Courses
php Courses
Oct 16, 2025 · Backend Development

Boost PHP Performance: Inline Optimization Techniques to Rival C

This article explains how to apply a series of inline optimization strategies—static typing, function inlining, efficient array and string handling, loop refinements, and Opcache preloading—to dramatically improve PHP execution speed and bring its performance close to that of compiled C code.

Backend DevelopmentInlineOPcache
0 likes · 8 min read
Boost PHP Performance: Inline Optimization Techniques to Rival C
Model Perspective
Model Perspective
Oct 7, 2025 · Fundamentals

Unlock Life’s Success: The Three Powers of Cognition, Choice & Growth

This article treats life as an optimization problem and breaks it into three core forces—cognition, choice, and growth—showing how Bayesian inference, multi‑objective optimization, and dynamic system theory can model their interactions, guide decision‑making, and illustrate the feedback loops that drive personal development.

Bayesian inferenceDecision MakingOptimization
0 likes · 8 min read
Unlock Life’s Success: The Three Powers of Cognition, Choice & Growth
Model Perspective
Model Perspective
Oct 6, 2025 · Operations

Modeling Ming Dynasty Politics: Game Theory, Optimization, and System Dynamics

Using multi‑objective optimization, Nash equilibrium analysis, epidemic‑style network models, and optimal control theory, this study quantitatively examines the “change rice to mulberry” policy, bureaucratic power struggles, corruption diffusion, and fiscal crises depicted in the drama “The Ming Dynasty 1566,” revealing underlying mathematical dynamics.

Optimizationcorruption modelinggame theory
0 likes · 11 min read
Modeling Ming Dynasty Politics: Game Theory, Optimization, and System Dynamics
Cognitive Technology Team
Cognitive Technology Team
Oct 3, 2025 · Backend Development

Mastering Kafka Consumer Rebalance: Strategies to Boost Throughput and Stability

This article deeply explores Kafka consumer group rebalance mechanisms, identifies performance pitfalls of frequent rebalances, and provides a comprehensive set of configuration tweaks, assignment strategies, batch processing techniques, and monitoring practices to achieve a more stable and high‑throughput Kafka consumer system.

BackendConsumerKafka
0 likes · 16 min read
Mastering Kafka Consumer Rebalance: Strategies to Boost Throughput and Stability
Model Perspective
Model Perspective
Oct 2, 2025 · Operations

Mathematical Modeling in Modern Warfare: From Lanchester to AI

Modern warfare has evolved into an information‑centric, intelligent contest where mathematical models—ranging from classic Lanchester combat equations and resource allocation optimizations to game‑theoretic and Bayesian approaches—enable commanders to predict battlefield dynamics, allocate firepower, assess situations, and plan optimal paths and strategies.

Artificial IntelligenceOptimizationgame theory
0 likes · 8 min read
Mathematical Modeling in Modern Warfare: From Lanchester to AI
Model Perspective
Model Perspective
Oct 1, 2025 · Operations

Unlock Holiday Efficiency: Mathematical Modeling Tips for Travel, Crowds, and Budgets

This article explores how mathematical modeling techniques—ranging from traveling salesman optimization and multi‑objective planning to ARIMA forecasting, queueing theory, and dynamic programming—can improve National Day holiday travel routes, predict visitor flows, optimize spending, and enhance traffic and safety management.

OptimizationTraffic analysisbudget allocation
0 likes · 13 min read
Unlock Holiday Efficiency: Mathematical Modeling Tips for Travel, Crowds, and Budgets
Alipay Experience Technology
Alipay Experience Technology
Sep 29, 2025 · Artificial Intelligence

How a Constraint-Aware Multi-Agent AI Won the IJCAI‑2025 Travel Planning Challenge

Alipay’s AI research team, together with Ant Group and East China Normal University, leveraged a self‑developed large‑model‑plus‑optimization framework to create a constraint‑aware multi‑agent system that won both the Original OS Track and DSL Track at the IJCAI‑2025 Autonomous Travel Itinerary Planning Competition.

AIMulti-agentOptimization
0 likes · 8 min read
How a Constraint-Aware Multi-Agent AI Won the IJCAI‑2025 Travel Planning Challenge
Tencent Technical Engineering
Tencent Technical Engineering
Sep 26, 2025 · Fundamentals

10 Hidden C++ Performance Traps Every Developer Must Avoid

This article reveals ten common C++ performance pitfalls—from costly abstractions and virtual functions to hidden copies, destructors, and misuse of smart pointers—while also showcasing practical language features and optimization techniques that can dramatically improve runtime efficiency in production code.

C++Optimizationbest practices
0 likes · 28 min read
10 Hidden C++ Performance Traps Every Developer Must Avoid
DevOps Coach
DevOps Coach
Sep 25, 2025 · Fundamentals

Unlock Python Speed: 12 Little‑Known Tricks to Turbocharge Your Code

Python is praised for its clarity but often deemed slow; this article reveals twelve overlooked, sometimes unconventional techniques—from using enumerate instead of range loops to leveraging Numba, Polars, and mypyc—that can dramatically accelerate data pipelines, APIs, and scientific workloads without rewriting code in another language.

OptimizationPolarsProfiling
0 likes · 9 min read
Unlock Python Speed: 12 Little‑Known Tricks to Turbocharge Your Code
Amap Tech
Amap Tech
Sep 25, 2025 · Artificial Intelligence

How Amap Engineers Precise, Real‑Time Intersection Data with AI and Optimization

This article explains how Amap tackles the complex challenge of guiding users safely through diverse intersections by simplifying intersection models, automating topology generation, applying multimodal AI for data updates, and building an AI‑driven navigation agent that delivers accurate, real‑time routing.

AI navigationOptimizationReal-time Updates
0 likes · 8 min read
How Amap Engineers Precise, Real‑Time Intersection Data with AI and Optimization
Model Perspective
Model Perspective
Sep 23, 2025 · Operations

Unlocking the Power of the Checkmark Function: Real-World Optimization Made Simple

The article introduces the checkmark function—a mathematical model where a linear term rises while an inverse term falls, creating a unique minimum—and demonstrates its powerful applications across inventory management, fence design, production batch sizing, and equipment maintenance, highlighting common optimization features.

EOQOptimizationcheckmark function
0 likes · 9 min read
Unlocking the Power of the Checkmark Function: Real-World Optimization Made Simple
Code Wrench
Code Wrench
Sep 22, 2025 · Backend Development

How to Process a 1‑Billion‑Row Text File in Go 30× Faster (3.4 s)

This article walks through a step‑by‑step performance engineering journey that reduces the processing time of a 1 billion‑line, 13 GB text file from 105 seconds to 3.4 seconds in Go by applying custom parsing, bulk I/O, a hand‑rolled hash table, and parallelism.

1BRCOptimizationhash-table
0 likes · 15 min read
How to Process a 1‑Billion‑Row Text File in Go 30× Faster (3.4 s)
Model Perspective
Model Perspective
Sep 21, 2025 · Fundamentals

Why Mathematical Modeling Is the Key to Real-World Problem Solving

Mathematical modeling transforms real-world problems into solvable mathematical structures, offering a problem‑driven, step‑by‑step learning path that builds optimization, probability, and differential equation skills while enhancing abstract thinking, interdisciplinary insight, and practical decision‑making for everyday challenges.

Optimizationinterdisciplinarymathematical modeling
0 likes · 11 min read
Why Mathematical Modeling Is the Key to Real-World Problem Solving
AI Algorithm Path
AI Algorithm Path
Sep 20, 2025 · Fundamentals

Understanding the Hungarian Algorithm and Its Role in Computer Vision

The article explains the Hungarian algorithm’s principles, walks through step‑by‑step matrix reductions and line‑cover adjustments, and demonstrates its use for optimal task assignment and for matching detections in multi‑object tracking, illustrating the process with concrete 4×4 cost‑matrix examples.

Hungarian algorithmOptimizationassignment problem
0 likes · 10 min read
Understanding the Hungarian Algorithm and Its Role in Computer Vision
Model Perspective
Model Perspective
Sep 17, 2025 · Fundamentals

How Physics Shapes the Perfect Basketball Free Throw

This article explores the physics behind basketball free throws, detailing projectile motion, the impact of air resistance, and how optimal launch angles and initial speeds can be determined and refined through mathematical modeling and optimization techniques.

BasketballOptimizationPhysics
0 likes · 7 min read
How Physics Shapes the Perfect Basketball Free Throw
FunTester
FunTester
Sep 17, 2025 · Backend Development

20 Proven Go Performance Optimization Techniques Every Backend Engineer Should Know

This article presents 20 production‑validated Go performance optimization tips, covering profiling, benchmarking, memory management, concurrency, and build‑time strategies, with clear principles and practical code examples to help engineers systematically improve Go application performance.

MemoryOptimizationProfiling
0 likes · 24 min read
20 Proven Go Performance Optimization Techniques Every Backend Engineer Should Know
Tech Freedom Circle
Tech Freedom Circle
Sep 16, 2025 · Backend Development

Redis Fuzzy Search Techniques and the Most Dangerous Commands to Avoid

The article explains how to perform fuzzy queries in Redis using KEYS, SCAN, and collection‑type scans, enumerates commands that can block the single‑threaded server such as KEYS *, HGETALL, LRANGE, and provides practical mitigation strategies like incremental scans, key sharding, and asynchronous deletion.

OptimizationPerformanceRedis
0 likes · 24 min read
Redis Fuzzy Search Techniques and the Most Dangerous Commands to Avoid
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 16, 2025 · Operations

A Comprehensive Guide to Linux Performance Optimization

This article provides an in‑depth, step‑by‑step walkthrough of Linux performance optimization, covering key metrics such as throughput and latency, how to interpret average load, CPU and memory usage, context‑switch analysis, common bottlenecks, and the most effective tools (vmstat, pidstat, perf, strace, dstat, etc.) with concrete command examples and real‑world case studies to help you diagnose and resolve performance issues.

OptimizationPerformancemonitoring
0 likes · 36 min read
A Comprehensive Guide to Linux Performance Optimization
Java Baker
Java Baker
Sep 15, 2025 · Backend Development

Choosing the Right Cache Update Pattern: Cache‑Aside, Write‑Back, Read‑Through

This article systematically compares four cache update patterns—cache‑aside, asynchronous write‑back, read/write‑through, and ongoing optimizations—detailing their implementation steps, suitable scenarios, advantages, drawbacks, and practical tips such as delayed double deletion and proactive cache refreshing to balance performance and consistency.

OptimizationWrite-Backcache-aside
0 likes · 9 min read
Choosing the Right Cache Update Pattern: Cache‑Aside, Write‑Back, Read‑Through
Model Perspective
Model Perspective
Sep 14, 2025 · Artificial Intelligence

How Ant Colony Optimization Solves Complex Routing Problems

This article explains the natural inspiration behind Ant Colony Optimization, its core principles, mathematical modeling, pheromone update rules, convergence behavior, and step‑by‑step workflow, illustrating how simple local interactions enable efficient solutions to combinatorial optimization challenges like the traveling salesman problem.

Optimizationant colony optimizationmetaheuristic
0 likes · 8 min read
How Ant Colony Optimization Solves Complex Routing Problems
Deepin Linux
Deepin Linux
Sep 13, 2025 · Fundamentals

Why the volatile Keyword Matters in C/C++: The Hidden Hero of Concurrency and Hardware

This article explains the purpose, mechanics, and practical use cases of the C/C++ volatile qualifier, showing how it forces memory accesses, prevents harmful compiler optimizations, and ensures correct behavior in multithreaded, interrupt-driven, and hardware‑interfacing programs while also highlighting its limitations and performance impact.

C++HardwareOptimization
0 likes · 32 min read
Why the volatile Keyword Matters in C/C++: The Hidden Hero of Concurrency and Hardware
Architects Research Society
Architects Research Society
Sep 12, 2025 · Backend Development

5 Proven API Performance Hacks for High‑Concurrency Systems

This article presents five practical API performance optimization techniques for high‑concurrency environments, covering pagination with cursor queries, asynchronous logging, multi‑level caching, data compression, and connection‑pool tuning, along with key configuration tips and a golden rule to monitor before optimizing.

APIOptimizationcaching
0 likes · 2 min read
5 Proven API Performance Hacks for High‑Concurrency Systems
Java Backend Technology
Java Backend Technology
Sep 12, 2025 · Backend Development

Avoid Hidden SpringBoot Pitfalls: Optimize Default Configurations for Production

This article reveals how SpringBoot's out‑of‑the‑box defaults—such as Tomcat connection limits, HikariCP pool size, JPA lazy loading, Jackson timezone handling, logging, file upload limits, async thread pools, static resource caching, and transaction timeouts—can cause performance bottlenecks and stability issues in production, and provides concrete configuration recommendations to prevent them.

Optimization
0 likes · 12 min read
Avoid Hidden SpringBoot Pitfalls: Optimize Default Configurations for Production
Model Perspective
Model Perspective
Sep 11, 2025 · Fundamentals

Using Simple Math Models to Tackle Everyday Challenges

This article demonstrates how straightforward mathematical models—ranging from basic calculations for translation time, linear equations for shopping costs, linear programming for work‑life balance, recursive sequences for weight loss, to differential equations for team collaboration—can efficiently analyze and communicate everyday problems.

Optimizationeveryday problemslinear equations
0 likes · 6 min read
Using Simple Math Models to Tackle Everyday Challenges
Architect Chen
Architect Chen
Sep 8, 2025 · Backend Development

Boost Nginx Performance: 10 Proven Configuration Tweaks

This guide explains ten practical Nginx optimizations—including event‑driven handling, worker process tuning, gzip compression, static and dynamic caching, DNS resolver settings, TCP_NODELAY, logging adjustments, request rate limiting, and HTTP/2 activation—to dramatically improve server throughput and latency.

BackendConfigurationOptimization
0 likes · 6 min read
Boost Nginx Performance: 10 Proven Configuration Tweaks
Python Programming Learning Circle
Python Programming Learning Circle
Sep 5, 2025 · Fundamentals

10 Hidden Python Tricks to Supercharge Performance

This article reveals ten often‑overlooked Python performance techniques—from using enumerate and array structures to leveraging Numba, Polars, and generators—showing how careful coding, profiling, and modern libraries can turn sluggish scripts into lightning‑fast production workloads.

OptimizationPerformancePolars
0 likes · 9 min read
10 Hidden Python Tricks to Supercharge Performance