BestHub
Sign in
Tagged articles
5000 articles
Page 38 of 50
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 1, 2020 · Databases

Why Redis Dominates Modern Caching: Features, Architecture, and Best Practices

Redis, an in‑memory C‑language database, offers ultra‑fast read/write speeds, rich data structures, persistence, clustering, and multi‑threaded I/O, making it ideal for distributed caching, locks, queues, and more; this guide explains its fundamentals, comparisons with Memcached, data types, eviction policies, and operational best practices.

CacheData StructuresPerformance
0 likes · 36 min read
Why Redis Dominates Modern Caching: Features, Architecture, and Best Practices
Code Ape Tech Column
Code Ape Tech Column
Nov 30, 2020 · Backend Development

Master Redis: Persistence, Caching Pitfalls, Clustering & Performance Tips

This article provides a comprehensive guide to Redis for interview preparation, covering persistence mechanisms, common caching challenges such as avalanche and penetration, data types and their use cases, internal structures, expiration policies, single‑threaded performance, clustering options, distributed locking, and best‑practice solutions.

Data TypesPerformancePersistence
0 likes · 27 min read
Master Redis: Persistence, Caching Pitfalls, Clustering & Performance Tips
IT Architects Alliance
IT Architects Alliance
Nov 29, 2020 · Backend Development

Why High Performance Makes Software Architecture So Complex—and How to Tame It

The article analyzes how the relentless pursuit of high performance drives both single‑machine and cluster‑level architectural complexity, explaining the evolution from batch processing to multi‑core CPUs, the trade‑offs of processes, threads, SMP/NUMA/MPP, and the challenges of task allocation and decomposition in large‑scale systems.

BackendDistributed SystemsPerformance
0 likes · 16 min read
Why High Performance Makes Software Architecture So Complex—and How to Tame It
Java Architect Essentials
Java Architect Essentials
Nov 27, 2020 · Backend Development

16 Java Coding Best Practices for Performance and Clean Code

This article presents sixteen practical Java coding best‑practice guidelines—including avoiding ‘where 1=1’ in MyBatis, using entrySet for map iteration, preferring Collection.isEmpty(), pre‑sizing collections, employing StringBuilder, leveraging Set for contains checks, static initialization blocks, and other tips—to improve performance, readability, and safety of backend applications.

BackendCode OptimizationCollections
0 likes · 18 min read
16 Java Coding Best Practices for Performance and Clean Code
Laravel Tech Community
Laravel Tech Community
Nov 27, 2020 · Backend Development

Highlights of PHP 8.0: JIT and Major New Features

PHP 8.0 introduces a suite of major enhancements—including named arguments, union types, attributes, constructor property promotion, match expressions, null‑safe operator, and especially JIT compilation—aimed at improving performance, type safety, and overall language consistency.

JITPHP8Performance
0 likes · 3 min read
Highlights of PHP 8.0: JIT and Major New Features
Alibaba Terminal Technology
Alibaba Terminal Technology
Nov 27, 2020 · Frontend Development

What Chrome 87 Brings: Major Performance Boosts and New Web APIs

Chrome 87 (M87) introduced a suite of performance‑focused enhancements and new web APIs—including tag throttling, occlusion tracking, forward/back cache, WebAuthn debugging, camera PTZ control, range‑request support in service workers, and a font‑access API—significantly improving browser efficiency and developer capabilities.

Camera PTZChromeFont Access
0 likes · 8 min read
What Chrome 87 Brings: Major Performance Boosts and New Web APIs
php Courses
php Courses
Nov 27, 2020 · Backend Development

Phoronix PHP 8 Performance Benchmark Report Highlights JIT Gains

Phoronix’s benchmark of PHP 8 (built from the latest Git source) compares it with previous PHP releases, showing modest gains for the stable version but a dramatic 92% speed increase when JIT is enabled, while also revealing mixed results across different test suites due to I/O bottlenecks.

JITPHP8Performance
0 likes · 3 min read
Phoronix PHP 8 Performance Benchmark Report Highlights JIT Gains
Alibaba Cloud Native
Alibaba Cloud Native
Nov 26, 2020 · Cloud Computing

How Gaode Scaled Serverless to Handle 2 Million Calls per Minute During China’s Travel Festival

During the 2020 "Golden Week" travel festival, Gaode Maps leveraged Alibaba Cloud Serverless to sustain nearly two million function invocations per minute, achieving over 99.99% success rate, sub‑60 ms latency, and demonstrating significant gains in efficiency, elasticity, cost savings, and observability for large‑scale map services.

Cloud ComputingCost OptimizationPerformance
0 likes · 9 min read
How Gaode Scaled Serverless to Handle 2 Million Calls per Minute During China’s Travel Festival
Liangxu Linux
Liangxu Linux
Nov 25, 2020 · Operations

Essential Linux Shell Commands for System Monitoring and Troubleshooting

This guide compiles dozens of practical Linux shell commands for deleting zero‑byte files, inspecting processes, checking CPU, memory, disk usage, and more, plus a collection of useful regular expressions for matching Chinese characters, emails, URLs, IPs, and other patterns.

LinuxPerformanceShell
0 likes · 14 min read
Essential Linux Shell Commands for System Monitoring and Troubleshooting
Architects' Tech Alliance
Architects' Tech Alliance
Nov 25, 2020 · Fundamentals

