Best of Performance — March 2024
- 1
- 2
- 3
Community Picks·2y
The Faster Redis Alternative
KeyDB is a fully open source database and a faster drop-in alternative to Redis. It offers high throughput, supports various data structures, has multiple persistence options, and is scalable to any workload. KeyDB also has open source features such as MVCC non-blocking architecture, cross-region multi-master support, better EXPIRation, TLS encryption, and ModJS for creating custom commands.
- 4
DEV·2y
Processing One Billion Rows in PHP!
This post discusses the author's experience in optimizing a PHP script to process one billion rows of data. The initial naive implementation took 25 minutes to run, but through various optimizations, the runtime was reduced to 27.7 seconds. The optimizations included using fgets() instead of fgetcsv(), using references where possible, adding type casts, enabling JIT, and implementing multithreading.
- 5
10 Cool SQL Optimisations That do not Depend on the Cost Model
The post evaluates 10 SQL optimizations that do not depend on the cost model. It discusses the applications and support for transitive closure, removing 'silly' predicates, JOIN elimination, provably empty sets, and more.
- 6
- 7
- 8
- 9
- 10
- 11
- 12
Collections·2yWhat to Expect in React 19: A Major Release with Exciting Improvements
React 19 is an upcoming major release with exciting improvements such as a new compiler for better performance and easier work. It introduces automatic memoization, eliminates the need for 'useCallback' and 'memo', and replaces 'React.lazy' with react server components. The 'useContext' hook will also undergo changes, and server actions will be more stable.
- 13
Theo - t3․gg·2yVapor: The Future Of Vue
View's Vapor mode is an alternative compilation strategy inspired by Solid that aims to improve performance by eliminating the use of virtual DOM. It allows for granular opt-in at the component level and reduces the runtime size. Solid, another JavaScript framework, also focuses on performance and uses a similar model based on signals for reactive updates.
- 14Collections·2y
Tailwind CSS v4 Alpha: Open-Sourcing Big Changes for Speed and Simplicity
Tailwind CSS V4 is now open-sourced and brings a faster engine, composable variants, modern CSS features, and simplified installation and customization. Future updates will include support for JavaScript configuration files, additional dark modes, plugins and custom utilities, and prefix support.
- 15
- 16Theo - t3․gg·2y
I Suck At SQL, Now My DB Tells Me How To Fix It
Planet Scale introduces schema recommendations, a new feature that helps improve database performance by providing tailored recommendations based on production database traffic. The recommendations include adding indexes for inefficient queries, removing redundant indexes, preventing primary key ID exhaustion, and dropping unused tables.
- 17
Vue.js — What are async components and how to use them?
Async components in Vue.js can be loaded asynchronously, improving page loading time and user experience. They are useful for large or complex components, components rendered based on user interactions, and components used for less frequent features.
- 18Theo - t3․gg·2y
The New React Native Architecture
The new React Native architecture brings significant improvements, such as faster performance, better scalability, and easier integration of native code. It enables synchronous layout effects, concurrent rendering, and fast JavaScript and Native interfacing. Libraries can benefit from enabling the new architecture as well. However, it is still considered experimental and not recommended for most production apps at the moment.
- 19
- 20
- 21
Rendering a Million Rows in React by Drawing
Learn how to render a million rows in React by using the approach of drawing instead of rendering a table. The post explains the techniques and challenges involved in handling large amounts of data and provides insights into the DOM structure and initialization process. It also discusses different approaches to drawing the data on the canvas for smooth scrolling.
- 22
- 23
Laravel News·2y
How to Detect n+1 Queries in PHP
The n+1 query problem is a performance issue in software development where unnecessary database calls are made. To detect n+1 queries, developers can use Application Performance Monitoring (APM) tools. Resolving n+1 queries can be done through techniques like eager loading, join queries, or caching.
- 24
Enhancing API Observability Series (Part 3): Tracing
Enhancing API observability through distributed tracing technology by selecting appropriate tools, integrating them into API development, configuring and optimizing the tracing systems, analyzing and visualizing the tracing data, and resolving performance bottlenecks.
- 25
