Articles by tag: performance

ClickHouse skipping indexes: bloom, set, minmax

How ClickHouse skipping indexes speed up queries on columns outside ORDER BY. Breakdown of minmax, set, bloom_filter, ngrambf_v1, tokenbf_v1 with examples from gaming and EXPLAIN.

Dictionaries in ClickHouse: fast lookup without JOIN

How to use ClickHouse dictionaries to replace JOIN with microsecond in-memory lookup. Types: flat/hashed/range, data sources, dictGet, and examples for gambling.

Partitioning in ClickHouse: Strategies and Operations

How partitioning in ClickHouse accelerates DROP and data management. Choosing partition size, system.parts, DETACH/ATTACH, FREEZE, MOVE to SSD/HDD, and a script for deleting old data.

Picows: the fastest WebSocket for asyncio without compromises

Analysis of picows architecture — WebSocket library with zero-copy processing and minimal latency. For algorithmic trading and high-load systems. Learn how it works.

BufferPin conflicts in PostgreSQL: how to find and fix

Breaking down hidden BufferPin conflicts in PostgreSQL that affect replicas and autovacuum. Diagnostic, monitoring, and optimization methods for DBAs and developers.

Discriminated Unions in C#: Analysis and Optimization for Production

How to Create Efficient Discriminated Unions in C# Without Losing Performance. Comparison of OneOf, DuNet, and Custom Source Generator. Practical Cases.

Multithreading in Go: CPU, caches and performance | Analysis

How cache hierarchy and MESI protocol affect Go applications. Practical recommendations for optimizing multithreaded code. Learn more!

Legacy code optimization: reducing processing time by 99%

How to speed up processing of 75k records in a legacy system in 4 steps. Analysis of overhead costs, batch operations, batch setup and safe scaling. Practical case for Java developers.

Manticore Search Monitoring: Search Slowdown Diagnostics

How to Detect Hidden Search Slowdown in Manticore Search via Grafana. Pre-configured Dashboard Reduces Diagnostics Time from Hours to Minutes. Detailed Setup.

Kafka producer errors in Node.js: solutions and optimization

We analyze key issues when publishing messages to Kafka via KafkaJS in Node.js. Partitioning, network problems, large messages — practical solutions.

Heaps and priority queues: performance optimization

How binary and d-ary heaps on arrays provide high-speed operation of schedulers through cache locality. Practical comparisons and optimizations.

Web Components Issues: Memory and Speed

Breakdown of Web Components downsides: high memory consumption, slow DOM operations, reactivity issues. Comparison with $mol on TodoMVC benchmarks. Learn why JS objects are better for large applications.

SIMD optimization of Mandelbrot AVX2 OpenMP CUDA

Boosting the Mandelbrot set: from 7 FPS scalar C++ to 500+ FPS on CUDA. AVX2 intrinsics, OpenMP multithreading, GPU code. Benchmarks Ryzen 5 + RTX 3050. For middle/senior developers.

SearchValues and FrozenCollections in .NET 8 for optimization

Learn how SearchValues and FrozenCollections speed up search in .NET 8 hot paths. Benchmarks: 13x on strings, 2x on dictionaries. Instructions for developers with code examples.

Swift and Android Development Updates for the Week

Key mobile development news: Swift memory, Android bottlenecks, Gemma 4, Swift on Android SDK. For middle/senior dev. Study optimizations and new APIs.

Flutter Optimization: avoid rebuilds

Speed up your Flutter app: minimize rebuilds, use const, ListView.builder and AnimationController. Practical code examples for middle/senior devs. Maintain 60 FPS.

CPU 80% Diagnostics in ClickHouse

Tools for finding problematic queries in ClickHouse: system.processes, query_log, EXPLAIN. Diagnostics steps, SQL examples, checklist. Optimize load without downtime.

10 native web APIs instead of JS libraries

Learn how to replace Axios, Formik and Floating UI with built-in browser APIs. Code examples, browser support, use cases. Reduce bundle size and dependencies.

Web components issues: performance and API

Analysis of web components drawbacks: boilerplate, slow performance, global registration. Benchmarks and code for middle/senior developers. Why avoid them.

Load Testing: Checklist and Fails

Study the systematic approach to LT: from token race and 403 errors to stable 226 RPS. Checklist of DB, cache, frontend optimizations. For middle/senior dev. Start testing now.

Opcodes PHP: if vs switch vs match — comparison

Analysis of opcodes for if/else, switch and match in PHP. How the compiler generates instructions and when switch is really faster. For middle/senior developers.

Branch prediction in the processor: how to speed up code and avoid errors

Explanation of branch prediction in CPU, impact on performance, optimization methods and Spectre vulnerability. Learn how to speed up code.

Parser acceleration by 3 times: transition from Rust/WASM to TypeScript

Performance analysis: why abandoning WASM and porting the parser to TypeScript with an incremental algorithm resulted in 3x faster stream processing. Practical benchmarks and conclusions.

Hash tables and cache conflicts: benchmarks

Analysis of cache misses in hash tables: chaining vs probing, FNV-1a, Robin Hood. Benchmarks show a 3x speedup. Optimize data structures for real performance — read the details.

Stacks & Queues: Cache Optimization for Performance in C

Learn how to optimize stacks and queues in C for maximum speed. Compare arrays vs linked lists, implement fast ring buffers, and reduce cache misses by 35x.