In‑Depth Look at AMD’s Zen 3 Core Architecture and Performance

The article provides a comprehensive technical analysis of AMD’s Zen 3 (Ryzen 5000) microarchitecture, covering its chiplet layout, cache hierarchy, front‑end redesign, integer and floating‑point units, load/store improvements, security features, and overall performance gains compared with Zen 2.

AMDCPU architectureChiplet
0 likes · 13 min read
In‑Depth Look at AMD’s Zen 3 Core Architecture and Performance
macrozheng
macrozheng
Nov 24, 2020 · Backend Development

Fastest & Safest HashMap Traversal: Compare Java 8 Streams, Lambdas, and Iterators

This article examines the four major HashMap traversal techniques—Iterator, for‑each loops, Lambda expressions, and Streams API—detailing seven concrete implementations, benchmarking their performance with JMH, analyzing generated bytecode, and evaluating safety when modifying collections during iteration, ultimately recommending the most efficient and secure approaches.

HashMapPerformanceStreams
0 likes · 19 min read
Fastest & Safest HashMap Traversal: Compare Java 8 Streams, Lambdas, and Iterators
Top Architect
Top Architect
Nov 24, 2020 · Databases

SQL Query Optimization Rules and Best Practices

This article presents five practical rules for writing efficient SQL queries—including using precise WHERE clauses, creating appropriate indexes, avoiding costly subqueries, replacing OFFSET‑based pagination with key‑based limits, and understanding the logical execution order of SQL clauses—to help developers improve database performance across major relational systems.

Performancedatabaseindexes
0 likes · 14 min read
SQL Query Optimization Rules and Best Practices
DeWu Technology
DeWu Technology
Nov 23, 2020 · Backend Development

Understanding Cache: Concepts, Types, and Best Practices

Cache is a temporary storage layer that speeds data access by keeping frequently used items close to the processor, spanning hardware (CPU registers, multi‑level caches) to software (database, Redis, Memcached), and requires careful design to avoid penetration, breakdown, and consistency issues through techniques such as empty‑result caching, Bloom filters, pre‑warming, jittered expirations, logical refreshes, and multi‑level strategies.

BackendCacheData Consistency
0 likes · 12 min read
Understanding Cache: Concepts, Types, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 20, 2020 · Databases

Optimizing a Slow MySQL 5.7 Query for Detecting Tables Without Primary or Unique Keys

This article examines why a MySQL 5.7 query that finds tables lacking primary or unique keys runs extremely slowly, demonstrates an experiment reproducing the issue, analyzes the optimizer's subquery rewrite, and shows how adding hints and materialization reduces execution time from over 16 seconds to under one second.

Information SchemaMySQLPerformance
0 likes · 4 min read
Optimizing a Slow MySQL 5.7 Query for Detecting Tables Without Primary or Unique Keys
Top Architect
Top Architect
Nov 20, 2020 · Databases

Database Design and SQL Best‑Practice Guidelines

This article presents a comprehensive set of mandatory and recommended MySQL database standards—including table creation rules, SQL writing conventions, and index design practices—aimed at preventing improper schemas, reducing erroneous queries, and improving overall performance for backend development teams.

Database designMySQLPerformance
0 likes · 14 min read
Database Design and SQL Best‑Practice Guidelines
ITPUB
ITPUB
Nov 19, 2020 · Operations

10 Essential Linux Sysadmin Hacks to Boost Efficiency and Save Time

This article presents ten practical Linux system‑administration techniques—from ejecting a stuck DVD drive and resetting a frozen console to using screen sharing, SSH tunnels, bandwidth testing, and powerful command‑line scripts—each designed to streamline tasks, reduce downtime, and give administrators more free time.

AutomationLinuxNetworking
0 likes · 19 min read
10 Essential Linux Sysadmin Hacks to Boost Efficiency and Save Time
ITPUB
ITPUB
Nov 19, 2020 · Fundamentals

How HugePages Boost Database and Hadoop Performance on Linux

This article explains Linux HugePages, how to view and configure them, demonstrates code and Kubernetes examples, and details how larger memory pages reduce management overhead and lock memory to improve performance for memory‑intensive services like databases and Hadoop.

HadoopLinuxMemory Management
0 likes · 10 min read
How HugePages Boost Database and Hadoop Performance on Linux
macrozheng
macrozheng
Nov 18, 2020 · Backend Development

Why MapStruct Is the Fastest Java Bean Mapper and How to Use It

This article introduces MapStruct, a compile‑time Java bean‑mapping framework, explains why it outperforms other mappers, shows how to configure Maven, define mapper interfaces, handle custom field mappings, and demonstrates its impressive runtime performance with practical code examples.

Performancebean-mappingcode-generation
0 likes · 13 min read
Why MapStruct Is the Fastest Java Bean Mapper and How to Use It
政采云技术
政采云技术
Nov 17, 2020 · Frontend Development

Writing High-Quality Maintainable Code: Asynchronous Optimization

This article explains the various asynchronous techniques in JavaScript—callback, Promise, async/await, and generator—compares them, and demonstrates practical patterns for handling callback hell, parallel and sequential async operations to write cleaner, more maintainable frontend code.

