BestHub
Sign in
Tagged articles
5000 articles
Page 36 of 50
Java Architect Essentials
Java Architect Essentials
Mar 31, 2021 · Databases

40 Common Redis Interview Questions and Answers

This article compiles 40 frequently asked Redis interview questions, covering its definition, data types, advantages, comparison with Memcached, persistence mechanisms, performance considerations, eviction policies, clustering, client libraries, security commands, usage scenarios, and best‑practice tips for high‑traffic production environments.

PerformancePersistenceclustering
0 likes · 19 min read
40 Common Redis Interview Questions and Answers
ITPUB
ITPUB
Mar 30, 2021 · Databases

10 Essential MySQL Development Rules Every DBA and Developer Should Follow

This article outlines ten practical MySQL development guidelines—from always using InnoDB and simple data types to avoiding SELECT *, ENUM, and low‑cardinality indexes, while emphasizing proper naming, charset choices, NOT NULL constraints, and continuous SQL monitoring with Percona Toolkit.

DBADatabase designMySQL
0 likes · 5 min read
10 Essential MySQL Development Rules Every DBA and Developer Should Follow
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 29, 2021 · Mobile Development

Why Flutter’s Inertial Scrolling Trails Chromium and Native Android – A Deep Performance Dive

This article analyzes the theoretical and measured performance differences of inertial scrolling among Web (Chromium), native Android, and Flutter, explains the underlying rendering mechanisms that cause Flutter’s lag, and outlines engine‑level optimizations that bring Flutter’s scroll smoothness close to native levels.

AndroidChromiumFlutter
0 likes · 14 min read
Why Flutter’s Inertial Scrolling Trails Chromium and Native Android – A Deep Performance Dive
Intelligent Backend & Architecture
Intelligent Backend & Architecture
Mar 29, 2021 · Backend Development

How to Become a Qualified Web Architect: Skills, Roles, and Learning Path

This article explores what a web architect is, the core value they bring to software projects, and the extensive technical, analytical, and communication skills required—including coding mastery, system design, database and operations knowledge, and continuous learning—to guide developers on a practical roadmap toward becoming a competent web architect.

PerformanceScalabilitycontinuous learning
0 likes · 13 min read
How to Become a Qualified Web Architect: Skills, Roles, and Learning Path
DataFunSummit
DataFunSummit
Mar 28, 2021 · Artificial Intelligence

Deploying Scikit‑learn and HMMlearn Models as High‑Performance Online Prediction Services Using ONNX

This article demonstrates how to convert traditional scikit‑learn and hmmlearn machine‑learning models into ONNX format and integrate them into a C++ gRPC service for fast online inference, covering environment setup, model conversion, custom operators, performance testing, and end‑to‑end pipeline construction.

Model DeploymentONNXPerformance
0 likes · 22 min read
Deploying Scikit‑learn and HMMlearn Models as High‑Performance Online Prediction Services Using ONNX
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 28, 2021 · Databases

Redis Multithreading: Why It Was Initially Single‑Threaded and What Changed in Redis 6.0

This article explains why Redis was originally designed as a single‑threaded in‑memory database, outlines the four main reasons for that design, describes the limitations of I/O multiplexing, and details how Redis 6.0 introduced multithreading for network request handling to improve performance under high QPS workloads.

IO MultiplexingPerformanceredis
0 likes · 10 min read
Redis Multithreading: Why It Was Initially Single‑Threaded and What Changed in Redis 6.0
Architecture Digest
Architecture Digest
Mar 28, 2021 · Frontend Development

Frontend Architecture Evolution: Lessons from Baidu Search Result Page

The article examines the evolution of front‑end architecture using Baidu's mobile search result page as a case study, outlining challenges such as massive codebases, coupling, and outdated tech stacks, and presenting a three‑layer solution involving foundation, modularization, and componentization with SSR optimization.

BaiduComponentizationFrontend
0 likes · 13 min read
Frontend Architecture Evolution: Lessons from Baidu Search Result Page
MaGe Linux Operations
MaGe Linux Operations
Mar 27, 2021 · Fundamentals

Ultimate Python Cheat Sheet: From Py2 vs Py3 Differences to Advanced Concurrency and Design Patterns

This comprehensive guide compiles essential Python knowledge—including Python 2 vs 3 changes, conversion tools, frequently used libraries, concurrency models, testing techniques, core language concepts, plus related topics such as networking, MySQL, Redis, Linux, design patterns, data structures, algorithms, and interview‑level questions—providing a one‑stop reference for developers seeking to deepen their Python expertise.

Performancecheatsheetconcurrency
0 likes · 32 min read
Ultimate Python Cheat Sheet: From Py2 vs Py3 Differences to Advanced Concurrency and Design Patterns
Architect's Tech Stack
Architect's Tech Stack
Mar 27, 2021 · Databases

Introducing ClickHouse: Columnar Database Overview, MySQL Migration, Performance Comparison, and Practical Tips

This article introduces ClickHouse, explains its column‑oriented architecture versus row‑oriented databases, details a MySQL‑to‑ClickHouse migration, shows a performance benchmark that reduces query time from minutes to seconds, and shares practical deployment tips and common pitfalls.

ClickHouseColumnar DatabaseData Migration
0 likes · 8 min read
Introducing ClickHouse: Columnar Database Overview, MySQL Migration, Performance Comparison, and Practical Tips
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 24, 2021 · Databases

Understanding MySQL Multi-Value Indexes and Their Use Cases

