This guide presents twelve practical Hive tuning techniques—including avoiding MapReduce, limiting string concatenation, steering clear of subqueries, choosing the right file formats, managing vectorization, sizing containers, enabling statistics, and optimizing joins—to dramatically improve query speed on Hadoop.
This article presents a comprehensive set of Linux server performance tuning techniques, covering kernel I/O scheduling, daemon management, GUI disabling, module cleanup, control panel removal, network and storage optimizations, filesystem choices, kernel parameter tweaks, and essential monitoring commands to improve efficiency and reliability.
This article examines the performance challenges of Taobao's personalized homepage and presents a series of frontend optimization techniques—including module prioritization, lazy loading, image compression, caching, and smooth rendering—to achieve faster first‑screen loads and smoother scrolling experiences.
This article explains how to accelerate HTTPS access, reduce computational load, and harden security by applying protocol‑level tweaks such as TCP Fast Open, HSTS, session resumption, OCSP stapling, false start, SPDY/HTTP2, as well as practical deployment strategies like full‑site HTTPS, domain planning, connection reuse, and handling common migration issues.
This article examines the various scenarios that cause Redis to block—such as expensive commands, fork‑induced overhead, and persistence operations—and provides practical architectural and configuration solutions to keep the event loop responsive even with large data volumes.
Learn how to dramatically improve front‑end work efficiency by mastering time‑management plans, leveraging essential tools—from editors and Chrome DevTools to automation pipelines—and adopting new technologies like ES6, all illustrated with practical examples and actionable tips.
This article examines MySQL’s InnoDB full‑text indexing from MySQL 5.6 onward, detailing supported search modes, the structure of auxiliary index files, the lifecycle of DML operations, transaction handling, cache synchronization, optimization procedures, background threads, monitoring tables, stop‑word configuration, and the built‑in n‑gram parser.
This article explains MySQL InnoDB full-text indexing, covering supported modes, auxiliary tables, creation, DML handling, query processing, transaction management, cache synchronization, optimization, background threads, monitoring, stopwords, plugins, and the built‑in n‑gram parser, with code references from MySQL 5.7.
This guide explains why MySQL tables become fragmented after deletions, how to check the Data_free value to identify fragmented tables, and which commands to run for MyISAM and InnoDB tables to reclaim space and improve query performance.
This article explains the benefits and drawbacks of performance optimization, distinguishes between single‑application and structural optimization approaches, outlines common steps, tools, and techniques for each, and presents case studies illustrating architectural evolution for improved scalability and stability.
This guide walks through ElasticSearch fundamentals, core concepts, step‑by‑step installation, Python indexing examples, index‑level tuning, and memory‑usage optimizations, providing practical tips for deploying and maintaining a high‑performance search cluster.
By lazily loading avatars, moving critical JavaScript and CSS inline into the head, and deferring secondary screen logic, Tencent’s front‑end team reduced the HandQ group member distribution page’s first‑screen render time, achieving roughly a 20% performance improvement while keeping total inline size under 14 KB.
This article explains practical Swift optimization techniques—including enabling compiler optimizations, whole‑module compilation, reducing dynamic dispatch with final and private, using value types and ContiguousArray, unchecked arithmetic, generic specialization, unmanaged references, and class‑only protocols—to improve runtime speed and binary size for iOS apps.
This article explains iOS's view and animation rendering pipeline, identifies common performance pitfalls such as excessive layers, overdraw, off‑screen drawing, and image decompression, and provides practical optimization techniques using Core Animation and GPU Driver tools.
This article presents a pattern‑based approach to performance optimization, describing common degradation anti‑patterns and corresponding optimization patterns—such as horizontal and vertical partitioning, runtime 3NF, data locality, and degradation—to help engineers improve response time, throughput, and availability in large‑scale backend services.
The article presents a pattern‑based catalog of performance‑optimization techniques—such as horizontal and vertical partitioning, constant‑variable separation, locality, and sandboxing—illustrated with Meituan case studies, explaining motivations, trade‑offs, and how each pattern reduces latency, boosts throughput, and enhances availability in high‑throughput backend systems.
This article explains what browser repaints and reflows are, which operations trigger them, and provides practical techniques—such as batching style changes, using absolute positioning, leveraging document fragments, temporarily hiding elements, and caching values—to dramatically reduce their performance cost.
This article introduces PHP 7.0.0’s major performance enhancements and provides five practical tuning steps—including enabling Opcache, using a newer GCC compiler, activating HugePages, configuring Opcache file cache, and applying profile‑guided optimization—to maximize speed and efficiency for backend applications.
This article outlines seven practical strategies—including monitoring, network upgrades, caching, task grading, lazy loading, page structure refinement, and image download optimization—to significantly improve the launch speed, home page responsiveness, and cart performance of the Mobile Taobao application.
This guide explains how to improve PHP script performance by upgrading the PHP version, leveraging caching and output buffering, avoiding unnecessary getters/setters and variable copies, and replacing per‑iteration SQL queries with batch operations, all illustrated with clear code examples.
This article presents ten actionable techniques—including reverse proxy deployment, load balancing, caching, compression, SSL/TLS optimization, HTTP/2 adoption, Linux tuning, NGINX configuration, and real‑time monitoring—to significantly boost the speed, reliability, and security of web applications.
This article examines why MySQL 5.5/5.6 fails to retrieve non‑null partitioned rows after a physical upgrade, how the ALTER TABLE … PARTITION BY KEY ALGORITHM=1 fix works, the cause of MySQL client crashes when dump output mixes warnings, GTID_PURGED replication bugs, replicate‑filter side effects, and the behavior of TokuDB’s OPTIMIZE TABLE.
The article argues that while performance is important, maintainability is more critical for sustainable software development, illustrating this with anecdotes, common misconceptions about optimization, and practical advice on balancing code readability, caching, and hardware considerations.
This article explains why H5 performance matters, defines the one‑second rule for different network conditions, and provides comprehensive front‑end optimization techniques—including resource loading, image handling, server deployment, code standards, testing tools, and classic case studies—to improve user experience on mobile web applications.
This article examines the rapid growth of mobile traffic at eLong, outlines key front‑end challenges such as code bloat, animation efficiency, and technical debt, and details the framework's server‑side rendering, modular architecture, and modern web‑tech optimizations that improve performance and user experience.
Learn six practical jQuery performance strategies—including appending outside loops, caching array lengths, detaching nodes, checking for empty selections, optimizing selectors, and using stylesheet rules—to dramatically reduce DOM manipulation costs and accelerate page rendering.
The article argues that while programmers obsess over performance gains, maintainability is often more critical, illustrating this with C# LINQ vs Single/First debates, database design pitfalls, and the hidden costs of premature optimization, ultimately urging developers to prioritize readable, maintainable code and measure performance before refactoring.
This guide presents eight practical front‑end optimization methods—including browser choice, static page serving, request reduction, CDN usage, client‑side caching, and server configuration—that can significantly improve user experience and page load speed.
This article explains the core concepts of system performance, defines throughput and latency, describes how to measure them, and provides detailed, code‑level techniques for locating and eliminating common performance bottlenecks across operating systems, networks, databases, and application code.
This article provides a comprehensive analysis of SQL‑on‑Hadoop architectures, comparing runtime‑framework‑based engines like Hive with MPP‑style engines such as Impala, detailing core components, compilation pipelines, optimizer strategies, CPU/IO performance tricks, columnar storage formats, and resource management in modern big‑data query platforms.
This guide explains the meaning of MySQL's Open_tables and Opened_tables status variables, shows how to check them, and provides recommended ratios and steps to adjust the table_cache setting for better database performance.
The article reviews MySQL InnoDB 5.7’s major performance enhancements—such as transaction pooling, temporary‑table redesign, buffer and DDL optimizations—and introduces new capabilities like native partitioning, dynamic buffer sizing, GIS support, virtual columns, and advanced compression, all illustrated with benchmark graphics.
Using LIMIT OFFSET for pagination becomes inefficient beyond thousands of rows, but by leveraging indexed ID ranges, delayed joins, or index‑only scans you can retrieve pages in milliseconds, dramatically improving performance for large datasets.
Replacing a VARCHAR column that stores timestamp strings with a native TIMESTAMP type in a massive sorting table reduced query time from over 20 minutes to 39 seconds, demonstrating a 30‑plus‑fold speedup due to smaller storage, faster CPU comparisons, and reduced I/O.
The article explains the branch and bound algorithm, comparing it with backtracking, describing its search strategies, general procedure, and key differences such as search order, node handling, and optimal solution finding, while providing a basic overview and illustrative diagram.
This article explains the fundamentals of dynamic programming, covering its basic concepts, underlying ideas, applicable problem properties, step‑by‑step solution methodology, implementation considerations, and provides a concise pseudo‑code framework to illustrate the algorithmic process.
This article explains the classic 0/1 knapsack problem, presents a detailed dynamic programming approach with step‑by‑step table construction, demonstrates the method using a concrete example, and discusses its computational complexity.
The article presents techniques for accelerating geodesic distance calculations across millions of coordinate pairs—such as vectorized formulas, spatial indexing, parallel processing, and approximation algorithms—that dramatically cut CPU time and memory usage while preserving required accuracy for large‑scale geographic analyses.
This article compiles 50 practical PHP performance tips—from using single quotes and static methods to leveraging opcode caching and memcached—detailing how each adjustment can noticeably improve execution speed, memory usage, and overall efficiency of web applications.
This article reviews nine Java performance profiling tools—including NetBeans Profiler, JProfiler, GC Viewer, VisualVM, Patty, JRockit Mission Control, Eclipse Memory Analyzer, Java Interactive Profiler, and Profiler4J—detailing their features, usage scenarios, and how they help developers identify and resolve CPU, memory, and thread bottlenecks.