AsyncPerformancePromise
0 likes · 10 min read
Writing High-Quality Maintainable Code: Asynchronous Optimization
php Courses
php Courses
Nov 17, 2020 · Backend Development

Performance‑Optimized PHP: Faster Alternatives for Duplicates, Random Selection, Alphanumeric Checks, and Substring Replacement

This article presents several PHP function alternatives that significantly improve execution speed—such as using array_keys + array_flip for duplicate removal, mt_rand for random selection, ctype_alnum for alphanumeric testing, and strtr for substring replacement—backed by benchmark results and practical tips.

ArrayPerformanceString
0 likes · 6 min read
Performance‑Optimized PHP: Faster Alternatives for Duplicates, Random Selection, Alphanumeric Checks, and Substring Replacement
Taobao Frontend Technology
Taobao Frontend Technology
Nov 17, 2020 · Frontend Development

How We Cut Event Page Load Time by Up to 700 ms for Millions of Shoppers

This article details how a cross‑team performance‑optimization effort for Tmall/Taobao event pages redefined metrics, introduced full‑link visual timing, and applied pre‑rendering, data pre‑fetch, resource acceleration, and offline caching to shave 200‑700 ms off load times and boost instant‑open rates by 10‑14 % across Android and iOS devices.

MobilePerformancee‑commerce
0 likes · 18 min read
How We Cut Event Page Load Time by Up to 700 ms for Millions of Shoppers
21CTO
21CTO
Nov 16, 2020 · Fundamentals

Why Python Still Dominates and Where It Falls Short

The article examines Python's enduring popularity, highlighting its readability, rich ecosystem, and corporate adoption while also discussing its performance drawbacks, memory usage, GIL limitation, and challenges in mobile and high‑performance computing, before comparing it to emerging languages.

GILMobile DevelopmentPerformance
0 likes · 6 min read
Why Python Still Dominates and Where It Falls Short
Taobao Frontend Technology
Taobao Frontend Technology
Nov 16, 2020 · Frontend Development

Taobao Frontend Secrets Behind Double 11: FaaS, D2C, Performance Hacks

This article details how Taobao's frontend team tackled the double‑peak Double 11 challenge with massive workload, introduced Design‑to‑Code automation, Serverless FaaS, progressive hybrid apps, edge rendering and smart UI, achieving higher efficiency, stability, and conversion gains across the massive shopping festival.

Double11PerformanceServerless
0 likes · 20 min read
Taobao Frontend Secrets Behind Double 11: FaaS, D2C, Performance Hacks
Programmer DD
Programmer DD
Nov 16, 2020 · Backend Development

Is System.currentTimeMillis Really a Performance Bottleneck? A Deep Dive

This article investigates whether System.currentTimeMillis suffers from performance problems by examining custom caching implementations, analyzing common misconceptions, presenting benchmark data from both simple loops and JMH tests, and concluding that the native method is sufficiently fast for typical use cases.

JMHPerformanceSystem.currentTimeMillis
0 likes · 13 min read
Is System.currentTimeMillis Really a Performance Bottleneck? A Deep Dive
Programmer DD
Programmer DD
Nov 15, 2020 · Backend Development

How HikariCP’s FastList Outperforms ArrayList for Statement Management

This article examines HikariCP’s FastList, a custom list built on ArrayList that removes range checks and overrides key methods, explaining how these optimizations—such as a faster add operation, a new removeLast method, and unsupported bulk operations—boost the performance of the database connection pool.

FastListHikariCPPerformance
0 likes · 6 min read
How HikariCP’s FastList Outperforms ArrayList for Statement Management
JD Tech Talk
JD Tech Talk
Nov 13, 2020 · Mobile Development

Android App Startup Speed Optimization Practices at JD Finance

This article details JD Finance's Android mobile app startup speed optimization project, covering background, launch type analysis, measurement tools, and a series of practical improvements such as theme switching, application code reduction, thread management, network tweaks, and activity refinements that together cut launch time by up to 45%.

AndroidJD FinanceMobile Development
0 likes · 15 min read
Android App Startup Speed Optimization Practices at JD Finance
ITPUB
ITPUB
Nov 13, 2020 · Backend Development

Why Gradle Beats Maven: Installation, Wrapper, and Dependency Management Guide

This guide explains the drawbacks of Maven, the advantages of Gradle, how to install Gradle via binaries or package managers, use the Gradle wrapper, manage dependencies with concise scopes, configure mirrors and proxies, and leverage Gradle's speed, flexibility, and simplicity for Java projects.

Build ToolGradlePerformance
0 likes · 14 min read
Why Gradle Beats Maven: Installation, Wrapper, and Dependency Management Guide
Alibaba Terminal Technology
Alibaba Terminal Technology
Nov 13, 2020 · Frontend Development

How Serverless SSR Boosted Mobile H5 Performance for Alibaba's Feizhu Event

Facing slow page loads on weak mobile networks, Alibaba’s Feizhu marketing team adopted a Serverless Faas SSR solution combined with async rendering, reducing first‑screen time to under one second, improving offline capabilities, and addressing challenges like image flicker, titlebar support, and scaling performance.

