Best of Performance — August 2025

1. 1
   Article

   Jobs·33w

   🚨How one tiny SQL query nearly killed our production system 🚨

   A production outage caused by a seemingly innocent `SELECT *` query demonstrates how database queries that work fine in development can fail catastrophically at scale. The query pulled 720MB of data from 60,000+ records, causing memory pressure, network bottlenecks, and connection timeouts. The post provides practical solutions including selecting specific columns, implementing pagination, caching hot data, using EXPLAIN plans, monitoring slow queries, and testing with production-scale data.

   319

   33
2. 2
   Article

   Next.js·34w

   Next.js 15.5

   Next.js 15.5 introduces Turbopack builds in beta with significant performance improvements (2-5x faster builds), stable Node.js middleware runtime support, enhanced TypeScript features including typed routes and automatic route props helpers, deprecation of the next lint command in favor of direct ESLint usage, and deprecation warnings for features being removed in Next.js 16 including AMP support and legacyBehavior for links.

   203

   8
3. 3
   Article

   Laravel News·35w

   Filament v4 is Stable!

   Filament v4 has been officially released as stable, bringing significant performance improvements including 3x faster table rendering for large datasets. Key new features include unified Schemas that combine form fields, infolist entries, and layout components; custom data tables that support non-Model-backed data with full pagination, search, and sorting capabilities; and a unified Actions namespace that eliminates import confusion. The release also introduces partial rendering solutions and automated upgrade scripts to ease migration from v3.

   122

   4
4. 4
   Article

   CSS Wizardry·36w

   The Fastest Site in the Tour de France – CSS Wizardry

   A comprehensive analysis of website performance across 21 bike manufacturers competing in the 2025 Tour de France, using Core Web Vitals metrics and a proprietary CrRRUX scoring system. Merida topped the rankings with perfect scores, followed by Factor and Giant, while traditional brands like Trek and Ridley struggled with client-side rendering issues. The study reveals that simpler, traditional web architectures often outperform modern JavaScript-heavy frameworks in terms of loading speed, interactivity, and visual stability.

   106

   2
5. 5
   Article

   Netguru·37w

   React Performance Optimization: Techniques Senior Developers Use

   Advanced React performance optimization techniques including component memoization with PureComponent and React.memo, Redux selector optimization with Reselect, avoiding prop mutations, using useDeferredValue for responsive UIs, profiling with React DevTools and Chrome Performance tab, production optimizations like tree shaking and lazy loading, and strategic code splitting patterns.

   89
6. 6
   Article

   Hacker News·33w

   You should buy a faster CPU

   Modern CPUs have become dramatically faster, with desktop processors offering up to 10x performance improvements over older laptop chips. The author argues that investing in top-tier CPUs like the AMD Ryzen 9950X ($500) provides better value than AI coding subscriptions ($480/year) for developer productivity. Benchmarks show desktop CPUs are roughly 3x faster than laptops, and current generation processors are 3x faster than models from 3 years ago, making build times significantly shorter and development workflows more efficient.

   86

   16
7. 7
   Video

   Awesome·35w

   Postgres 18 just dropped. Now is the best time to learn it...

   PostgreSQL 18 introduces significant performance improvements through asynchronous I/O support, delivering 2-3x better performance in read-heavy applications. Key features include smarter query optimization for OR/IN clauses, enhanced hash joins, virtual generated columns as default, UUID version 7 support with timestamp ordering, improved RETURNING clause functionality, and temporal constraints with WITHOUT OVERLAPS. The upgrade process is now smoother with preserved statistics, eliminating the need to rebuild planner statistics after major version upgrades.

   85

   5
8. 8
   Article

   TkDodo·36w

   React Query Selectors, Supercharged

   React Query's select option enables fine-grained subscriptions by allowing components to subscribe only to specific parts of query data rather than the entire response. This prevents unnecessary re-renders when unrelated data changes. The feature supports structural sharing for referential stability and can be optimized further using useCallback for stable function references and external memoization libraries like fast-memoize to prevent expensive transformations from running multiple times across different QueryObservers. TypeScript support requires careful handling of generic type parameters to maintain type safety while allowing flexible selector abstractions.

   77

   3