This article explains the difference between MySQL multi-value indexes and composite indexes, demonstrates how to create and query multi-value indexes using JSON columns, and shows performance benefits and practical scenarios when dealing with tables that have a large number of columns.

JSONMulti-Value IndexMySQL
0 likes · 13 min read
Understanding MySQL Multi-Value Indexes and Their Use Cases
DataFunTalk
DataFunTalk
Mar 24, 2021 · Big Data

Practical Experience of Using DorisDB for Real-Time and Offline Analytics in KuJiaLe's Big Data Platform

This article details how KuJiaLe's big data team replaced their legacy ADB and Presto clusters with a DorisDB MPP database, achieving sub‑second query latency, unified real‑time and offline analytics, simplified ETL pipelines, and significant cost savings while supporting billion‑row tables and high‑QPS workloads.

Big DataDorisDBETL
0 likes · 9 min read
Practical Experience of Using DorisDB for Real-Time and Offline Analytics in KuJiaLe's Big Data Platform
Programmer DD
Programmer DD
Mar 24, 2021 · Frontend Development

What Really Happens When You Type a URL? From DNS to Rendering Explained

This article walks through the complete lifecycle of a browser request—URL parsing, DNS lookup, TCP handshake, OSI‑layer transmission, caching strategies, HTML rendering, and performance optimizations—mirroring real interview questions faced by front‑end engineers.

FrontendPerformanceRendering
0 likes · 15 min read
What Really Happens When You Type a URL? From DNS to Rendering Explained
ITPUB
ITPUB
Mar 23, 2021 · Databases

13 Redis Best Practices to Save Memory, Boost Performance, Ensure Reliability

This guide presents thirteen practical Redis best‑practice recommendations covering memory optimization, performance tuning, high reliability, routine operations, resource planning, monitoring, and security, offering concrete steps such as key length control, maxmemory configuration, lazy‑free, command selection, connection pooling, replication settings, and safe deployment to help developers and DBA operators run Redis efficiently and safely.

Memory OptimizationPerformanceReliability
0 likes · 24 min read
13 Redis Best Practices to Save Memory, Boost Performance, Ensure Reliability
Taobao Frontend Technology
Taobao Frontend Technology
Mar 23, 2021 · Frontend Development

How to Supercharge Web Rendering with CSS content-visibility, will-change & contain

This article explains how modern CSS features such as content-visibility, will-change, contain, font-display, scroll-behavior, @import avoidance, media‑query splitting, and CSS custom properties can be used together with practical code examples to dramatically reduce page‑render time, improve smooth scrolling, and avoid layout shifts for faster, smoother web experiences.

Content-VisibilityPerformanceWeb
0 likes · 27 min read
How to Supercharge Web Rendering with CSS content-visibility, will-change & contain
Code Ape Tech Column
Code Ape Tech Column
Mar 23, 2021 · Backend Development

Java Code Optimization Best Practices and Performance Tips

This article presents a comprehensive collection of Java code‑optimization techniques—ranging from using final modifiers and reusing objects to proper resource handling, efficient collection sizing, avoiding reflection, and leveraging low‑level operations—aimed at reducing binary size, improving runtime efficiency, and preventing hard‑to‑detect bugs in production systems.

BackendCode OptimizationPerformance
0 likes · 24 min read
Java Code Optimization Best Practices and Performance Tips
Wukong Talks Architecture
Wukong Talks Architecture
Mar 22, 2021 · Databases

The Secrets Behind Redis’s Speed: Architecture, Data Structures, and Single‑Threaded Model

This article explains why Redis is exceptionally fast by detailing its in‑memory design, global hash table with O(1) lookups, incremental rehashing, specialized data structures such as SDS, ziplist, quicklist, skiplist and intset, as well as its single‑threaded event loop and epoll‑based I/O multiplexing.

I/O MultiplexingIn-Memory DatabasePerformance
0 likes · 19 min read
The Secrets Behind Redis’s Speed: Architecture, Data Structures, and Single‑Threaded Model
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 22, 2021 · Big Data

Kafka Performance Optimization: Sequential Writes, Zero‑Copy, PageCache, and Network Model

This article provides a comprehensive overview of Kafka performance optimization, covering network, disk, and complexity challenges, sequential write techniques, zero‑copy data transfer, page‑cache usage, reactor‑based networking, batch processing, compression, partition concurrency, and file‑structure design to help developers build high‑throughput, low‑latency streaming systems.

Disk I/OJava NIOPerformance
0 likes · 17 min read
Kafka Performance Optimization: Sequential Writes, Zero‑Copy, PageCache, and Network Model
DeWu Technology
DeWu Technology
Mar 19, 2021 · Databases

TDengine Deployment for Sentinel Flow Control Data at DeWu

DeWu chose the open‑source time‑series database TDengine to store billions of daily Sentinel flow‑control metrics, using a super‑table design with per‑resource tables, a three‑node cluster, Druid/MyBatis pooling, and raw‑SQL writes, achieving 10 ms batch write latency, sub‑millisecond queries, and 90 % compression.

JDBCPerformanceTDengine
0 likes · 11 min read
TDengine Deployment for Sentinel Flow Control Data at DeWu
Top Architect
Top Architect
Mar 19, 2021 · Backend Development

Understanding HTTP Caching Headers and Their Practical Use