Mobile H5PerformanceSSR
0 likes · 15 min read
How Serverless SSR Boosted Mobile H5 Performance for Alibaba's Feizhu Event
Architect's Tech Stack
Architect's Tech Stack
Nov 13, 2020 · Databases

How to Safely Scan Large Redis Keyspaces with the SCAN Command

This article explains why using the KEYS command on massive Redis datasets can cause service blockage, analyzes the underlying O(n) traversal cost, and demonstrates how the incremental SCAN command with cursor, MATCH, and COUNT options provides a non‑blocking alternative for efficiently iterating keys.

PerformanceSCANkey management
0 likes · 5 min read
How to Safely Scan Large Redis Keyspaces with the SCAN Command
Laravel Tech Community
Laravel Tech Community
Nov 12, 2020 · Backend Development

Design Considerations and Best Practices for API Gateways in Microservice Architectures

The article examines the challenges of exposing numerous backend microservices to clients and proposes using an API gateway to centralize traffic, handle authentication, rate limiting, protocol conversion, service discovery, performance optimization, and operational concerns, while also discussing the shift toward decentralized service‑mesh solutions.

MicroservicesPerformanceService Mesh
0 likes · 15 min read
Design Considerations and Best Practices for API Gateways in Microservice Architectures
dbaplus Community
dbaplus Community
Nov 10, 2020 · Operations

Essential Elasticsearch Tuning Tips for Performance and Stability

This guide consolidates practical Elasticsearch tuning techniques—from configuration file settings and system‑level adjustments to usage‑level optimizations—covering memory locking, discovery, fault detection, queue sizing, JVM heap, file descriptors, translog handling, bulk indexing, shard management, and best practices to achieve a stable, high‑performance cluster.

ClusterOperationsPerformance
0 likes · 18 min read
Essential Elasticsearch Tuning Tips for Performance and Stability
JD.com Experience Design Center
JD.com Experience Design Center
Nov 10, 2020 · Fundamentals

Essential VR Design Principles: Boost Comfort, Usability, and Immersion

This guide outlines core VR design principles—including performance optimization, comfort, learnability, camera handling, UI placement, interaction feedback, motion safety, and environment setup—to help creators build immersive, user‑friendly virtual experiences while avoiding common pitfalls that cause discomfort or confusion.

PerformanceUI guidelinesUser experience
0 likes · 8 min read
Essential VR Design Principles: Boost Comfort, Usability, and Immersion
Xianyu Technology
Xianyu Technology
Nov 10, 2020 · Backend Development

Optimizing Data Synchronization for Xianyu IM: Layered Architecture and Performance Improvements

Xianyu IM’s data‑sync was re‑engineered by extracting a dedicated sync layer that uses domain‑based versioning, push‑pull hybrid buffering, and priority queues, decoupling business logic, eliminating redundant pushes, and achieving a 31% latency reduction and 35% traffic savings while enabling dynamic priority adjustments.

IMPerformancedata synchronization
0 likes · 10 min read
Optimizing Data Synchronization for Xianyu IM: Layered Architecture and Performance Improvements
php Courses
php Courses
Nov 9, 2020 · Backend Development

Performance‑Optimized Alternatives to Common PHP Functions

This article presents faster PHP alternatives for removing duplicate array values, selecting random elements, testing alphanumeric strings, and replacing substrings, providing benchmark results that show significant speed improvements and discussing trade‑offs and additional coding tips for better script performance.

ArrayPerformanceString
0 likes · 6 min read
Performance‑Optimized Alternatives to Common PHP Functions
Tencent Music Tech Team
Tencent Music Tech Team
Nov 6, 2020 · Mobile Development

Design and Implementation of an Incremental Compilation Component for Android Projects

The team built a low‑intrusion Gradle plugin that detects changed source and resource files, performs precise dependency analysis, leverages aapt2 for incremental resource compilation, and injects updated Dex and assets into the running app, cutting full Android builds from 418 seconds to 13 seconds and boosting daily developer productivity on large projects such as QQ Music.

AndroidBuild OptimizationDynamic Loading
0 likes · 23 min read
Design and Implementation of an Incremental Compilation Component for Android Projects
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 6, 2020 · Backend Development

Common Backend Performance Optimization Techniques

The article outlines practical backend performance optimization methods such as SQL tuning, eliminating duplicate calls, on‑demand queries, parallel execution, caching, asynchronous processing, JVM parameter tweaks, and horizontal scaling, providing code examples and actionable advice for developers.

AsynchronousPerformanceSQL optimization
0 likes · 8 min read
Common Backend Performance Optimization Techniques
IT Architects Alliance
IT Architects Alliance
Nov 5, 2020 · Industry Insights

How Do Massive Websites Scale? Key Architecture Patterns Unveiled

This article examines the defining traits of large‑scale web systems and walks through the step‑by‑step evolution of their architecture—from single‑server LAMP setups to multi‑layer, distributed, and automated designs—highlighting performance, availability, scalability, and security considerations.

ArchitectureDistributed SystemsPerformance
0 likes · 18 min read
How Do Massive Websites Scale? Key Architecture Patterns Unveiled
Architect
Architect
Nov 5, 2020 · Databases

Differences Between count(1), count(*), and count(column) in MySQL

