BestHub
Sign in
Tagged articles

Performance

5000 articles · Page 20 of 50
Tencent Cloud Developer
Tencent Cloud Developer
May 23, 2024 · Backend Development

How WeChat Red‑Packet Random Algorithms Work: Simple Random, Double‑Mean & Segment Split

This article examines the main algorithms behind WeChat's red‑packet distribution—plain random, double‑mean, and segment‑split (including an optimized version), explains their PHP implementations, validates array_rand's randomness, and compares their performance and fairness through code examples and timing tests.

Performancearray_randphp
0 likes · 12 min read
How WeChat Red‑Packet Random Algorithms Work: Simple Random, Double‑Mean & Segment Split
ITPUB
ITPUB
May 21, 2024 · Databases

Can ClickHouse Distributed Tables Outperform Single-Node Tables? A Real-World Benchmark

This article presents a systematic benchmark comparing ClickHouse local (single‑node) tables and distributed tables across three data volumes—≈60 billion, 5 billion and 50 million rows—using a variety of aggregation and filter queries, and reveals that distributed tables dominate at large scale while the gap narrows as the dataset shrinks.

BenchmarkClickHouseDistributed Tables
0 likes · 13 min read
Can ClickHouse Distributed Tables Outperform Single-Node Tables? A Real-World Benchmark
JD Cloud Developers
JD Cloud Developers
May 21, 2024 · Databases

How to Refactor Complex SQL Like Java Code: A Real‑World Case Study

This article demonstrates how to refactor a complex, production‑level SQL query used in a routing system by formatting, decomposing into layers, merging temporary tables, pushing predicates, optimizing joins, and validating performance, ultimately reducing nesting from four levels to one and cutting execution time from 4.75 s to 0.6 s.

DatabaseJOINOptimization
0 likes · 15 min read
How to Refactor Complex SQL Like Java Code: A Real‑World Case Study
Su San Talks Tech
Su San Talks Tech
May 20, 2024 · Backend Development

Mastering Java Optional: When to Use It and Common Pitfalls

This article explores the proper usage of Java's Optional class, debunks common misconceptions, examines its internal implementation, compares methods like map, orElse, orElseGet, and provides practical code examples to help developers avoid null‑pointer pitfalls and write cleaner backend code.

Code ExampleJavaNullPointerException
0 likes · 11 min read
Mastering Java Optional: When to Use It and Common Pitfalls
Liangxu Linux
Liangxu Linux
May 19, 2024 · Operations

Master Linux System Monitoring: Top, Free, vmstat, iostat, and More

This comprehensive guide explains how to use essential Linux monitoring commands—top, free, vmstat, iostat, mpstat, sar, netstat, uptime, ps, watch, strace, and lsof—detailing their purpose, key parameters, interactive shortcuts, and how to interpret their output for effective system performance analysis.

CLILinuxPerformance
0 likes · 34 min read
Master Linux System Monitoring: Top, Free, vmstat, iostat, and More
ITPUB
ITPUB
May 19, 2024 · Databases

Why Redis Can Slow Down Your App and How to Fix It

This article explains common Redis performance pitfalls—including per‑command network latency, expensive commands like SUNION and KEYS, mass key expiration spikes, and big‑key deletions—and provides practical techniques such as MSET batching, randomizing expirations, and using UNLINK to keep your backend fast.

DatabaseOptimizationPerformance
0 likes · 8 min read
Why Redis Can Slow Down Your App and How to Fix It
Python Programming Learning Circle
Python Programming Learning Circle
May 17, 2024 · Databases

SQL Optimization Tips and Best Practices

This article presents a comprehensive collection of MySQL performance guidelines, covering query writing, index usage, join strategies, data types, batch operations, and execution plan analysis to help developers write faster and more reliable SQL statements.

OptimizationPerformanceSQL
0 likes · 19 min read
SQL Optimization Tips and Best Practices
Java Tech Enthusiast
Java Tech Enthusiast
May 17, 2024 · Fundamentals

Understanding Computer Time Units, CPU Cycles and Performance Latency

The article explains that software performance is measured in milliseconds to nanoseconds, describes core hardware components—CPU, caches, and DRAM—shows how cache hierarchy speeds differ, defines a clock cycle as the basic time unit, and provides typical latency figures for operations ranging from a single CPU cycle to a full system reboot.