9. 9
   Article

   AppSignal·33w

   Smooth Async Transitions in React 19

   React 19's async transitions using the useTransition hook enable non-blocking form experiences by marking state updates as low priority. This keeps the UI responsive during API calls and async operations. The feature supports optimistic updates for instant feedback, integrates with Server Actions for simplified server communication, and provides granular control over urgent vs non-urgent updates. Key benefits include maintaining form interactivity during submissions, graceful error handling, and improved perceived performance on slow networks or devices.

   75

   2
10. 10
    Article

    Hacker News·36w

    comptime.ts — compile-time expressions for TypeScript

    comptime.ts is a TypeScript compiler that enables compile-time evaluation of expressions marked with 'comptime', moving computations from runtime to build time for performance optimization. It supports Vite and Bun bundlers, offers CLI and API usage, and can handle promises and complex expressions. The tool requires JSON-serializable return values and provides safety warnings about compile-time code execution.

    74

    1
11. 11
    Article

    Collections·35w

    Comprehensive Guide to Next.js 15 Caching and Rendering Strategies

    Next.js 15 offers multiple rendering strategies including Server-Side Rendering (SSR) for faster initial loads and better SEO, Client-Side Rendering (CSR) for interactive applications, Static Site Generation (SSG), and Incremental Static Regeneration (ISR). The framework enhances performance through advanced caching mechanisms like Request Memoization, Data Cache, Full Route Cache, and Router Cache. These features enable developers to build efficient web applications by choosing the optimal rendering approach based on specific requirements.

    70

    4
12. 12
    Article

    Bun·34w

    500x faster postMessage(string)

    Bun v1.2.21 introduces a zero-copy optimization for postMessage(string) that achieves up to 500x faster performance and 22x less memory usage by avoiding serialization for thread-safe strings. The optimization works by directly sharing immutable string pointers between threads in JavaScriptCore, bypassing the Structured Clone Algorithm for strings that aren't atoms, substrings, or rope strings. This dramatically improves performance for common patterns like sending JSON between workers, with the optimization automatically applying to strings over 256 characters.

    68
13. 13
    Article

    DevBlogs·35w

    PowerToys 0.93 is here: faster Command Palette, new dashboard UX and more

    PowerToys 0.93 introduces significant performance improvements through AOT compilation, reducing startup memory by 15%, load time by 40%, and installation size by 55%. The release features a redesigned Settings dashboard with clearer utility toggles and shortcuts, a new Spotlight mode for Mouse Highlighter that dims the entire screen except around the cursor, and enhanced Command Palette functionality including restored clipboard history and app pinning capabilities.

    66

    1
14. 14
    Article

    Awesome Go·36w

    How I Made Europe Searchable From a Single Server - The Story of HydrAIDE

    A developer built HydrAIDE, a custom data engine that indexes millions of European websites from a single server using only 3% CPU load. Instead of traditional databases, the system uses thousands of small binary files for O(1) data access, leveraging modern SSD performance. The engine powers precise B2B partner searches across Europe and is now open-source with Go SDK support and Python/Node.js SDKs in development.

    63

    2
15. 15
    Article

    Lobsters·34w

    This Website is Served from Nine Neovim Buffers on My Old ThinkPad

    A developer created a Neovim plugin that serves HTTP requests directly from editor buffers using pure Lua. The plugin leverages Neovim's libuv bindings for asynchronous I/O and surprisingly outperforms Nginx in benchmarks due to LuaJIT's efficiency and NaN tagging optimization. The implementation serves a static website from nine buffers on a 2012 ThinkPad, with security measures including Docker containerization, AppArmor profiles, and restricted system calls. The setup demonstrates how text editors can be repurposed for unconventional tasks while maintaining good performance.

    60

    3
16. 16
    Article

    Hacker News·33w

    You no longer need JavaScript

    Modern CSS has evolved significantly with features like nesting, relative colors, container queries, and improved viewport units, making it possible to build interactive web experiences without JavaScript. The post demonstrates practical examples including theming, form validation, animations, and responsive design using only HTML and CSS, while highlighting performance benefits and accessibility advantages of CSS-only solutions.

    58

    17
17. 17
    Article

    Go·34w

    The Go Programming Language

    Go 1.25 introduces container-aware GOMAXPROCS defaults that automatically adjust based on container CPU limits instead of total machine cores. This prevents CPU throttling in containerized environments, improves tail latency, and provides better out-of-the-box behavior for production workloads. The runtime now periodically checks and adjusts GOMAXPROCS when CPU limits change, while still allowing manual override through environment variables or runtime calls.

    54

    1