This article explains the functional and performance differences among MySQL's count(1), count(*), and count(column) functions, illustrates how NULL handling varies, and provides a concrete example demonstrating their results and execution efficiency under different table schemas.

COUNTMySQLPerformance
0 likes · 5 min read
Differences Between count(1), count(*), and count(column) in MySQL
Architects Research Society
Architects Research Society
Nov 5, 2020 · Frontend Development

Comparative Analysis of React, Angular, and Vue Frameworks

This article provides a detailed comparison of the three major frontend frameworks—React, Angular, and Vue—covering their design principles, strengths, weaknesses, performance benchmarks, popularity, learning curves, and suitability for different project requirements.

AngularFrontendLearning Curve
0 likes · 18 min read
Comparative Analysis of React, Angular, and Vue Frameworks
MaGe Linux Operations
MaGe Linux Operations
Nov 5, 2020 · Databases

7 Compelling Reasons Not to Run Databases Inside Docker Containers

Although Docker has become popular for deploying applications, this article outlines seven critical drawbacks—data safety, performance, networking, statefulness, resource isolation, cloud platform incompatibility, and environment requirements—that make containerizing databases generally unsuitable, while also suggesting scenarios where lightweight or distributed databases may still benefit from containerization.

ContainerizationData SafetyDocker
0 likes · 8 min read
7 Compelling Reasons Not to Run Databases Inside Docker Containers
FunTester
FunTester
Nov 5, 2020 · Operations

How to Implement Fixed‑QPS Load Testing and Fix Common Bugs

This article explains a practical fixed‑QPS load‑testing model for HTTP requests, provides reusable Java code for creating test tasks, and details two bug fixes—one for thread‑pool shutdown handling in asynchronous compensation threads and another for inaccurate request‑counting that caused over‑compensation.

Load TestingPerformancebug fix
0 likes · 7 min read
How to Implement Fixed‑QPS Load Testing and Fix Common Bugs
DataFunTalk
DataFunTalk
Nov 5, 2020 · Big Data

Applying Apache Doris for JD.com Advertising Report Queries: Architecture, Challenges, and Performance

This article details JD.com's transition from a custom ad‑reporting system to Apache Doris, describing the background, challenges with the legacy platform, selection criteria, implementation of data import, pre‑aggregation, on‑site computation, and the resulting performance and operational benefits during regular operation and major sales events.

Ad ReportingApache DorisOLAP
0 likes · 12 min read
Applying Apache Doris for JD.com Advertising Report Queries: Architecture, Challenges, and Performance
Architecture Digest
Architecture Digest
Nov 5, 2020 · Databases

Elasticsearch Interview Question: Performance Optimization and Best Practices

The article explains how to improve Elasticsearch query speed on billions of records by leveraging filesystem cache, reducing indexed fields, using data pre‑heating, separating hot and cold indices, designing efficient document models, and applying pagination techniques such as scroll API and search_after.

BackendFilesystem CachePerformance
0 likes · 11 min read
Elasticsearch Interview Question: Performance Optimization and Best Practices
Liangxu Linux
Liangxu Linux
Nov 4, 2020 · Fundamentals

How Much Faster Is CPU L1 Cache Compared to RAM, SSD, and HDD?

This article explains the storage hierarchy from CPU registers and caches to RAM, SSD, and HDD, quantifies their speed differences (L1 cache vs. memory, SSD, HDD) and cost ratios, and provides Linux commands to inspect cache sizes, helping readers understand why each level exists and how they interact.

CPU cacheHDDPerformance
0 likes · 14 min read
How Much Faster Is CPU L1 Cache Compared to RAM, SSD, and HDD?
Architects Research Society
Architects Research Society
Nov 4, 2020 · Frontend Development

React as a State Management Library: Best Practices and Patterns

This article explains how React can serve as a complete state‑management solution by using hooks, lifting state, component composition, the Context API, and optional libraries, while also covering performance tips, server‑cached versus UI state, and when to adopt external tools.

Context APIFrontendHooks
0 likes · 15 min read
React as a State Management Library: Best Practices and Patterns
Programmer DD
Programmer DD
Nov 4, 2020 · Databases

7 Essential Linux Tweaks to Supercharge Redis Performance

This guide explains seven critical Linux operating‑system settings—memory overcommit, swappiness, Transparent Huge Pages, OOM killer, NTP synchronization, ulimit, and TCP backlog—that together ensure Redis runs reliably and at peak speed.

Memory ManagementOS TuningPerformance
0 likes · 14 min read
7 Essential Linux Tweaks to Supercharge Redis Performance
ITPUB
ITPUB
Nov 3, 2020 · Databases

How Indexes Supercharge MySQL Queries: A Deep Dive into EXPLAIN

This article explains why MySQL indexes dramatically improve query speed, outlines common reasons for slow SQL, shows how to use EXPLAIN to analyze execution plans, and provides step‑by‑step optimization examples with code and visual illustrations.

MySQLPerformanceexplain
0 likes · 14 min read
How Indexes Supercharge MySQL Queries: A Deep Dive into EXPLAIN
php Courses
php Courses
Nov 2, 2020 · Backend Development

Implementing Full Page Cache with Redis in PHP

This article explains how to improve the performance of rarely‑changed web pages such as user agreements by storing their rendered HTML in Redis as a full‑page cache, describing the design of helper functions, the RedisFPC class implementation, usage examples, testing results, and practical recommendations.