CPU cyclesPerformancelatency
0 likes · 7 min read
Understanding Computer Time Units, CPU Cycles and Performance Latency
Bilibili Tech
Bilibili Tech
May 17, 2024 · Mobile Development

Cross‑Platform Language Benchmark and Interoperability Analysis

The study benchmarks Kotlin, JavaScript, Dart, C++ and Swift across iOS, Android and HarmonyOS using 237 protobuf files, finding Kotlin’s performance and binary size rival native Swift, JavaScript slower with higher memory, while C++/Rust excel but need more effort, leading to a recommendation of Kotlin Multiplatform with a three‑repo structure for optimal reuse and maintainability.

BenchmarkKotlinPerformance
0 likes · 30 min read
Cross‑Platform Language Benchmark and Interoperability Analysis
Code Ape Tech Column
Code Ape Tech Column
May 17, 2024 · Backend Development

Migrating from Fastjson to Gson: Practical Guide, Pitfalls and Solutions

This article documents a month‑long effort to replace Fastjson with Gson in Java projects, analyzing security vulnerabilities, comparing performance and features of Fastjson, Jackson and Gson, and providing detailed migration steps, code examples, and solutions to common issues such as date handling, SpringBoot integration, Swagger compatibility and numeric type conversion.

GsonMigrationPerformance
0 likes · 19 min read
Migrating from Fastjson to Gson: Practical Guide, Pitfalls and Solutions
Laravel Tech Community
Laravel Tech Community
May 16, 2024 · Backend Development

Comprehensive Guide to Full-Page, Partial, and Memory Caching Techniques for PHP Applications

This article explains various server‑side caching strategies—including full‑page static caching, fragment caching, data and query caching, time‑based and content‑change invalidation, as well as memory caches like Memcached and Redis, Apache modules, APC, and opcode caches—providing PHP code examples for each method.

MemcachedOpcode CachePerformance
0 likes · 7 min read
Comprehensive Guide to Full-Page, Partial, and Memory Caching Techniques for PHP Applications
Selected Java Interview Questions
Selected Java Interview Questions
May 16, 2024 · Backend Development

Rethinking Microservices in 2023: From Google’s “Microservices 2.0” to Amazon’s Monolith Shift

In 2023, leading cloud giants like Google and Amazon publicly questioned the value of microservices, presenting new “Microservices 2.0” principles and monolithic alternatives that promise dramatically lower latency, cost, and operational complexity while reshaping backend architecture debates.

Performancecloud-nativemicroservices
0 likes · 12 min read
Rethinking Microservices in 2023: From Google’s “Microservices 2.0” to Amazon’s Monolith Shift
DataFunTalk
DataFunTalk
May 14, 2024 · Cloud Computing

Hybrid Cloud Architecture and AI Storage Evolution at Zhihu: From UnionStore to Alluxio

This article describes Zhihu's hybrid cloud architecture—including offline, online, and GPU data centers—its self‑built UnionStore cache, the performance and latency challenges faced during large‑scale AI model training, and the subsequent evaluation and migration to Alluxio community and enterprise editions to achieve higher throughput, stability, and lower operational overhead.

AI storageAlluxioBig Data
0 likes · 14 min read
Hybrid Cloud Architecture and AI Storage Evolution at Zhihu: From UnionStore to Alluxio
Qunar Tech Salon
Qunar Tech Salon
May 13, 2024 · Operations

Root Cause Analysis of Intermittent Timeout Issues in the Sirius Service Caused by RAID Card Consistency Checks

This article details the investigation of sporadic interface timeouts in the Sirius real‑time pricing service, revealing a weekly pattern linked to RAID controller consistency checks that cause IO spikes, logback queue blockage, and ultimately Dubbo client‑side timeouts, and proposes mitigation steps and general performance‑troubleshooting guidelines.

OperationsPerformanceRAID
0 likes · 22 min read
Root Cause Analysis of Intermittent Timeout Issues in the Sirius Service Caused by RAID Card Consistency Checks
php Courses
php Courses
May 13, 2024 · Backend Development

The Current State and Future Trends of PHP in Web Development

This article examines PHP’s evolution over the past two decades, outlines its present strengths such as performance gains in PHP 7 and community vitality, and explores emerging trends—including modern language features, cloud‑native integration, serverless adoption, and performance optimization—that will shape its future role in backend web development.