This article provides a comprehensive overview of HTTP caching mechanisms, covering cache‑related header fields, legacy directives like Pragma and Expires, modern Cache‑Control directives, validation headers such as Last‑Modified and ETag, practical simulation with Fiddler, and best‑practice recommendations for both client and server side caching.

HTTPHeadersPerformance
0 likes · 19 min read
Understanding HTTP Caching Headers and Their Practical Use
Alibaba Terminal Technology
Alibaba Terminal Technology
Mar 18, 2021 · Frontend Development

Understanding React Fiber: How It Boosts Rendering Performance

This article explains why React introduced the Fiber architecture, how it breaks rendering work into small interruptible units, the role of requestAnimationFrame and requestIdleCallback, the underlying linked‑list data structures, and provides code examples that illustrate the render and commit phases for smoother UI updates.

FiberJavaScriptPerformance
0 likes · 24 min read
Understanding React Fiber: How It Boosts Rendering Performance
Open Source Linux
Open Source Linux
Mar 18, 2021 · Backend Development

How to Optimize Nginx for High Concurrency, Custom Errors, and Better Caching

This guide walks through customizing Nginx's 404 page, enabling the stub_status module to monitor server metrics, tuning worker processes and connection limits for higher concurrency, expanding client header buffers, and configuring static file caching to improve overall web performance.

Error HandlingPerformancecaching
0 likes · 8 min read
How to Optimize Nginx for High Concurrency, Custom Errors, and Better Caching
AntTech
AntTech
Mar 16, 2021 · Frontend Development

Inside Ant Group's Frontend Engineering: Faster Builds, Cloud Functions, Android Cloud Devices, and IDE Innovations

The article shares how Ant Group's frontend engineering team improves build speed with cloud functions and multi‑process webpack, adopts Apple M1 hardware, tackles Android cloud‑device debugging, and launches a lightweight IDE, illustrating the challenges, innovations, and future directions of modern frontend development.

Android debuggingBuild OptimizationCloud Computing
0 likes · 6 min read
Inside Ant Group's Frontend Engineering: Faster Builds, Cloud Functions, Android Cloud Devices, and IDE Innovations
Xianyu Technology
Xianyu Technology
Mar 16, 2021 · Mobile Development

Implementing Mixed-Span Waterfall Layout in Flutter

To enable mixed‑span waterfall layouts in Flutter, we built a custom FlowView that mimics RecyclerView’s StaggeredGridLayoutManager, handling normal and full‑width cards by dynamically selecting the shortest or tallest column, recycling off‑screen items, and achieving performance comparable to native GridView, now deployed in Xianyu’s home and search pages.

FlutterMobileDevelopmentPerformance
0 likes · 17 min read
Implementing Mixed-Span Waterfall Layout in Flutter
Java Architect Essentials
Java Architect Essentials
Mar 15, 2021 · Industry Insights

Can Apple M1 Macs Mine Ethereum Effectively? A Hands‑On Test

This article documents a technical experiment that runs Ethereum mining software on an M1‑based MacBook Air, detailing the required code patches, build process, performance logs, and the resulting profit of roughly one Chinese yuan per day, while comparing the M1’s capabilities to traditional GPU miners.

Apple SiliconEthereumM1
0 likes · 9 min read
Can Apple M1 Macs Mine Ethereum Effectively? A Hands‑On Test
Baidu Geek Talk
Baidu Geek Talk
Mar 15, 2021 · Frontend Development

Progressive Front-End Rendering: Route Separation, Pre‑Static Generation, and WebView Pre‑Creation for H5 Performance Optimization

The article describes a progressive front‑end rendering strategy that replaces synchronous template rendering with route separation, build‑time pre‑static HTML generation, and WebView pre‑creation, using skeleton components to cut first‑paint time, lower TTFB and JavaScript delays, and improve H5 performance, scalability and maintenance.

FrontendH5Performance
0 likes · 12 min read
Progressive Front-End Rendering: Route Separation, Pre‑Static Generation, and WebView Pre‑Creation for H5 Performance Optimization
DataFunTalk
DataFunTalk
Mar 15, 2021 · Big Data

Ten Gotchas When Migrating Spark Jobs to Flink

This article shares ten practical pitfalls encountered while moving hour‑level Spark session processing jobs to Apache Flink, covering parallelism skew, state TTL, checkpoint handling, logging, debugging, state migration, Reduce vs Process, input validation, event‑time handling, and the trade‑offs of storing data inside Flink.

Big DataFlinkPerformance
0 likes · 19 min read
Ten Gotchas When Migrating Spark Jobs to Flink
Code Ape Tech Column
Code Ape Tech Column
Mar 15, 2021 · Databases

Why Large OFFSETs Slow MySQL Queries and How to Fix Them

A developer discovers that massive OFFSET values in MySQL pagination cause full‑table scans and severe latency, then reproduces the issue with simulated data, benchmarks the slowdown, and presents three practical solutions—including index‑covering subqueries, cursor‑based pagination, and offset limits—to restore query performance.

Index OptimizationKeyset PaginationLarge OFFSET
0 likes · 16 min read
Why Large OFFSETs Slow MySQL Queries and How to Fix Them
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 13, 2021 · Fundamentals

Effective Java Practices: Builder Pattern, Object Creation, and Performance Optimizations

This article presents a collection of Java best‑practice guidelines—including using the Builder pattern for many constructor arguments, privatizing utility class constructors, minimizing object creation, avoiding finalizers, applying the Law of Demeter, preferring enums, and careful use of var‑args—to improve code readability, memory usage, and runtime performance.

