This article details how to dramatically speed up the import of massive Excel fee‑record files in a Java backend by switching to EasyExcel, caching database lookups, using batch INSERT statements, and applying parallel streams while eliminating excessive logging.
This article provides a comprehensive overview of Spark SQL, covering its architecture, DataSet/DataFrame APIs, code examples for creating and querying datasets, join strategy selection, handling Hive tables, small‑file issues, inefficient NOT‑IN subqueries, Cartesian products, and a catalog of useful built‑in functions.
This article analyzes how landing‑page load speed impacts user experience and conversion, presents data‑driven measurements and key‑path breakdowns, and details practical frontend optimization methods—including container initialization, parallel billing, resource pre‑loading, and server‑ and client‑side pre‑rendering—to significantly improve performance across commercial ad flows.
This article explains how iOS app launch works, presents methods for measuring startup time using system calls and Xcode Instruments, shares a detailed case study of the Maimai app, and offers concrete pre‑main and post‑main optimization techniques—including binary reordering, dynamic‑library reduction, concurrency control, and unconventional tricks—to achieve sub‑second launch performance.
This article explains the concepts of debounce and throttle in JavaScript, illustrates their principles and typical use cases such as button submissions, search suggestions, window resize, and drag‑and‑drop, and provides practical implementations with code examples and options for immediate execution, timestamps, and timers.
This article explains system design fundamentals—including architecture, modules, components, interfaces, and data—outlines the main tasks and step‑by‑step process, covers performance challenges, RAIL performance model, key web metrics, and Facebook's design values, providing a comprehensive guide for building robust applications.
By illustrating how to replace simple HashMap caching with Redis‑based distributed caches and locks—using SETNX, Lua scripts, and Redisson—the article shows Spring Boot developers how to prevent cache breakdown, ensure data consistency, and dramatically improve throughput in high‑concurrency web applications.
This article reviews Ceph's architecture, enumerates common benchmarking tools, analyzes its advantages and challenges, and presents a comprehensive set of performance‑optimization methods covering storage‑engine tuning, network communication, data placement, configuration parameters, hardware‑specific adaptations, and future research directions.
This article systematically presents the cold‑start performance problems of the Beike iOS app, defines testing standards, explains the essence of optimization, lists common pitfalls, and details a comprehensive set of practical solutions ranging from lifecycle‑aware task scheduling and minimal‑set launchers to dynamic‑library lazy loading, compile‑time I/O elimination, static‑initializer handling, dead‑code removal, and monitoring standards.
This article summarizes the key techniques presented at CovalenceConf 2019 for optimizing Visual Studio Code's startup performance, covering measurement, bundling, V8 code caching, lifecycle phase ordering, requestIdleCallback, and perceived‑performance tricks that together reduce launch time to under one second.
This article documents a step‑by‑step performance optimization of a Python web module, covering requirement analysis, environment setup, load‑testing results, database and TCP bottleneck identification, caching strategies, kernel tuning, and the final achievement of 50,000 QPS with low latency.
Tencent’s MongoDB team solved the severe performance degradation caused by millions of collections by redesigning WiredTiger to use a shared table‑space with prefix‑mapped keys, eliminating data‑handle explosion, cutting memory use and lock contention, reducing startup from hours to minutes, and boosting read/write throughput by up to two orders of magnitude while preserving full MongoDB compatibility.
The article outlines how Baidu iFanFan reduces mobile web page load times from 2‑3 seconds to under one second by bundling static resources, pre‑rendering and pre‑initializing WebViews, employing a micro‑frontend master‑slave architecture, using offline packages, native request routing, and early network pre‑loading.
This article outlines the career path toward software architecture, detailing the market expectations, essential competencies such as project management, technical depth, business insight, communication, decision‑making, and optimization techniques for systems, backend services, and databases, while emphasizing continuous learning and community involvement.
This article details how the logistics HR data preprocessing platform processes around 20 million daily records by adopting HBase for high‑performance, scalable, column‑oriented storage, covering its architecture, read/write mechanisms, best practices, and performance considerations.
This article analyzes the bottlenecks of advertising coarse‑ranking training on the Light framework and presents a series of optimizations—including parallel data download, thread‑queue buffering, integer‑to‑string conversion with fmt, and zlib replacement with czlib—that together achieve up to 58% QPS improvement and notable CPU efficiency gains.
This article recounts how a Vue‑SSR e‑commerce site was repeatedly overloaded during three promotional phases and how the team applied static‑dynamic data separation, CDN integration, application‑level caching, auto‑degrade rendering, rate‑limited APIs, and hydration fixes to achieve stable high‑traffic performance.
This article details how Tencent Classroom's WeChat mini‑program activity page was optimized by extracting an independent subpackage, reducing the package size by 93% and achieving a 30% overall startup speed improvement, with thorough analysis of launch metrics across device types.
This newsletter announces the AppWorks 1.3.0 release with new VS Code assistance and Toolkit features, showcases several open‑source projects such as Bulletproof React, Astro, tRPC, Prestige, fnm and TAURI, and highlights in‑depth articles on Vue async setup, MMKV performance, and how browsers render a web page.
This article describes how a Java backend service suffered high CPU usage and load, how the team diagnosed the problems with jtop and thread stacks, optimized JSON/Bean processing, re‑engineered Hystrix circuit‑breaker settings, reduced logging overhead, and fixed Spring data‑binding exceptions to double the QPS and achieve stable recovery after traffic spikes.
The article outlines the essential duties, required competencies, decision‑making principles, and optimization techniques for software architects, covering system decomposition, technology selection, communication, technical depth, performance tuning, database scaling, and the broader mindset needed to lead complex development projects.
This article explains practical Nginx configuration tweaks—including enabling gzip compression, setting cache headers, activating HTTP/2, optimizing logging, and limiting bandwidth—to reduce bandwidth usage and server load, illustrated with code examples and performance impact calculations for typical web traffic.
This article explains what RPC is, walks through each step of a remote procedure call—including stubs, routing, load balancing, serialization, encoding, and network transmission—and analyzes where latency originates to guide backend developers in performance optimization.
Discover a comprehensive Redis best‑practice guide covering memory optimization, performance tuning, high reliability, daily operations, resource planning, monitoring, and security, with actionable tips such as key length control, maxmemory settings, lazy‑free, connection pooling, replication strategies, and safe deployment practices.
This article provides a comprehensive collection of 52 practical tips for improving SQL query performance, covering index creation, query rewriting, data type selection, storage engine choices, and execution plan analysis to help developers write faster, more efficient database statements.
This article details a systematic investigation of a WeChat Mini Program’s slow startup, request, and interaction performance, presents data‑driven diagnostics, and outlines concrete optimizations—code‑size reduction, CDN static assets, independent sub‑packages, data prefetch, request queuing, and stepwise rendering—that together reduced package size by 27%, startup time by up to 45%, and request latency by over 80%, delivering a noticeably smoother user experience.
This article details how a large‑scale e‑commerce shop improved first‑screen load speed by over 50% through micro‑frontend architecture, full‑chain performance tracing, interface caching, parallel rendering, and template‑based snapshot rendering, providing a repeatable optimization framework for complex web applications.
HermesX unifies Xianyu’s fragmented push pipelines into a single flow, optimizes content relevance, applies a four‑layer fatigue model, and offers a low‑code management UI, delivering up to 35% less abnormal traffic, 65% lower compute use, and 69% reduced peak latency while paving the way for richer content pools and finer user segmentation.
This article details how Liulishuo implemented 3D character customization in its PIE English practice app using Cocos Creator 3.0, covering native SDK integration, JSB-based cross-platform method calls, and Asset Bundle-based resource management for performance optimization.
This article explains how ByteDance leverages ClickHouse for ad audience estimation, profiling, and analytics, detailing the challenges of massive user‑level set operations, the evolution from a simple tag‑uid table to Bitmap64 with RoaringBitmap, and the extensive engineering optimizations that cut query latency, storage, and CPU usage dramatically.
Baidu’s live‑streaming team cut startup latency by dissecting the three‑phase launch process, streamlining business‑logic handling, employing HTTPDNS pre‑resolution, forcing first‑frame rendering, low‑bitrate fallback, pre‑loading kernels, direct H.264 SPS/PPS parsing, and HLS m3u8 pre‑fetching, achieving sub‑3 ms DNS and hundreds‑millisecond overall gains.
The article presents Jiang Hongwei’s GMTC talk on 58RN’s instant‑open strategy, detailing performance metrics, LCP‑based first‑screen measurement, identified bottlenecks, and a series of optimizations—including resource pre‑loading, bundle splitting, native parallel fetching, and dynamic import—that collectively reduce page load time and improve business conversion rates.
This article explains how Beike adopted the Druid OLAP engine to handle massive real‑time and offline query workloads, detailing its four‑component architecture, key technologies such as deep storage and metadata storage, practical optimizations for data ingestion, query caching, dynamic throttling, timeout control, and a roadmap for future enhancements.
By combining telemetry, Xcode Time Profile analysis, and a state‑machine‑driven deferment of playback until UI layout completes, the iQIYI Qixiu iOS team eliminated main‑thread SetFrame blocking and streamlined room‑data handling, boosting instant‑play success from roughly 56% to 78% and markedly improving first‑frame rendering latency.
This tutorial demonstrates how to create a Micronaut microservice, compile it into a GraalVM Native Image, and apply advanced optimizations such as G1 GC, profile‑guided compilation, and UPX packing to achieve faster startup, lower memory usage, and higher throughput in cloud environments.
This article examines a common React progress‑bar component, explains why the naïve timer‑based implementation causes heavy reflows and repaints, and presents a GPU‑accelerated CSS animation solution that dramatically improves frame rates and reduces layout work.
This article breaks down the Android APK installation lifecycle—pre‑install, install, and post‑install—explaining each stage, offering command‑line methods, code examples, performance tweaks, and troubleshooting tips to help developers understand and optimize the whole process.
This article provides a thorough learning roadmap for Apache Spark, covering its background papers, core concepts such as RDD and fault tolerance, module breakdown, recommended books and repositories, source‑code reading tips, hands‑on projects, and interview‑oriented optimization guidance.
The article explains Java's underlying thread models, why native methods are used, and how the OpenHFT Java-Thread-Affinity library leverages JNA to bind Java threads to specific CPU cores for performance gains, including code examples and real‑world usage.
The Baidu App’s T7 browser kernel team optimized its HTTPCache and MemoryCache by enabling main‑document and file‑protocol caching, introducing a fixed‑size LRU cleanup, providing custom preload/query APIs, and leveraging NoState Prefetch, which together cut page‑load latency by over 30 % and markedly improve user experience.
This article explains core Linux I/O concepts—including file systems, I/O types, caching mechanisms, copy‑on‑write, zero‑copy, and performance metrics—then presents practical application, file‑system, and disk‑level optimization techniques to improve throughput and latency.
This article explains why reading Linux kernel source matters, advocates starting from real‑world problems, contrasts a "carpet‑bombing" approach with a precision‑guided method, and shares concrete tools, resources, and step‑by‑step tips for efficiently exploring kernel code.
This article provides a comprehensive overview of InnoDB architecture, covering its memory structures, background threads, and key features like checkpoint mechanisms, double write, and neighbor page flushing, essential for understanding MySQL's default storage engine.
This article explains Netty's role as a mature I/O framework, outlines the end‑to‑end remote‑call workflow of a distributed service, details protocol design, shares performance‑tuning tricks, and presents best practices for building scalable, low‑latency backend systems.
This article explains the performance bottlenecks of relational databases, introduces sharding concepts such as horizontal, vertical, and table partitioning, discusses associated challenges like distributed transactions and global primary keys, and provides practical solutions and tool recommendations for implementing effective database partitioning.
This article explains how to build a scalable long‑connection service using Netty, covering the underlying concepts, Linux kernel tuning, code examples for Java NIO and Netty, performance bottlenecks such as QPS, data‑structure and GC issues, and practical optimization techniques to achieve hundreds of thousands of concurrent connections.
This article introduces the HR performance data preprocessing platform’s requirements, explains why HBase was selected as the storage solution, details its core concepts, architecture, data write/read processes, best practices, limitations, and presents performance metrics demonstrating its suitability for large‑scale, high‑throughput workloads.
The case study details how a high‑traffic Dubbo service handling 1.8 billion daily requests suffered periodic circuit‑breaks due to thread‑pool exhaustion, traced to a cache‑bypass bug, Redis setex spikes, and an improperly warmed commons‑pool2 connection pool, and resolved by fixing the bug, scaling Redis, and tuning or downgrading the pool configuration to enable pre‑warming via minEvictableIdleTimeMillis.
The article reviews Baidu C++ engineers' concurrency optimizations, explaining why modern software must exploit parallelism and detailing SIMD vectorization, out‑of‑order execution, and micro‑architectural analysis, then compares mutex, lock‑free, and wait‑free synchronization, showcasing case studies where atomic and wait‑free designs dramatically improve multithreaded performance.
This article explores how introducing various cache layers—from database and distributed caches to local and CPU caches—bridges the gap between fast CPUs and slow I/O, detailing performance benefits, cache miss handling, consistency strategies, memory management, and techniques to avoid false sharing.
The article details DiDi’s development of a real‑time, large‑screen data‑visualization system built on a custom WebGL‑based map framework, describing how they tackled one‑time map loading, massive data compression, and high‑performance rendering of trajectories, bubbles, heatmaps, flight lines and animated scatter points, supported by interactive debugging tools.
An in‑depth look at how mattsta’s CRCSpeed implementation replaced Redis’s original CRC algorithm, delivering up to four‑fold speed gains, the history of its development from 2014 to its 2020 integration, and the performance impact on RDB generation and cluster slot hashing.
Meituan Homestay built a custom cross‑platform reuse framework converting React Native code to mini‑programs, achieving up to 90% code reuse, reducing bundle size, improving performance, and establishing strict processes for quality, thus cutting development effort and enhancing productivity across iOS, Android, and mini‑programs.
This article explores the fundamentals and advanced techniques of cache optimization, covering multi‑level caching, read/write performance gains, cache miss handling, consistency strategies, heap versus direct memory, CPU cache effects, false sharing, and practical mitigation patterns.
This article details Baidu’s internal service‑mesh deployment, explaining why traditional RPC‑based governance fell short, how a sidecar‑based mesh decouples governance from frameworks, and the technical challenges and solutions for low‑intrusion, high‑performance, fault‑tolerant traffic management across tens of thousands of microservices.
Baidu created an internally‑built, Istio‑based service mesh that decouples governance from language‑specific RPCs, offering low‑intrusion integration, ultra‑low latency via a brpc coroutine data plane, advanced fault‑tolerance and fine‑grained traffic scheduling, and now powers over 80 % of its core microservices handling more than a trillion daily requests.
This article walks through using ADDM to pinpoint problematic SQL statements in Oracle, creating and executing a SQL Tuning Advisor task, evaluating profile and index recommendations, and applying parallel execution to dramatically improve performance and resource usage.
An engineer describes a production MySQL pagination issue where large offset queries caused severe slowdown, analyzes the root cause, demonstrates data simulation scripts, and presents three optimization strategies—including index covering with subqueries, redefining start positions, and applying offset limits—to improve query performance on massive tables.
This article details how Kuaishou’s Fast Creation team leveraged pure Flutter to implement complex audio‑video features such as playback, editing, and live streaming, describing the challenges of UI, state, performance, and data communication, and presenting optimization techniques like external textures, FFI, thumbnail caching, and frame‑rate improvements.
This article examines common MySQL performance pitfalls such as inefficient LIMIT offsets, implicit type conversions, suboptimal UPDATE/DELETE joins, mixed sorting, misuse of EXISTS, and limited condition pushdown, then demonstrates concrete rewrites—including range reduction and WITH clauses—that reduce execution times from seconds to milliseconds.
Weibo’s deep learning platform faced severe latency and stability issues when accessing massive small‑file datasets via a compute‑storage‑separated architecture, so the team adopted the CNCF Fluid project with JindoRuntime, implementing a distributed cache that leverages POSIX interfaces, dramatically improving data locality, reducing HDFS load, and achieving up to 18‑fold training speedups while raising success rates from 37 % to 98 %.
Didi migrated over 10,000 Hive SQL tasks to Spark SQL, achieving 85% Spark task share, cutting execution time by 40%, and reducing CPU and memory usage by 21% and 49% respectively, through a systematic migration process that addressed syntax, UDF, performance, and functional differences between the two engines.
This article details Ximalaya's evolution of its HTTP gateway—from a Tomcat NIO prototype to a fully asynchronous Netty design—covering architectural diagrams, performance bottlenecks, traffic management features, monitoring, GC tuning, and future plans for HTTP/2 and graceful degradation.
This article shares practical experience of building a high‑performance distributed prediction service by combining TensorFlow for Java with Spark‑Scala, covering framework selection, performance comparison, model training, loading, inference, deployment, and optimization techniques for large‑scale data processing.
A large‑scale IoT service migrated 40 billion rows from MySQL to MongoDB, solving capacity, cost, and data‑skew issues while achieving higher performance, lower storage consumption, and a flexible, highly available architecture, with detailed resource evaluation, migration steps, optimization tactics, and cost‑benefit analysis.
This extensive article introduces Hive as a Hadoop‑based data warehouse, explains its architecture, core concepts, DDL/DML syntax, functions, performance‑optimization techniques, data‑skew handling, and provides a collection of common interview questions for Hive practitioners.
Tencent Cloud Oceanus, a computing service powering internal apps like WeChat and external partners such as Bilibili, scales to over 30,000 cores handling 5 PB daily and 500,000 jobs, and tackles Flink SQL’s syntax, function and operational limits with table‑valued functions, incremental and enhanced tumble windows, and caching‑based retraction optimization that cuts downstream data volume up to 30× and improves join performance by about 20 %.
The article explains Youzan's Transparent Multilevel Cache (TMC), a solution that automatically detects cache hotspots, adds an application‑level local cache, and provides hit statistics to reduce load on distributed caches, improve consistency, and boost performance for high‑traffic e‑commerce scenarios.
This article explains how to optimize Java scheduled tasks for large‑scale data synchronization by introducing phased improvements such as blacklist mechanisms, multithreaded execution with CountDownLatch, and server‑level sharding, providing practical guidelines for performance and reliability.
This article presents a detailed case study of moving a 2‑petabyte smart‑product data workload from Elasticsearch to MongoDB, covering business background, source cluster architecture, MongoDB design and resource planning, step‑by‑step performance optimizations, latency and cost comparisons, and guidance on when each database is appropriate.
This article explores the essence of system architecture, illustrating how large‑scale services like Uber and Weibo handle massive traffic, data storage, service decomposition, multi‑level caching, and monitoring, and offers practical design principles for building robust, high‑performance backend systems.
This article explains how cursor‑based pagination avoids the heavy cost of offset/limit queries by using database cursors, shows practical API examples, compares query plans, and discusses why cursors improve performance and consistency for deep pagination in backend systems.
The article details how iQIYI doubled online inference speed and cut p99 latency by over 50% in TensorFlow‑based CTR recommendation models by replacing costly string‑based integer hashing, removing redundant dense‑sparse conversions, and deduplicating user features for efficient broadcasting, demonstrating that modest Feature Column tweaks can yield major production gains.
The article outlines why high‑load Go services need performance tuning and presents a systematic workflow—preparation, analysis with Linux tools and Go’s pprof/trace, targeted optimizations such as goroutine pooling, Redis MSET, efficient JSON handling and slice resizing—demonstrating how these changes boost throughput, lower latency, and stabilize memory usage while offering broader Go‑specific best‑practice recommendations.
In this interview, ByteDance cloud engineer Wu Chen explains how system‑level IaaS virtualization delivered elasticity, cost‑effectiveness, and strong isolation to support Douyin’s Spring Festival red‑envelope event, compares virtualization with containers, shares reliability lessons from a power‑outage test, and outlines future trends.
This article documents a Python web service performance optimization case, detailing the initial bottlenecks, architectural redesign with caching and message queues, load‑testing methodology, Linux TCP time‑wait tuning, and the final results achieving 50k QPS with sub‑70 ms latency.
This article provides a comprehensive technical overview of large‑scale distributed website architecture, covering characteristics, goals, common patterns, high‑performance and high‑availability designs, scalability, extensibility, security, agility, a seven‑layer reference model, and a detailed e‑commerce case study with practical optimization steps.
The article describes a backend‑for‑frontend architecture that pushes GraphQL into the BFF layer, separates fetch and display units, drives execution with metadata, unifies query models, applies caching and parallel processing optimizations, and demonstrates over 50 % logic reuse and doubled development efficiency in production.
This case study details how integrating JuiceFS with Presto reduced HDFS cluster load by about 26%, achieved over 90% cache hit rate for ad‑hoc queries, and lowered average query latency by roughly 13%, while simplifying operations and improving system stability.
This article shares Baidu C++ engineers' practical performance‑optimisation techniques, covering memory‑access patterns, custom allocation strategies, string handling, protobuf handling, cache‑line considerations and memory‑order semantics to achieve significant latency and cost reductions in large‑scale backend services.
This article explores the evolution of front‑end performance optimization, compares SPA and SSR architectures, introduces a Node‑based middle‑layer design, and details the CarNext framework built on Next.js that improves rendering speed, SEO friendliness, and development efficiency for 58.com’s automotive services.
This article explains how to improve performance of long React pages by rendering components screen‑by‑screen using viewport detection (getBoundingClientRect or Intersection Observer), grouping data, debouncing scroll handlers, and applying React.memo to prevent duplicate data requests.
Understanding the actual memory footprint of Java objects—including headers, class pointers, fields, and alignment—reveals hidden waste, and the article provides calculations for Integer objects, arrays, and collections, plus practical guidelines to reduce memory usage by preferring primitive types, smaller fields, and arrays over collections.
This article explores Baidu C++ engineers' deep‑dive into performance optimization, covering memory‑access patterns, string‑buffer handling, protobuf merging, malloc strategies, job‑arena allocation, cache‑line effects, and modern memory‑order semantics to achieve multi‑fold speedups in large‑scale backend services.
The article details a thorough investigation of native‑memory crashes in the K歌 Android app, describing how memory usage was profiled, comparing three analysis tools, building a custom loli_profiler‑based hook to track malloc/free and bitmap allocations, exposing leaks, and outlining fixes and future optimization plans.
By classifying data streams, aggregating large‑scale T+1 records in six‑hour windows, encoding attributes with multi‑value mappings, storing compressed rule‑hit backups, and synchronizing recall tables in real time, Mahé’s selection‑and‑delivery pipeline cut end‑to‑end latency from minutes to seconds, achieving robust second‑level responsiveness.
Baidu engineers boost C++ backend latency and cost efficiency by eliminating unnecessary string zero‑initialization, using zero‑copy split with SIMD, replacing deep protobuf merges with repeated string fields, employing job‑scoped arenas and custom memory resources for allocation, and applying prefetching, cache‑line awareness, and tuned memory‑order semantics, achieving multiplicative to order‑of‑magnitude speedups.
The Dolphin system introduces a native‑plus‑H5, component‑based architecture using React to meet JD International’s personalized channel requirements, improve performance, enable cross‑platform configuration, and provide a secure, real‑time, and isolated solution for dynamic page rendering.
This article explores the features and benefits of ConstraintLayout in Android, including its flexibility, performance improvements, and practical usage examples for creating complex layouts efficiently.
This article recounts the author's three‑year journey evolving a Python‑based SaaS backend from a simple MVC setup through service splitting and microservices, detailing architectural choices, performance challenges, optimization tactics, and the move toward domain‑driven design, while sharing practical lessons and resources.
This case study details how JD’s "Browse" UGC project evolved from rapid agile delivery to a performance bottleneck as data grew, and how introducing Elasticsearch, redesigning the query flow, and refactoring storage components restored fast, flexible searches for both front‑end and operations users.
This article reviews the Ice Lake‑based next‑generation Intel SGX, compares its security and performance improvements over previous generations, presents detailed benchmark results on memory access, dynamic memory management and enclave switching, and describes software optimizations implemented in the Occlum runtime to mitigate remaining overheads.
Replit engineers discovered that slow Docker container shutdown on preemptible VMs caused REPL sessions to hang for up to a minute, and by bypassing Docker’s kill process and directly terminating container PIDs they reduced error rates from 3% to under 0.5% and cut 99th‑percentile startup time from two minutes to fifteen seconds.
The article guides front‑end developers from basic 2D charting to immersive 3D data visualizations, explaining WebGL’s rendering pipeline, comparing libraries such as Three.js and Babylon.js, detailing camera, lighting, model handling techniques, and showing how Draco compression dramatically shrinks GLB assets while preserving quality.
Baidu’s Transaction Middle Platform Order System provides a unified, cloud‑native architecture that supports diverse Baidu products by orchestrating modular commands, handling order lifecycle, payment, refunds, and splitting, while employing caching, asynchronous processing, and sharded databases to achieve high throughput and low latency.
This article explains Flutter's rendering pipeline and provides practical techniques for optimizing the build, layout, and paint phases, including debugging tools, code refactoring, and widget structuring to achieve smoother, higher‑performance applications.
This article explains why database performance bottlenecks arise, outlines criteria for deciding when to shard databases and tables, and provides detailed strategies for SQL tuning, table restructuring, horizontal and vertical splitting, single‑ versus multi‑database sharding, as well as handling cross‑database joins, distributed transactions, pagination, and ID generation.
This article details RocketMQ's 2020 Double‑11 transformation, covering its migration to a Kubernetes‑based operator, a MessageType‑indexed filter optimization that cut CPU usage by up to 32%, and the introduction of a POP consumption model that eliminates rebalance‑induced latency and improves reliability.
Xianyu built an automated mobile performance testing platform that standardizes and integrates testing into the release pipeline, replacing manual steps with three‑stage automated tasks, adding data collection, retry verification, and reporting, cutting manpower from a day to under an hour while boosting data accuracy and stability, with plans to further embed testing into CI.
This article explains Redis's original single‑threaded event loop, the performance problems it causes, and how Redis 4.0 introduced Lazy Free and Redis 6.0 added multithreaded I/O, comparing the implementation with Tair's more elegant multithreaded design.