Performancefull page cache
0 likes · 8 min read
Implementing Full Page Cache with Redis in PHP
Tencent Cloud Middleware
Tencent Cloud Middleware
Oct 30, 2020 · Cloud Computing

How KonaJDK Powers Tencent Cloud Java, Big Data, and Secure Computing

This article explains how Tencent's self‑developed KonaJDK underpins cloud Java services, enhances micro‑service monitoring, adds national cryptography support, optimizes large‑heap tools like jmap, and delivers performance gains for big‑data workloads, while contributing key features back to the OpenJDK community.

Big DataCloud ComputingJVM
0 likes · 11 min read
How KonaJDK Powers Tencent Cloud Java, Big Data, and Secure Computing
Amap Tech
Amap Tech
Oct 30, 2020 · Frontend Development

Frontend Performance Optimization: Common Issues and Solutions for Large‑Scale Projects

Large‑scale front‑end projects suffer from oversized bundles, unnecessary listeners, deep cloning, and mutable state, causing latency and crashes; the article explains how to diagnose these problems with Chrome DevTools and Webpack tools and resolves them through bundle splitting, tree‑shaking, memoisation, immutable patterns, and caching.

PerformanceReactTree Shaking
0 likes · 12 min read
Frontend Performance Optimization: Common Issues and Solutions for Large‑Scale Projects
Zhongtong Tech
Zhongtong Tech
Oct 30, 2020 · Big Data

How Apache Kylin Supercharged OLAP at ZTO Express: A Deep Dive

This article details ZTO Express's journey of adopting Apache Kylin for OLAP, comparing it with Presto, describing platform architecture, performance gains, integration with scheduling and monitoring systems, and the practical optimizations and future plans that enabled sub‑second query responses on massive daily data volumes.

Apache KylinBig DataHBase
0 likes · 16 min read
How Apache Kylin Supercharged OLAP at ZTO Express: A Deep Dive
Programmer DD
Programmer DD
Oct 30, 2020 · Backend Development

How Dubbo’s Single Long Connection Leads to Congestion and What You Can Do

This article examines a production incident where Dubbo services became congested, explains the underlying communication process with detailed code analysis, identifies key protocol and service parameters affecting performance, conducts experiments on connection count and TCP buffers, and offers practical recommendations to optimize Dubbo throughput.

DubboPerformanceTCP
0 likes · 26 min read
How Dubbo’s Single Long Connection Leads to Congestion and What You Can Do
Taobao Frontend Technology
Taobao Frontend Technology
Oct 29, 2020 · Backend Development

How to Safely Execute Untrusted Code in Node.js: From new Function to VM and Worker Threads

This article examines reliable and trustworthy execution of dynamic JavaScript in Node.js, compares isolation techniques such as new Function, the vm module, and worker threads, evaluates their performance and security trade‑offs, and explores advanced container and WebAssembly sandboxing options.

Node.jsPerformanceWebAssembly
0 likes · 9 min read
How to Safely Execute Untrusted Code in Node.js: From new Function to VM and Worker Threads
Xianyu Technology
Xianyu Technology
Oct 29, 2020 · Mobile Development

Performance Optimization of Long List Scrolling in Android and Flutter

The article details how Xianyu improved long‑list scrolling smoothness on both native Android and Flutter by building a cross‑platform frame‑jank detection tool, applying async view‑caching and unbinding in Android, and using repaint boundaries, clipping tweaks, time‑slicing and custom scroll physics in Flutter, achieving up to 57 FPS and halving big‑jank counts on low‑end devices.

AndroidFlutterListView
0 likes · 21 min read
Performance Optimization of Long List Scrolling in Android and Flutter
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 29, 2020 · Fundamentals

Zero-Copy Data Transfer Mechanism: Principles, Implementations, and Applications in Java, Kafka, and Spark

This article explains the zero‑copy data transfer technique, compares it with traditional read/write approaches, shows Java NIO code examples, and discusses its use in high‑performance systems such as Kafka and Spark, highlighting the reductions in context switches and memory copies.

Data TransferJava NIOKafka
0 likes · 16 min read
Zero-Copy Data Transfer Mechanism: Principles, Implementations, and Applications in Java, Kafka, and Spark
Top Architect
Top Architect
Oct 28, 2020 · Backend Development

SpringBoot Project Optimization: Configuration File and JVM Tuning Guide

This article explains how to optimize a SpringBoot application by modifying the application.properties configuration file and tuning JVM parameters, providing practical code examples, IDE and script methods, and detailed explanations of each JVM option for better performance.

PerformanceSpringBootconfiguration
0 likes · 7 min read
SpringBoot Project Optimization: Configuration File and JVM Tuning Guide
DataFunTalk
DataFunTalk
Oct 27, 2020 · Databases

Didi's Large‑Scale Elasticsearch Upgrade: Architecture, Migration Strategy, and Performance Gains

This article systematically details Didi's migration of over 30 Elasticsearch clusters, 3,500 nodes and 8 PB of data from version 2.3.3 to 6.6.1, covering background, problem analysis, multi‑version architecture redesign, capacity planning, tiered storage, FastIndex, query replay, upgrade pitfalls, and the resulting cost reduction and performance improvements.