Design PatternsMemory ManagementPerformance
0 likes · 15 min read
Effective Java Practices: Builder Pattern, Object Creation, and Performance Optimizations
Java Backend Technology
Java Backend Technology
Mar 13, 2021 · Backend Development

Why Java 8 Parallel Streams Can Be Slower Than Simple Loops

A production incident shows that using Java 8 parallel streams for message processing can dramatically reduce throughput, making them slower than a straightforward for‑loop due to the shared ForkJoinPool and thread‑pool sizing issues.

ForkJoinPoolParallel StreamPerformance
0 likes · 11 min read
Why Java 8 Parallel Streams Can Be Slower Than Simple Loops
Alibaba Terminal Technology
Alibaba Terminal Technology
Mar 12, 2021 · Cloud Native

How Alinode Boosts Node.js Observability & Scheduling in Serverless Cloud Native Era

This article outlines how Alinode has evolved from a Node.js performance diagnostic tool into a comprehensive observability and scheduling platform for serverless environments, detailing its Insight monitoring features, remote debugging, crash analysis, standardization efforts, and runtime optimizations that improve cost and performance.

AlinodeCloud NativeNode.js
0 likes · 12 min read
How Alinode Boosts Node.js Observability & Scheduling in Serverless Cloud Native Era
iQIYI Technical Product Team
iQIYI Technical Product Team
Mar 12, 2021 · Operations

Implementation and Practice of LEDAO‑CAT Monitoring System for iQIYI Content Platform

To meet the LEDAO platform’s need for rapid anomaly detection, full‑stack observability, and reliable alerting across more than 100 microservices, iQIYI evaluated OpenFalcon, Prometheus and CAT, selected CAT, deployed separate mainland and overseas clusters, added configurable access, health‑check and integrated alert channels, enabling five‑minute service onboarding, near‑zero‑intrusion instrumentation, and real‑time business‑level monitoring.

AlertingCATDevOps
0 likes · 12 min read
Implementation and Practice of LEDAO‑CAT Monitoring System for iQIYI Content Platform
Open Source Linux
Open Source Linux
Mar 12, 2021 · Backend Development

Redis vs Memcached: Which In‑Memory Database Wins for Your Projects?

This article compares Redis and Memcached across thread model, data structures, eviction policies, pipelining, persistence, high availability, and clustering, helping developers choose the most suitable in‑memory database for their specific performance and feature requirements.

Data StructuresIn-Memory DatabaseMemcached
0 likes · 9 min read
Redis vs Memcached: Which In‑Memory Database Wins for Your Projects?
Xianyu Technology
Xianyu Technology
Mar 11, 2021 · Mobile Development

FlutterWorker: Cross‑Platform Logic Processing Framework for Mobile Apps

FlutterWorker is a Dart‑based cross‑platform logic framework that runs client‑side processing for Xianyu’s mobile app, unifying data handling across iOS, Android and Flutter, reducing server‑side BFF reliance, cutting memory and CPU overhead, improving latency by about five percent, and dramatically increasing development efficiency.

DARTFlutterLogic Framework
0 likes · 10 min read
FlutterWorker: Cross‑Platform Logic Processing Framework for Mobile Apps
Senior Brother's Insights
Senior Brother's Insights
Mar 8, 2021 · Fundamentals

How JDK 9’s Compact Strings Slash Java Memory Usage

The article explains how Java's String class was re‑engineered in JDK 9 to use a byte‑array with a coder flag, enabling Latin‑1 encoding, halving memory consumption, reducing GC pauses, and boosting overall application performance.

Compact StringsJDK9Memory Optimization
0 likes · 6 min read
How JDK 9’s Compact Strings Slash Java Memory Usage
ITPUB
ITPUB
Mar 7, 2021 · Blockchain

Can You Mine Ethereum on an Apple M1 Mac? A Hands‑On Test and Results

This article documents a developer’s attempt to run Ethereum mining software on an M1‑based MacBook Air, detailing the required patches, compilation steps, observed hash rates, daily earnings, and how the performance compares with traditional GPU miners.

BlockchainEthereumGPU
0 likes · 9 min read
Can You Mine Ethereum on an Apple M1 Mac? A Hands‑On Test and Results
Top Architect
Top Architect
Mar 4, 2021 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates why MySQL recommends auto_increment over UUID or non‑sequential snowflake IDs by creating three tables, running insert and query benchmarks with Spring Boot and JdbcTemplate, analyzing index structures, and summarizing the performance trade‑offs and security considerations of each primary‑key strategy.

Performanceauto_incrementindexing
0 likes · 10 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2021 · Databases

Troubleshooting MySQL Slave Replication Errors Caused by XtraBackup Kill‑Long‑Query Settings

This article explains how to diagnose and resolve MySQL slave replication failures that occur when XtraBackup’s --kill-long-queries-timeout and --kill-long-query-type options interrupt long‑running queries, detailing steps such as checking performance_schema, reviewing error logs, restarting replication, and adjusting backup parameters.

MySQLPerformanceReplication
0 likes · 4 min read
Troubleshooting MySQL Slave Replication Errors Caused by XtraBackup Kill‑Long‑Query Settings
Code Ape Tech Column
Code Ape Tech Column
Mar 3, 2021 · Databases

When INSERT INTO SELECT Breaks MySQL: A Cautionary Data‑Migration Story