18. 18
    Article

    Bytes by ui.dev·35w

    TypeScript gets lean

    TypeScript 5.9 introduces several improvements including a cleaner tsc --init command that generates minimal configuration files, new import defer syntax for conditional module loading, enhanced VS Code tooltips with expandable type information and MDN documentation, and performance optimizations through better caching and reduced file system checks. The release focuses on making TypeScript projects lighter and more developer-friendly.

    50

    9
19. 19
    Article

    Medium·36w

    FrankenPHP vs PHP-FPM (Part 3): CPU, Memory, and the Hidden Cost of Doing Nothing

    A comprehensive performance comparison between FrankenPHP and PHP-FPM focusing on CPU and memory usage patterns during both active load and idle states. The analysis reveals that FrankenPHP with worker mode delivers 3x better throughput and 60% lower latency than PHP-FPM, but consumes more memory even when idle (85MB vs 25MB). PHP-FPM excels for low-traffic applications due to minimal resource usage when inactive, while FrankenPHP becomes more cost-effective for high-traffic scenarios due to its persistent application state and reduced per-request overhead.

    41

    7
20. 20
    Article

    Laravel News·33w

    Smart Cache Package for Laravel

    SmartCache is a Laravel package that automatically optimizes cache storage for large datasets through intelligent compression, chunking, and serialization. It provides driver-aware optimization strategies for Redis, file, and database caches, automatically detecting when optimization is needed and seamlessly reconstructing data on retrieval. The package includes features like gzip compression, performance monitoring, and extensible strategy patterns for custom optimizations.

    39

    1
21. 21
    Article

    Collections·35w

    Go 1.25 Released with Performance and Feature Enhancements

    Go 1.25 introduces significant performance improvements including an experimental garbage collector that reduces GC overhead by 10-40%, container-aware GOMAXPROCS for better containerized performance, new testing/synctest package for concurrent code testing, experimental encoding/json/v2 with enhanced performance, runtime optimizations for slice allocations and crypto operations, and compiler improvements with DWARF5 debug support for smaller binaries.

    36
22. 22
    Video

    ForrestKnight·34w

    Why Everyone's Switching to Rust (And Why You Shouldn't)

    Rust offers memory safety without garbage collection through its borrow checker, delivering C-like performance with Java-like safety. Major companies like Discord, Dropbox, and Microsoft have seen significant performance improvements after rewriting systems in Rust. However, Rust has a steep 3-6 month learning curve and may not be suitable for rapid prototyping or teams with tight deadlines. The TypeScript team chose Go over Rust for practical reasons despite acknowledging Rust's technical superiority. While Rust excels in performance-critical and security-sensitive applications, the choice of programming language should depend on specific project requirements rather than following trends.

    34

    2
23. 23
    Article

    DevShareVietNam·33w

    Smooth Animations in React Native Without Extra Libraries

    Learn how to create smooth animations in React Native using built-in APIs without relying on external animation libraries. The tutorial demonstrates native animation techniques that can improve app performance and user experience while keeping dependencies minimal.

    27
24. 24
    Article

    Platformatic·34w

    Boost Node.js HTTP Requests Efficiency

    Redis-backed HTTP caching solution for Node.js applications using Undici that provides 550x+ performance improvements over uncached requests. The undici-cache-redis library offers enterprise-grade caching with automatic cache invalidation, tag-based cache management, and dual-layer architecture combining local memory cache with Redis persistence. Features include seamless integration with both fetch() and agent.request(), intelligent cache invalidation based on HTTP headers, and shared caching across multiple servers without operational overhead.

    24
25. 25
    Article

    Hacker News·33w

    sping Documentation

    Sping is a modern terminal-based HTTP/TCP latency monitoring tool that provides real-time visualization with interactive charts, outlier detection using Median Absolute Deviation analysis, and comprehensive phase timing breakdowns. It supports HTTP, HTTPS, and TCP protocols with features like customizable color palettes, authentication, threshold alerts, and multiple output formats including JSON for automation. The tool offers detailed connection phase analysis (DNS, connect, TLS, request, response) and includes advanced monitoring capabilities with percentile statistics and export functionality.

    22