ModernizationPerformanceServerless
0 likes · 7 min read
The Current State and Future Trends of PHP in Web Development
Architect
Architect
May 11, 2024 · Backend Development

7 Common Cache Pitfalls and Practical Solutions

This article systematically examines seven typical cache problems—penetration, breakdown, avalanche, data inconsistency, big‑key, hot‑key, and low hit rate—explaining their root causes, illustrating concrete scenarios with diagrams and code, and presenting step‑by‑step mitigation techniques such as parameter validation, Bloom filters, locking, auto‑renewal, random expirations, high‑availability setups, and cache warm‑up.

CacheData ConsistencyPerformance
0 likes · 22 min read
7 Common Cache Pitfalls and Practical Solutions
php Courses
php Courses
May 11, 2024 · Backend Development

Leveraging Laravel Queues for High‑Performance Backend Applications

In today's digital era, Laravel queues enable backend applications to offload time‑consuming tasks, improve performance, enhance scalability, and deliver a smooth, responsive user experience, making them an essential tool for modern web development.

Performancelaravelqueues
0 likes · 7 min read
Leveraging Laravel Queues for High‑Performance Backend Applications
Ops Development & AI Practice
Ops Development & AI Practice
May 9, 2024 · Backend Development

Boost System and Driver Performance: Combining Go with Assembly

This article explains how integrating Go with assembly language can overcome Go's performance and low‑level control limits for system and driver development, covering basic concepts, integration methods, multi‑CPU architecture support, practical code examples, and the resulting performance and portability benefits.

AssemblyDriver DevelopmentGo
0 likes · 6 min read
Boost System and Driver Performance: Combining Go with Assembly
Java Captain
Java Captain
May 8, 2024 · Databases

Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

A real‑world MySQL case study shows how using INSERT INTO SELECT for large‑scale data migration without proper indexing caused full‑table scans, lock contention, and data loss, highlighting the need for careful query planning and performance testing.

Data MigrationDatabaseINSERT INTO SELECT
0 likes · 6 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration
Aikesheng Open Source Community
Aikesheng Open Source Community
May 7, 2024 · Databases

Why Expanding a MySQL VARCHAR Column from 63 to 64 Characters Takes Much Longer

The article investigates why altering a MySQL VARCHAR column from a length that fits within 255 bytes to one that exceeds this limit (e.g., VARCHAR(63) to VARCHAR(64) in utf8mb4) triggers a costly copy operation, analyzes the storage mechanics, reproduces the issue, and provides practical recommendations to avoid performance penalties.

Database AdministrationMySQLOnline DDL
0 likes · 13 min read
Why Expanding a MySQL VARCHAR Column from 63 to 64 Characters Takes Much Longer
Su San Talks Tech
Su San Talks Tech
May 6, 2024 · Databases

Why Redis Is Lightning Fast: Deep Dive into Its Core Architecture

This article explores why Redis delivers ultra‑high performance by examining its in‑memory design, single‑threaded event loop, efficient data structures such as hash tables, SDS strings, ziplist, quicklist, and skiplist, as well as its encoding strategies and I/O multiplexing model.

Data StructuresI/O multiplexingIn-Memory Database
0 likes · 21 min read
Why Redis Is Lightning Fast: Deep Dive into Its Core Architecture
Ops Development & AI Practice
Ops Development & AI Practice
May 3, 2024 · Backend Development

Boost Go Performance with the Experimental arena Package: Design, Usage, and Benchmarks

This article explores Go's experimental arena library, detailing its design principles, core features such as fast allocation and memory reuse, suitable use cases like object pools and game development, provides a practical code example, and discusses performance benefits and limitations for high‑concurrency applications.

ArenaGoMemory Management
0 likes · 5 min read
Boost Go Performance with the Experimental arena Package: Design, Usage, and Benchmarks
Liangxu Linux
Liangxu Linux
May 2, 2024 · Operations

Essential Linux Monitoring Tools and How to Use Them

This guide introduces essential Linux monitoring commands such as top, htop, vmstat, iostat, sar, netstat, iftop, tcpdump, and Glances, explains their usage with example code, and shows how to analyze logs and create custom scripts for comprehensive system performance tracking.