An engineer’s costly mistake using MySQL’s INSERT INTO SELECT for nightly data migration led to out‑of‑memory crashes, full‑table scans, and payment record loss, prompting a deep dive into locking behavior, transaction isolation, and how proper indexing can safely rescue large‑scale inserts.

Data MigrationFull Table ScanINSERT INTO SELECT
0 likes · 7 min read
When INSERT INTO SELECT Breaks MySQL: A Cautionary Data‑Migration Story
Liangxu Linux
Liangxu Linux
Feb 28, 2021 · Frontend Development

What Really Happens When You Type a URL? From DNS to Rendering

This article walks through the complete journey of a URL entered in a browser, covering URL parsing, DNS lookup, TCP handshake, OSI‑layer packet transmission, caching strategies, HTML parsing, rendering pipeline, and practical performance‑optimisation tips.

FrontendPerformanceRendering
0 likes · 14 min read
What Really Happens When You Type a URL? From DNS to Rendering
Top Architect
Top Architect
Feb 28, 2021 · Backend Development

Optimizing Large Excel Import Performance in Java Backend Applications

This article details a step‑by‑step optimization of a Java backend Excel import pipeline, covering migration from POI to EasyExcel, caching database lookups, batch insertion with MySQL VALUES, and parallel processing to reduce a 100k‑row import from minutes to under two minutes.

ExcelParallelProcessingPerformance
0 likes · 10 min read
Optimizing Large Excel Import Performance in Java Backend Applications
Top Architect
Top Architect
Feb 26, 2021 · Databases

52 Practical SQL Query Performance Optimization Strategies

This article compiles fifty‑two actionable tips for improving SQL query performance, covering index creation, query rewriting, use of temporary tables, proper data types, server configuration, and best practices for MySQL and other relational databases.

Performanceindexesoptimization
0 likes · 18 min read
52 Practical SQL Query Performance Optimization Strategies
Top Architect
Top Architect
Feb 25, 2021 · Mobile Development

Why Android Activity onStop/onDestroy Is Delayed by 10 Seconds When an Infinite Animation Is Running

The article explains that an infinite View animation continuously posts invalidate messages to the MessageQueue, preventing the idle handler from running and causing the Activity's onStop and onDestroy callbacks, scheduled with a 10‑second idle timeout, to be delayed until the queue becomes idle.

ActivityLifecycleAndroidIdleHandler
0 likes · 28 min read
Why Android Activity onStop/onDestroy Is Delayed by 10 Seconds When an Infinite Animation Is Running
360 Smart Cloud
360 Smart Cloud
Feb 25, 2021 · Cloud Computing

Investigation and Resolution of Octavia API Slow Response Issue

This article details the background, architecture, step‑by‑step troubleshooting, analysis of network and server queues, and the final configuration changes that resolved the intermittent slow response times of the Octavia load‑balancer API in an OpenStack environment.

APILoad BalancerOctavia
0 likes · 7 min read
Investigation and Resolution of Octavia API Slow Response Issue
Tencent Music Tech Team
Tencent Music Tech Team
Feb 23, 2021 · Mobile Development

Evaluation of Four Blur Solutions for Image Processing in a Flutter Music App

The study compares four image‑blur approaches for a Flutter music app—real‑time BackdropFilter, CPU‑intensive StackBlur, server‑side GaussianBlur, and compact BlurHash—showing that BackdropFilter causes frame‑rate stutter, StackBlur adds decode overhead, server GaussianBlur offloads work with caching benefits, while BlurHash minimizes storage at the cost of visual fidelity, guiding developers to select the method that fits their performance and quality needs.

BlurHashFlutterImage Blur
0 likes · 8 min read
Evaluation of Four Blur Solutions for Image Processing in a Flutter Music App
Baidu Geek Talk
Baidu Geek Talk
Feb 22, 2021 · Fundamentals

Can Embracing Hash Collisions Boost Performance? Inside B16 Hash Table

This article revisits traditional hash table design, then introduces a novel approach that deliberately leverages a controlled probability of hash collisions combined with SIMD parallelism, presenting the B16 and B16Compact hash tables, their structures, algorithms, and experimental results showing superior speed and space efficiency compared to unordered_map and F14.

B16Data StructuresPerformance
0 likes · 17 min read
Can Embracing Hash Collisions Boost Performance? Inside B16 Hash Table
php Courses
php Courses
Feb 22, 2021 · Backend Development

Customizing Xdebug Profiler Output Filename and Analyzing PHP Performance on macOS

This guide explains how to customize Xdebug's profiler output filename using the xdebug.profiler_output_name setting, shows where the generated cachegrind files are stored on macOS, and provides steps to install Graphviz and qcachegrind for performance analysis, plus cleanup commands to remove old profiles.

PerformanceProfilingXdebug
0 likes · 4 min read
Customizing Xdebug Profiler Output Filename and Analyzing PHP Performance on macOS
FunTester
FunTester
Feb 20, 2021 · Backend Development

How I Stress‑Tested a Socket.IO Service with Fixed QPS and Uncovered Hidden Bugs

After mastering the Socket protocol and a fixed‑QPS load‑testing model, I built a comprehensive Socket.IO performance test that simulates a teacher‑student scenario, measures message latency, identifies calculation errors and logging overhead, and reveals several bugs and optimization opportunities in the asynchronous handling and compensation threads.

Load TestingPerformanceconcurrency
0 likes · 10 min read
How I Stress‑Tested a Socket.IO Service with Fixed QPS and Uncovered Hidden Bugs
Laravel Tech Community
Laravel Tech Community
Feb 18, 2021 · Databases