CapacityPlanningElasticsearchPerformance
0 likes · 15 min read
Didi's Large‑Scale Elasticsearch Upgrade: Architecture, Migration Strategy, and Performance Gains
Tencent Cloud Developer
Tencent Cloud Developer
Oct 26, 2020 · Databases

Database Auditing: Concepts, Methods, and TXSQL Implementation

Database auditing records user actions to detect illegal operations, with approaches ranging from application‑layer and transport‑layer monitoring to kernel‑level and plugin solutions; TXSQL’s MySQL‑compatible audit plugin offers both synchronous and asynchronous modes, delivering flexible rule configuration and only 3‑6 % performance overhead, making it a low‑impact, feature‑rich choice for compliance and forensics.

Audit ArchitectureDatabase AuditingMySQL
0 likes · 12 min read
Database Auditing: Concepts, Methods, and TXSQL Implementation
Programmer DD
Programmer DD
Oct 23, 2020 · Databases

Mastering Redis Lua Scripting: Essential Syntax and Best Practices

This article explains how Redis introduced Lua scripting to combine multiple commands atomically, covers Lua basics, data types, control structures, script execution with EVAL/EVALSHA, script management commands, and practical tips for writing efficient, safe Redis Lua scripts.

CacheLuaPerformance
0 likes · 14 min read
Mastering Redis Lua Scripting: Essential Syntax and Best Practices
Architect
Architect
Oct 22, 2020 · Databases

Understanding MySQL Index Types, Structures, and Best Practices

This article explains the various MySQL index implementations—including B‑Tree, B+Tree, hash, clustered, non‑clustered, and covering indexes—illustrates their internal structures with diagrams, provides SQL examples, and offers practical guidelines for selecting and using indexes efficiently.

B-TreeMySQLPerformance
0 likes · 13 min read
Understanding MySQL Index Types, Structures, and Best Practices
Xianyu Technology
Xianyu Technology
Oct 22, 2020 · Frontend Development

Optimizing Weex Frontend Performance for Xianyu

To eliminate Xianyu’s Weex pages’ long white-screen delays, the team identified large bundles, slow first-screen data requests, and heavy UI as root causes and applied offline bundle caching, data prefetching, progressive and on-demand rendering, and bundle slimming, cutting first-screen load to under two seconds on low-end phones and achieving near-instant display on higher-end devices.

FrontendPerformanceWeex
0 likes · 9 min read
Optimizing Weex Frontend Performance for Xianyu
58 Tech
58 Tech
Oct 21, 2020 · Backend Development

Understanding Java Memory Pools: Netty’s Implementation and Underlying Theory

This article revisits memory allocation and reclamation concepts by examining Java's Netty memory pool implementation, its theoretical basis in jemalloc, and practical design choices such as arena allocation, thread‑local caches, pool chunks, sub‑pages, and multi‑threaded performance considerations.

Garbage CollectionNettyPerformance
0 likes · 21 min read
Understanding Java Memory Pools: Netty’s Implementation and Underlying Theory
Top Architect
Top Architect
Oct 21, 2020 · Backend Development

Design and Optimization of High‑Concurrency Push Services Using Netty

This article analyzes common questions about Netty‑based push services, presents a real‑world IoT case study, and provides detailed design guidelines—including kernel tuning, connection handling, heartbeat configuration, buffer management, memory pooling, logging pitfalls, TCP and JVM tuning—to help engineers build stable, scalable, and high‑performance million‑connection push systems.

NettyPerformancePush Service
0 likes · 24 min read
Design and Optimization of High‑Concurrency Push Services Using Netty
WeDoctor Frontend Technology
WeDoctor Frontend Technology
Oct 20, 2020 · Mobile Development

Why YYCache Excels: Deep Dive into iOS Cache Design & Performance

This article examines the YYCache iOS library, covering its multi‑level architecture, LRU implementation, thread‑safe APIs, eviction policies, lock choices, disk‑storage strategies, Swift integration, performance benchmarks, and practical takeaways for building high‑performance mobile caches.

CacheLRUPerformance
0 likes · 24 min read
Why YYCache Excels: Deep Dive into iOS Cache Design & Performance
Tencent Cloud Developer
Tencent Cloud Developer
Oct 20, 2020 · Databases

ClickHouse: Architecture, Core Features, and Limitations for Interactive Analytics

ClickHouse is a PB‑scale, open‑source columnar OLAP database that uses a ZooKeeper‑coordinated sharded cluster, columnar storage, vectorized execution, advanced compression, data‑skipping indexes, and materialized views to deliver high‑performance interactive analytics, yet it requires manual shard management, lacks a mature MPP optimizer, and handles real‑time single‑row writes poorly.

ClickHouseColumnar StorageMaterialized Views
0 likes · 18 min read
ClickHouse: Architecture, Core Features, and Limitations for Interactive Analytics
ITPUB
ITPUB
Oct 19, 2020 · Databases

Why MySQL InnoDB Chooses B+ Trees: A Deep Dive into Index Design

This article explains why MySQL's default InnoDB storage engine uses B+ trees instead of B trees or hash indexes, covering storage engine basics, query performance, I/O considerations, and the structural advantages that make B+ trees ideal for OLTP workloads.