LinuxPerformancesystem monitoring
0 likes · 7 min read
Essential Linux Monitoring Tools and How to Use Them
Architect's Guide
Architect's Guide
May 1, 2024 · Fundamentals

Effect of Placing try‑catch Inside vs Outside a for Loop in Java

This article explains the behavioral and performance differences of positioning a try‑catch block either outside or inside a Java for‑loop, illustrating each case with code examples, execution results, memory analysis, and practical recommendations for handling exceptions during batch processing.

JavaPerformanceexception handling
0 likes · 5 min read
Effect of Placing try‑catch Inside vs Outside a for Loop in Java
Selected Java Interview Questions
Selected Java Interview Questions
Apr 29, 2024 · Backend Development

Why Spring BeanUtils.copyProperties Is Discouraged and MapStruct Is Preferred for Java Object Mapping

The article explains the limitations of Spring's BeanUtils.copyProperties—such as type mismatches, null overwriting, and reflection overhead—and demonstrates how MapStruct provides a faster, compile‑time generated alternative for copying properties between Java objects, with usage examples and Maven setup.

BeanUtilsJavaObject Mapping
0 likes · 6 min read
Why Spring BeanUtils.copyProperties Is Discouraged and MapStruct Is Preferred for Java Object Mapping
dbaplus Community
dbaplus Community
Apr 28, 2024 · Databases

Master‑Slave Replication & Read/Write Splitting in MySQL: Best Practices and Pitfalls

This article explains why read‑heavy internet services use MySQL master‑slave replication for read/write separation, describes the asynchronous replication process, discusses latency side‑effects, and offers practical strategies such as data redundancy, caching, and direct master queries to mitigate delays.

MySQLPerformanceRead Write Splitting
0 likes · 11 min read
Master‑Slave Replication & Read/Write Splitting in MySQL: Best Practices and Pitfalls
MaGe Linux Operations
MaGe Linux Operations
Apr 28, 2024 · Operations

Master HTTP Load Testing with wrk: Install, Commands, and Lua Scripting

This guide walks you through installing the wrk load‑testing tool on Unix‑like systems, explains its core command‑line options, shows how to interpret benchmark results, and demonstrates advanced customization using Lua scripts for POST requests, dynamic parameters, authentication, and HTTP pipelining.

HTTPLua ScriptingPerformance
0 likes · 14 min read
Master HTTP Load Testing with wrk: Install, Commands, and Lua Scripting
Lobster Programming
Lobster Programming
Apr 27, 2024 · Databases

Essential MySQL Optimization: SQL Tricks and Parameter Tuning

This guide covers practical MySQL performance improvements, detailing SQL-level optimizations such as limit pagination, proper LIKE usage, UNION ALL, EXISTS vs IN, TRUNCATE, batch inserts, early filtering, function placement, data type minimization, CHAR/VARCHAR choices, indexing strategies, force index, as well as server parameter tuning for buffer pool and redo log settings.

MySQLPerformanceSQL Optimization
0 likes · 10 min read
Essential MySQL Optimization: SQL Tricks and Parameter Tuning
Architecture Development Notes
Architecture Development Notes
Apr 27, 2024 · Fundamentals

Master Rust Integer Types: When to Use i8, u64, isize and More

This comprehensive guide explores Rust’s signed and unsigned integer types, detailing their ranges, appropriate use cases, performance considerations, and provides practical code examples for type selection, conversions, arithmetic, and bitwise operations to help developers write efficient, safe Rust code.

Integer TypesPerformanceRust
0 likes · 8 min read
Master Rust Integer Types: When to Use i8, u64, isize and More
MaGe Linux Operations
MaGe Linux Operations
Apr 26, 2024 · Backend Development

Boost Go Performance: Proven Memory and Concurrency Optimizations

This article presents practical Go performance tips, covering memory‑allocation strategies, slice and map pre‑allocation, stack management, GC reduction, goroutine‑pool usage, avoiding blocking syscalls, and efficient string handling to minimize latency and resource consumption.

Performancememory-management
0 likes · 10 min read
Boost Go Performance: Proven Memory and Concurrency Optimizations
HelloTech
HelloTech
Apr 26, 2024 · Frontend Development

Understanding React Fiber Architecture: From React 15 to React 16