Why NULL Columns Can Break MySQL Indexes and How to Avoid It

This article explains how MySQL treats NULL values, why columns defined with NULL can invalidate indexes, demonstrates the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, COUNT, DISTINCT, GROUP BY and ORDER BY with NULLs, and offers practical recommendations for schema design.

Database designMySQLNULL
0 likes · 13 min read
Why NULL Columns Can Break MySQL Indexes and How to Avoid It
ITPUB
ITPUB
Feb 18, 2021 · Databases

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

This article compiles fifty‑two practical SQL tuning strategies—including proper indexing, query rewriting, avoiding full table scans, using temporary tables, managing locks, and choosing the right storage engine—to help developers dramatically improve database query performance and scalability.

PerformanceQuery Tuningindexing
0 likes · 22 min read
52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries
ITPUB
ITPUB
Feb 17, 2021 · Databases

52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL tuning strategies—including index best practices, query rewriting, use of temporary tables, proper data types, and server configuration tips—to dramatically improve MySQL query speed and overall database efficiency.

MySQLPerformanceQuery Tuning
0 likes · 23 min read
52 Proven SQL Performance Optimization Techniques to Supercharge Your Queries
Top Architect
Top Architect
Feb 17, 2021 · Backend Development

Understanding and Optimizing MyBatis PageHelper Pagination Performance

This article analyzes the performance bottlenecks of PageHelper's pagination in MyBatis, demonstrates how large offsets degrade MySQL query speed, and presents a more efficient sub‑query join solution along with suggestions for refactoring the interceptor to improve backend pagination efficiency.

BackendPerformancejava
0 likes · 9 min read
Understanding and Optimizing MyBatis PageHelper Pagination Performance
Code Ape Tech Column
Code Ape Tech Column
Feb 16, 2021 · Databases

52 Proven SQL Optimization Techniques to Supercharge Your Queries

This article compiles 52 practical SQL performance‑tuning strategies—including indexing rules, query‑writing shortcuts, join optimizations, lock handling, temporary tables, storage‑engine choices, data‑type recommendations, backup tips, and useful code examples—to help developers dramatically improve query speed and overall database efficiency.

PerformanceQuery Tuningdatabase
0 likes · 20 min read
52 Proven SQL Optimization Techniques to Supercharge Your Queries
dbaplus Community
dbaplus Community
Feb 16, 2021 · Backend Development

How We Rescued a Live‑Streaming Service from 404 Crashes: Real‑World Performance Optimization Strategies

This article walks through the root causes of a live‑streaming outage caused by traffic spikes, explains core performance metrics such as response time and concurrency, and details a systematic set of optimizations—including timeout tuning, caching, fallback, retry policies, parallel processing, and API redesign—that restored system stability and improved latency.

BackendPerformanceScalability
0 likes · 16 min read
How We Rescued a Live‑Streaming Service from 404 Crashes: Real‑World Performance Optimization Strategies
Architect
Architect
Feb 15, 2021 · Big Data

Elasticsearch Optimization Practices for Large-Scale Data Queries

This article explains how to optimize Elasticsearch for cross‑month and multi‑year queries on billions of records, covering Lucene fundamentals, index and search performance tweaks, configuration settings, and practical testing results to achieve sub‑second response times.

Big DataElasticsearchPerformance
0 likes · 14 min read
Elasticsearch Optimization Practices for Large-Scale Data Queries
Architect's Tech Stack
Architect's Tech Stack
Feb 15, 2021 · Backend Development

Enhancing a Java RPC Framework: Protobuf/Kryo Serialization, Load‑Balancing Strategies, Connection Pooling and Performance Gains

This article describes a series of improvements to a Spring‑Boot based Java RPC framework—including support for Protobuf and Kryo serialization, multiple load‑balancing algorithms, client‑side service caching, TCP long‑connection reuse via Netty, and a performance test that reduces request latency by more than tenfold.

NettyPerformanceRPC
0 likes · 15 min read
Enhancing a Java RPC Framework: Protobuf/Kryo Serialization, Load‑Balancing Strategies, Connection Pooling and Performance Gains
Java Captain
Java Captain
Feb 14, 2021 · Databases

52 SQL Statement Performance Optimization Strategies

This article presents a comprehensive collection of 52 practical tips for optimizing SQL queries, covering index usage, query rewriting, data type selection, storage engine choices, transaction handling, and backup strategies to improve database performance and reduce resource consumption.

Performanceindexesoptimization
0 likes · 18 min read
52 SQL Statement Performance Optimization Strategies
NetEase Smart Enterprise Tech+
NetEase Smart Enterprise Tech+
Feb 14, 2021 · Frontend Development

Building a Frontend Logging Library for SaaS B2B to Accelerate Issue Resolution

To improve SaaS B2B product efficiency and revenue retention, the article examines the unique challenges of frontend development in enterprise services, proposes a client‑side logging library—woodpecker‑log—detailing its design, storage with IndexedDB, performance considerations, API, and integration for rapid customer issue diagnosis.

B2BFrontendPerformance
0 likes · 14 min read
Building a Frontend Logging Library for SaaS B2B to Accelerate Issue Resolution
Top Architect
Top Architect
Feb 12, 2021 · Backend Development

Performance Comparison of String and StringBuilder in Java Loops

The article presents a series of Java benchmarks that compare per‑iteration and cumulative string concatenation using String versus StringBuilder, explains why the compiler optimises String concatenation to StringBuilder, and draws conclusions about the most efficient usage patterns in loop‑heavy code.