B+TreeInnoDBMySQL
0 likes · 16 min read
Why MySQL InnoDB Chooses B+ Trees: A Deep Dive into Index Design
Programmer DD
Programmer DD
Oct 19, 2020 · Fundamentals

ArrayList vs LinkedList: When Each Data Structure Truly Shines

This article benchmarks Java's ArrayList and LinkedList by measuring insertion and lookup times at the head, tail, and middle of a list with 100,000 elements, then explains the underlying source‑code mechanisms that cause the observed performance differences.

Data StructuresLinkedListPerformance
0 likes · 10 min read
ArrayList vs LinkedList: When Each Data Structure Truly Shines
ITPUB
ITPUB
Oct 18, 2020 · Databases

Boost MySQL Pagination Speed: Practical Query Optimizations and Benchmarks

This article examines MySQL pagination on a multi‑million‑row table, compares plain LIMIT queries with subquery, ID‑range, and temporary‑table techniques, provides SQL examples and performance measurements, and offers recommendations for fast, scalable paging.

MySQLPerformancepagination
0 likes · 10 min read
Boost MySQL Pagination Speed: Practical Query Optimizations and Benchmarks
Architects Research Society
Architects Research Society
Oct 18, 2020 · Operations

Top Salesforce Performance Issues and How to Mitigate Them

The article outlines five common performance problems affecting Salesforce SaaS deployments—location latency, bandwidth competition from multimedia traffic, low‑quality bandwidth, ineffective caching, and heavy plugin usage—and provides practical mitigation strategies for IT teams to ensure reliable user experiences.

PerformancePluginsSaaS
0 likes · 9 min read
Top Salesforce Performance Issues and How to Mitigate Them
Java Architect Essentials
Java Architect Essentials
Oct 18, 2020 · Backend Development

Performance Evaluation of Java Stream API: Serial vs Parallel Execution

This article presents a series of Java Stream API performance experiments—comparing serial and parallel streams on primitive, object, and reduction tasks—showing that while serial streams are slower than traditional loops for simple operations, parallel streams can significantly outperform both in multi‑core environments.

PerformanceStream APIbackend-development
0 likes · 7 min read
Performance Evaluation of Java Stream API: Serial vs Parallel Execution
Selected Java Interview Questions
Selected Java Interview Questions
Oct 17, 2020 · Databases

Redis Interview Questions and Answers: Persistence, Caching Issues, Data Types, Clustering, and More

This article provides a comprehensive overview of Redis interview topics, covering persistence mechanisms, cache avalanche and penetration problems, hot and cold data concepts, differences from Memcached, single‑thread performance, data structures, expiration policies, clustering solutions, distributed locks, transactions, and practical troubleshooting tips.

Data TypesPerformancePersistence
0 likes · 23 min read
Redis Interview Questions and Answers: Persistence, Caching Issues, Data Types, Clustering, and More
Architecture Digest
Architecture Digest
Oct 16, 2020 · Backend Development

Root Cause Analysis of High Latency in a Java HTTP Service: QPS Surge, GC Overhead, and Memory Pressure

The article details a real‑world investigation of a Java HTTP service that experienced a sudden QPS increase and response‑time spikes, tracing the issue through database queries, local method latency, CPU load, frequent ParNew GCs, and large response payloads, and presents concrete remediation steps.

BackendJVMPerformance
0 likes · 8 min read
Root Cause Analysis of High Latency in a Java HTTP Service: QPS Surge, GC Overhead, and Memory Pressure
Programmer DD
Programmer DD
Oct 16, 2020 · Backend Development

Mastering Guava’s Stopwatch: Precise Timing in Java Applications

An in‑depth guide explains Guava’s Stopwatch utility, showing how to create, start, stop, and reset timers, customize the time source via Ticker, compare it with raw System.nanoTime or System.currentTimeMillis, and highlights its advantages for accurate performance measurement in Java and Android projects.

GuavaPerformanceStopwatch
0 likes · 5 min read
Mastering Guava’s Stopwatch: Precise Timing in Java Applications
Top Architect
Top Architect
Oct 15, 2020 · Backend Development

Java Performance Optimization Tips and Best Practices

These Java performance optimization guidelines cover best practices such as appropriate use of singletons, minimizing static variables, reducing object creation, leveraging final modifiers, preferring local variables, efficient handling of collections, avoiding costly operations like synchronized blocks and split, and proper resource management to improve application efficiency.

Performancebest practicesjava
0 likes · 16 min read
Java Performance Optimization Tips and Best Practices
Sohu Tech Products
Sohu Tech Products
Oct 14, 2020 · Frontend Development

Common Vue Development Pitfalls and Solutions for WeChat Mini Programs

This article compiles a comprehensive list of frequent Vue development challenges when building WeChat mini‑programs—covering routing parameters, cross‑origin requests, Axios encapsulation, UI library on‑demand loading, scoped CSS overrides, timer cleanup, responsive rem handling, Swiper integration, source‑map suppression, gzip compression, bundle analysis, lazy loading, keep‑alive caching, v‑model customization, mixins, and deployment considerations.

PerformanceWeChatrouting
0 likes · 32 min read
Common Vue Development Pitfalls and Solutions for WeChat Mini Programs