React 16 feels smoother than React 15 because its new Fiber architecture breaks state updates into small, priority‑aware units that the Scheduler runs asynchronously, allowing high‑priority user input to render first while lower‑priority work is paused and resumed, eliminating the lag seen in full‑tree re‑renders of React 15.

FiberFront-endPerformance
0 likes · 16 min read
Understanding React Fiber Architecture: From React 15 to React 16
Liangxu Linux
Liangxu Linux
Apr 25, 2024 · Databases

How MySQL’s B+ Tree Indexes Supercharge Query Speed and Reliability

MySQL, born in the 1990s as a free open‑source database, became a core component of the LAMP stack and remains widely used; the article explains why indexes are needed, compares binary trees, B‑trees and B+‑trees, and describes how modern cloud‑based MySQL services improve performance and reliability.

B+ treeData StructuresMySQL
0 likes · 9 min read
How MySQL’s B+ Tree Indexes Supercharge Query Speed and Reliability
Architect's Guide
Architect's Guide
Apr 24, 2024 · Databases

Redis Overview: Features, Data Types, Caching Strategies, Performance, Eviction Policies, Persistence, Replication, and Sentinel

This article provides a comprehensive introduction to Redis, covering its core features, supported data types, common caching use cases in Spring Boot, typical cache‑related problems such as consistency, avalanche, penetration and breakdown, as well as performance reasons, eviction policies, persistence mechanisms, master‑slave replication, and Sentinel high‑availability architecture.

DatabasePerformancePersistence
0 likes · 12 min read
Redis Overview: Features, Data Types, Caching Strategies, Performance, Eviction Policies, Persistence, Replication, and Sentinel
Liangxu Linux
Liangxu Linux
Apr 19, 2024 · Operations

Step-by-Step Guide to Diagnose High CPU Usage on Linux

This guide walks you through checking CPU usage, system load, resource consumption, problematic processes, system logs, and performance bottlenecks on a Linux server using common command‑line tools such as top, uptime, pidstat, strace, tail, and perf.

CPULinuxOperations
0 likes · 3 min read
Step-by-Step Guide to Diagnose High CPU Usage on Linux
Top Architect
Top Architect
Apr 19, 2024 · Databases

Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives

This article explains why using OFFSET and LIMIT for pagination becomes inefficient on large tables, illustrates the performance impact with examples, and proposes a cursor‑based pagination alternative that leverages indexed primary keys to achieve faster, scalable queries.

DatabaseLIMITPagination
0 likes · 8 min read
Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives
php Courses
php Courses
Apr 19, 2024 · Backend Development

Why PHP Remains a Viable Choice for Web Development in 2024

Despite perceptions of PHP as outdated, this article explains why its flexibility, strong community, performance improvements in PHP 8.1, rapid deployment, scalability, and clean-code frameworks like Laravel make it a practical and efficient backend solution for web development in 2024, while noting cases where other languages may be preferable.

PerformanceWeb Developmentbackend development
0 likes · 6 min read
Why PHP Remains a Viable Choice for Web Development in 2024
Architect
Architect
Apr 18, 2024 · Industry Insights

Why 2023 Signals Microservices' Decline: Lessons from Google, Amazon, DHH

2023 saw a wave of high‑profile tech leaders—Google’s engineers, Amazon Prime Video, and DHH—questioning the microservices paradigm, presenting data‑driven case studies that show dramatic latency and cost reductions when moving to monolithic or runtime‑managed architectures, and urging architects to reassess scalability versus complexity trade‑offs.

ArchitectureCost OptimizationPerformance
0 likes · 12 min read
Why 2023 Signals Microservices' Decline: Lessons from Google, Amazon, DHH
IT Services Circle
IT Services Circle
Apr 18, 2024 · Databases

Improving MySQL Insert Performance with Batch Operations and MyBatis Flex

This article explains how to boost MySQL insertion speed by adjusting server hardware, tuning database parameters, choosing the MyISAM engine, and especially applying three batch‑insert techniques—SQL concatenation, MyBatis‑Flex saveBatch, and manual transaction batching—while showing test results and configuration tips.

Batch InsertMyBatisMySQL
0 likes · 8 min read
Improving MySQL Insert Performance with Batch Operations and MyBatis Flex
Architect
Architect
Apr 17, 2024 · Databases

How We Split a 500‑Million‑Row MySQL Table: Process, Pitfalls, and Lessons