/loopPerformancebenchmark
0 likes · 8 min read
Performance Comparison of String and StringBuilder in Java Loops
KooFE Frontend Team
KooFE Frontend Team
Feb 9, 2021 · Frontend Development

Which JavaScript Loop Is Fastest? Benchmark Results and Best Use Cases

This article compares the performance of common JavaScript looping constructs—including for, reverse for, forEach, for...of, for...in, and for...await—provides benchmark code on a million‑element array, explains the speed differences, and offers guidance on choosing the right loop for readability and maintainability.

JavaScriptLoopsPerformance
0 likes · 7 min read
Which JavaScript Loop Is Fastest? Benchmark Results and Best Use Cases
Liangxu Linux
Liangxu Linux
Feb 7, 2021 · Databases

Why MariaDB Outperforms MySQL: A Detailed Performance Comparison

This article traces MySQL’s evolution, introduces its fork MariaDB, and presents a comprehensive performance benchmark—covering single and batch inserts, indexed and non‑indexed queries—on identical hardware, revealing that MariaDB generally delivers faster execution times albeit with higher memory usage.

MariaDBMySQLPerformance
0 likes · 10 min read
Why MariaDB Outperforms MySQL: A Detailed Performance Comparison
Alibaba Terminal Technology
Alibaba Terminal Technology
Feb 7, 2021 · Game Development

What Makes Oasis Engine a Cutting‑Edge Web 3D Game Engine?

This article provides a comprehensive overview of Oasis Engine, detailing its component‑based architecture, TypeScript implementation, key features such as Transform, resource and shader systems, its stability and performance achievements, historical development phases, and future roadmap for cross‑platform and open‑source enhancements.

3D EngineComponent SystemOpen-source
0 likes · 13 min read
What Makes Oasis Engine a Cutting‑Edge Web 3D Game Engine?
Selected Java Interview Questions
Selected Java Interview Questions
Feb 6, 2021 · Databases

7 Reasons Why Docker Is Unsuitable for Deploying Databases

Although Docker offers many benefits, this article outlines seven key reasons—data safety, performance, networking, statefulness, resource isolation, cloud platform incompatibility, and environment requirements—that make deploying databases in Docker containers generally unsuitable, while also suggesting scenarios where lightweight or distributed databases may still be viable.

ContainerizationData SafetyPerformance
0 likes · 9 min read
7 Reasons Why Docker Is Unsuitable for Deploying Databases
AntTech
AntTech
Feb 5, 2021 · Databases

OceanBase 2020 Review: Record‑Breaking Performance, Independent Operation, Ecosystem Expansion, and Advanced Disaster‑Recovery

In 2020 OceanBase achieved a world‑record TPC‑C benchmark of 7.07 billion tpmC, spun off as an independent company, attracted dozens of marquee customers, built a four‑layer ecosystem, delivered ultra‑high performance for enterprises, and introduced Paxos‑based disaster‑recovery that guarantees RPO = 0 and minute‑level RTO.

EcosystemOceanBasePaxos
0 likes · 13 min read
OceanBase 2020 Review: Record‑Breaking Performance, Independent Operation, Ecosystem Expansion, and Advanced Disaster‑Recovery
Top Architect
Top Architect
Feb 4, 2021 · Backend Development

Performance Impact of Java Reflection: Empirical Tests and Analysis

This article empirically investigates whether Java reflection incurs performance penalties, describing a series of benchmark tests that compare direct method/field access with reflective calls, analyzing results, identifying the main cost factors, and offering practical guidelines to mitigate reflection overhead in production code.

PerformanceReflectionbenchmark
0 likes · 11 min read
Performance Impact of Java Reflection: Empirical Tests and Analysis
Tencent Music Tech Team
Tencent Music Tech Team
Feb 4, 2021 · Mobile Development

Adapting the QQ Music/Karaoke Android App to Arm64 Architecture

The QQ Music/Karaoke team migrated their Android app from 32‑bit to Arm64‑v8a by reconfiguring Gradle builds, recompiling or replacing over 120 native libraries, extending the dynamic‑resource loader for ABI selection, implementing ABI‑aware update channels, and fixing issues such as library path limits, I/O reliability, camera latency, and WebView cache corruption, completing the transition in early 2021.

ARM64AndroidBuild configuration
0 likes · 27 min read
Adapting the QQ Music/Karaoke Android App to Arm64 Architecture
Architect's Tech Stack
Architect's Tech Stack
Feb 3, 2021 · Backend Development

Comparison of Java Microservice Frameworks: Spring Cloud, Vert.x, SparkJava, Micronaut, Javalin, and Quarkus

This article compares several Java microservice frameworks—including Spring Cloud, Vert.x, SparkJava, Micronaut, Javalin, and Quarkus—by describing their features, required infrastructure, and performance results from 30‑second stress tests, while also noting resource consumption and startup times.

PerformanceVert.xframework comparison
0 likes · 9 min read
Comparison of Java Microservice Frameworks: Spring Cloud, Vert.x, SparkJava, Micronaut, Javalin, and Quarkus
Top Architect
Top Architect
Feb 2, 2021 · Backend Development

Understanding Kafka Zero‑Copy and Parallel FileTransferTo Performance

This article explains Kafka's underlying storage architecture, details the zero‑copy transferTo technique in Java, compares traditional four‑copy I/O with zero‑copy, and presents parallel FileTransferTo performance tests on a multi‑core Linux system environment.