Facing a 50‑million‑row financial transaction table that grew 6 million rows per month, the team analyzed the problem, set clear split goals, evaluated sharding middleware, designed a custom pagination algorithm, built a hybrid data‑migration plan, and executed a three‑stage rollout to safely replace the monolithic table with multiple 10‑million‑row shards.

Database MigrationMySQLPerformance
0 likes · 13 min read
How We Split a 500‑Million‑Row MySQL Table: Process, Pitfalls, and Lessons
Zhuanzhuan Tech
Zhuanzhuan Tech
Apr 17, 2024 · Databases

Database Storage Optimization and Migration Strategy for ZhaiZhai Financial System

This article presents a comprehensive analysis of the ZhaiZhai financial system's growing data volume and slow‑query issues, evaluates four storage solutions—including sharding, hot‑cold separation, TiDB, and OceanBase—selects TiDB as the optimal choice, and details the migration steps and Elasticsearch integration to improve performance and scalability.

Data MigrationPerformanceTiDB
0 likes · 13 min read
Database Storage Optimization and Migration Strategy for ZhaiZhai Financial System
Code Ape Tech Column
Code Ape Tech Column
Apr 17, 2024 · Backend Development

Spring Boot Startup Configuration Principles, Extension Points, and Performance Optimizations

This article explains the core principles of Spring Boot startup configuration, demonstrates how to intervene using ApplicationContextInitializer, SpringApplicationRunListener, ApplicationRunner, and CommandLineRunner, and provides practical optimization techniques to significantly reduce application launch time.

ApplicationRunnerCommandLineRunnerConfiguration
0 likes · 32 min read
Spring Boot Startup Configuration Principles, Extension Points, and Performance Optimizations
21CTO
21CTO
Apr 16, 2024 · Artificial Intelligence

Why Go Developers Are Turning to AI Despite Python Dominance

A 2024 survey of Go developers reveals strong interest in building AI applications but frustration over Python's dominant ecosystem, highlighting performance priorities, tooling gaps, and a desire for Go libraries comparable to Python's, while also showing cloud platform preferences and IDE usage trends.

GoPerformancePython
0 likes · 5 min read
Why Go Developers Are Turning to AI Despite Python Dominance
Sanyou's Java Diary
Sanyou's Java Diary
Apr 15, 2024 · Databases

30 Proven SQL Optimization Tips to Boost Query Performance

This article presents thirty practical SQL optimization techniques, ranging from avoiding SELECT * and using LIMIT 1 to proper indexing, join strategies, and query rewriting, each illustrated with code examples and clear explanations to help developers write faster, more efficient database queries.

PerformanceQuery TuningSQL
0 likes · 28 min read
30 Proven SQL Optimization Tips to Boost Query Performance
DeWu Technology
DeWu Technology
Apr 15, 2024 · Mobile Development

Debugging Performance Degradation of Android 14 Debug Builds: Root Cause and Workarounds

The severe jank observed in Android 14 debug builds stems from the DEBUG_JAVA_DEBUGGABLE flag triggering DeoptimizeBootImage, which forces boot‑image methods onto the slow switch interpreter; a temporary hook clearing the flag and a permanent fix using UpdateEntrypointsForDebuggable restore performance, with Google planning an official fix in Android 15.

ARTAndroidDebugging
0 likes · 12 min read
Debugging Performance Degradation of Android 14 Debug Builds: Root Cause and Workarounds
JavaEdge
JavaEdge
Apr 13, 2024 · Backend Development

Mastering System Performance: Metrics, Strategies, and Real‑World Implementation

This article explains why performance optimization is essential for growing systems, introduces key metrics such as response time and concurrency, outlines systematic thinking and concrete techniques—including caching, parallelism, and async processing—and demonstrates a live‑streaming case study with actionable solutions.

OptimizationPerformancecaching
0 likes · 15 min read
Mastering System Performance: Metrics, Strategies, and Real‑World Implementation
21CTO
21CTO
Apr 12, 2024 · Databases

PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?

This article compares PostgreSQL and MySQL across history, ACID compliance, performance, scalability, advanced features, tooling, security, backup strategies, and Linux installation steps, helping full‑stack developers choose the most suitable open‑source relational database for their projects.

ACIDDatabase ComparisonLinux Installation
0 likes · 12 min read
PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?
Linux Cloud Computing Practice
Linux Cloud Computing Practice
Apr 12, 2024 · Databases

Why Is Redis So Fast? Uncover the Secrets Behind Its Performance

Redis achieves its remarkable speed through in‑memory storage, an efficient hash table design, single‑threaded execution that eliminates context switches, epoll‑based I/O multiplexing, progressive rehashing, and cached timestamps, all of which together enable near O(1) operations and minimal latency.

Hash TableIn-Memory DatabasePerformance
0 likes · 7 min read
Why Is Redis So Fast? Uncover the Secrets Behind Its Performance
Architecture Digest
Architecture Digest
Apr 12, 2024 · Databases

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

This article analyzes why MySQL recommends auto‑increment primary keys over UUIDs or random snowflake IDs by designing three tables, running insert‑select benchmarks with Spring Boot's JdbcTemplate, presenting the test results, and discussing the underlying index‑structure impacts and trade‑offs.

MySQLPerformanceauto_increment
0 likes · 10 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
iKang Technology Team
iKang Technology Team
Apr 11, 2024 · Cloud Native

Key Components of Unified API Gateway Management and Security – Apache Shenyu Overview

Apache Shenyu is a high‑performance, open‑source API gateway built on the reactive WebFlux framework that unifies API management and security through a flexible plugin architecture offering authentication, traffic control, circuit breaking, request rewriting, logging, and monitoring, while delivering extensibility, low latency, and future cloud‑native integration.

API-gatewayApache ShenYuPerformance
0 likes · 8 min read
Key Components of Unified API Gateway Management and Security – Apache Shenyu Overview
vivo Internet Technology
vivo Internet Technology
Apr 10, 2024 · Databases

Analysis of Redis Pipeline Support in Spring Boot with Lettuce and Redisson Clients

The article examines how Spring Boot’s Lettuce and Redisson clients implement Redis pipelining, explains the batch‑request principle, benchmarks 100 000 set inserts showing pipeline speeds of 0.5–1.4 seconds versus 162 seconds for single commands, demonstrates Spring Data Redis callback usage, warns of high‑cost command pitfalls, and details Redisson’s RBatch internals, concluding that pipelining dramatically boosts throughput when command costs are modest.

JavaLettucePerformance
0 likes · 27 min read
Analysis of Redis Pipeline Support in Spring Boot with Lettuce and Redisson Clients
Open Source Tech Hub
Open Source Tech Hub
Apr 9, 2024 · Backend Development

Is PHP Still Relevant in 2024? A Deep Dive into Its Role and Future

This article examines PHP's 2024 relevance by reviewing its historical rise, current market share, developer adoption, ecosystem strengths such as CMS dominance and modern frameworks, performance challenges, emerging technologies, and why the language remains a viable backend choice despite newer alternatives.

2024PerformanceWeb Development
0 likes · 21 min read
Is PHP Still Relevant in 2024? A Deep Dive into Its Role and Future
MaGe Linux Operations
MaGe Linux Operations
Apr 9, 2024 · Databases

How to Simulate and Prevent SQL Server Deadlocks: A Step-by-Step Guide

This article explains what SQL Server deadlocks are, why they occur, demonstrates a reproducible deadlock scenario with T‑SQL code, and provides practical strategies such as proper schema design, indexing, query optimization, shorter transactions, appropriate isolation levels, and monitoring to minimize deadlock occurrences.

DeadlockPerformanceSQL Server
0 likes · 9 min read
How to Simulate and Prevent SQL Server Deadlocks: A Step-by-Step Guide
Yum! Tech Team
Yum! Tech Team
Apr 9, 2024 · Backend Development

Optimizing High‑Concurrency Menu Services with Go sync.Pool Object Pool

This article explains the principles of object pools, details the internal implementation of Go's sync.Pool, and demonstrates through benchmarks how using an object pool can dramatically reduce memory allocation and latency for high‑traffic menu services in a restaurant ordering application.

BenchmarkGoMemory Management
0 likes · 13 min read
Optimizing High‑Concurrency Menu Services with Go sync.Pool Object Pool
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries

This article analyzes a slow NOT IN subquery that OceanBase rewrites into a NESTED‑LOOP ANTI JOIN, explains why HASH ANTI JOIN is not chosen due to NULL‑sensitive semantics and missing NOT NULL constraints, compares the behavior with Oracle's Null‑Aware Anti Join, and provides practical rewrite and hint‑based optimization recommendations.

Anti JoinOceanBaseOptimization
0 likes · 17 min read
Understanding Why OceanBase Cannot Use HASH ANTI JOIN and Optimizing NOT IN Queries
Architect's Guide
Architect's Guide
Apr 8, 2024 · Backend Development

Why HikariCP Is So Fast: A Deep Dive into Its Implementation

This article examines why HikariCP, the default Spring Boot 2.0 connection pool, achieves high performance by exploring its design concepts such as dual HikariPool instances, FastList, custom ConcurrentBag, thread‑local caching, and bytecode optimization, and includes sample Maven configuration and Java code.

Connection PoolHikariCPJava
0 likes · 14 min read
Why HikariCP Is So Fast: A Deep Dive into Its Implementation
ITPUB
ITPUB
Apr 7, 2024 · Databases

How to Choose the Right Database Management Tool: Expert DBA Insights

In this interview, a senior database operations manager shares why building a lightweight, purpose‑built tool is essential, outlines a systematic selection process based on clear operational needs, and highlights key criteria such as usability, security, and controllability while recommending practical solutions.

DBADatabase ToolsPerformance
0 likes · 8 min read
How to Choose the Right Database Management Tool: Expert DBA Insights
Deepin Linux
Deepin Linux
Apr 7, 2024 · Backend Development

High‑Performance Development: Core Techniques from I/O Optimization to Distributed Systems

This comprehensive guide covers high‑performance development techniques—including I/O optimization, zero‑copy, multiplexing, concurrency, thread‑pool design, lock‑free programming, inter‑process communication, RPC, serialization, database indexing, caching strategies, Bloom filters, full‑text search, and load balancing—to help developers build fast, scalable, and reliable systems.

Bloom filterI/O optimizationPerformance
0 likes · 62 min read
High‑Performance Development: Core Techniques from I/O Optimization to Distributed Systems
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Apr 7, 2024 · Frontend Development

My Frontend Engineering Practices and System

This article shares the author's practical experience with frontend engineering, covering topics such as project review, coding standards, monorepo tooling, custom CLI/SDK development, testing strategies, code review, bundling choices, monitoring, performance optimization, and knowledge consolidation for team empowerment.

EngineeringPerformancefrontend
0 likes · 18 min read
My Frontend Engineering Practices and System
MaGe Linux Operations
MaGe Linux Operations
Apr 6, 2024 · Backend Development

Boost Tomcat Performance: Essential JVM and Connector Tuning Tips

This guide explains why Tomcat’s default settings are unsuitable for production, then walks through JVM memory tuning, thread‑pool adjustments, connector optimizations, and security hardening to dramatically improve stability and throughput on various server configurations.

JVM tuningJavaPerformance
0 likes · 12 min read
Boost Tomcat Performance: Essential JVM and Connector Tuning Tips
Java Architect Essentials
Java Architect Essentials
Apr 2, 2024 · Backend Development

Understanding ForkJoinPool: Divide‑and‑Conquer, Implementation Details, and Performance Evaluation in Java

This article explains the Fork/Join model and Java's ForkJoinPool, covering the divide‑and‑conquer algorithm, custom RecursiveTask implementation, core pool design, task submission methods, work‑stealing mechanics, commonPool pitfalls, and performance testing with code examples and practical guidelines.

DivideAndConquerForkJoinPoolJava
0 likes · 25 min read
Understanding ForkJoinPool: Divide‑and‑Conquer, Implementation Details, and Performance Evaluation in Java
NewBeeNLP
NewBeeNLP
Apr 2, 2024 · Artificial Intelligence

Jamba: How AI21 Labs Merged Mamba and Transformer for 3× Faster 128k Contexts

Jamba, a hybrid Mamba‑Transformer model from AI21 Labs, combines state‑space and attention layers with Mixture‑of‑Experts to deliver up to three times the throughput of comparable 52‑billion‑parameter LLMs on 128k context windows while maintaining high output quality and low memory usage.

JambaLLMMamba
0 likes · 6 min read
Jamba: How AI21 Labs Merged Mamba and Transformer for 3× Faster 128k Contexts