BackendFileTransferToPerformance
0 likes · 11 min read
Understanding Kafka Zero‑Copy and Parallel FileTransferTo Performance
Xianyu Technology
Xianyu Technology
Feb 2, 2021 · Frontend Development

Xianyu's Server-Side Rendering Architecture and Implementation

Xianyu’s server‑side rendering solution uses a serverless Node.js app on Alibaba Cloud to aggregate backend data and render HTML, routing through Nginx and caching via CDN, which cuts first‑meaningful‑paint time, maintains high stability with low O&M, and seamlessly falls back to client‑side rendering when needed.

FrontendNode.jsPerformance
0 likes · 10 min read
Xianyu's Server-Side Rendering Architecture and Implementation
Architect
Architect
Jan 31, 2021 · Fundamentals

Investigating the Performance Impact of Java Reflection

This article presents a series of benchmarks that compare direct method and field access with reflective calls in Java, analyzes where the performance overhead originates, and offers practical guidelines to mitigate reflection‑related slowdown in real‑world applications.

PerformanceReflectionbenchmark
0 likes · 9 min read
Investigating the Performance Impact of Java Reflection
Architect
Architect
Jan 29, 2021 · Fundamentals

Understanding Java Reflection: Concepts, Usage, and Performance Considerations

This article explains Java's reflection mechanism, its core classes, practical uses such as accessing private members and dynamic loading, demonstrates code examples, discusses performance, security and compatibility issues, and provides guidance for Android developers.

AndroidCode ExamplePerformance
0 likes · 11 min read
Understanding Java Reflection: Concepts, Usage, and Performance Considerations
Top Architect
Top Architect
Jan 28, 2021 · Backend Development

Deep Dive into Caffeine Cache: High‑Performance Design, W‑TinyLFU Algorithm, and Implementation Details

This article explains Caffeine, a high‑performance Java local cache, comparing it with Guava Cache, detailing its W‑TinyLFU eviction policy, asynchronous read/write buffers, timer‑wheel expiration, and provides extensive source code analysis to illustrate its design and optimization techniques.

AlgorithmsCacheCaffeine
0 likes · 36 min read
Deep Dive into Caffeine Cache: High‑Performance Design, W‑TinyLFU Algorithm, and Implementation Details
MaGe Linux Operations
MaGe Linux Operations
Jan 27, 2021 · Operations

How to Cut Nginx HTTPS Latency by 30%: Practical TLS Tuning Guide

This article explains why Nginx HTTPS latency matters for instant search, describes how TLS handshake round‑trips affect response time, and provides step‑by‑step Nginx TLS configuration tweaks—including HTTP/2, cipher ordering, OCSP stapling, buffer sizing, and session caching—that together reduced real‑world latency by about 30%.

HTTP2HTTPSLatency
0 likes · 13 min read
How to Cut Nginx HTTPS Latency by 30%: Practical TLS Tuning Guide
vivo Internet Technology
vivo Internet Technology
Jan 27, 2021 · Backend Development

Caffeine Cache: Principles, High‑Performance Read/Write, and Practical Usage in Java

Caffeine is a high‑performance Java 8 local‑cache library that replaces Guava by using the W‑TinyLFU algorithm with three‑queue LRU structures and lock‑free read/write buffers, offering extensive configuration, dynamic runtime adjustments, and safe back‑source loading with distributed locks to prevent cache‑stampede.

CacheCaffeinePerformance
0 likes · 13 min read
Caffeine Cache: Principles, High‑Performance Read/Write, and Practical Usage in Java
21CTO
21CTO
Jan 26, 2021 · Fundamentals

Mastering the 21 Essential Software Architecture Characteristics

This article explains the twenty‑one key non‑functional characteristics of software architecture—such as performance, reliability, scalability, security and maintainability—detailing their definitions, typical metrics, and practical techniques for improvement, while linking each trait to ISO‑25010 and real‑world engineering practices.

DevOpsNon-functional RequirementsPerformance
0 likes · 20 min read
Mastering the 21 Essential Software Architecture Characteristics
Didi Tech
Didi Tech
Jan 25, 2021 · Big Data

Migrating Hive SQL to Spark SQL: Design, Implementation, and Performance Evaluation at DiDi

DiDi migrated over 10,000 Hive SQL tasks to Spark SQL using a lightweight dual‑run pipeline that extracts, rewrites, compares, and switches tasks, fixing syntax and UDF differences while adding features such as small‑file merging and enhanced partition pruning, resulting in Spark handling 85 % of workloads with 40 % faster execution, 21 % lower CPU and 49 % lower memory usage.

DataMigrationPerformanceSQLOptimization
0 likes · 18 min read
Migrating Hive SQL to Spark SQL: Design, Implementation, and Performance Evaluation at DiDi
Programmer DD
Programmer DD
Jan 25, 2021 · Backend Development

Spotting and Solving Backend Bottlenecks: Nginx, Tomcat, Redis, MySQL

This article walks through systematic analysis of backend performance bottlenecks across a typical Nginx‑Tomcat‑Redis‑MySQL stack, covering bandwidth limits, OS ulimit settings, kernel TCP parameters, Nginx connection limits, Tomcat connector modes, Redis key handling, and MySQL query and hardware issues.

NGINXPerformanceTomcat
0 likes · 11 min read
Spotting and Solving Backend Bottlenecks: Nginx, Tomcat, Redis, MySQL