Tagged Performance
23 articles tagged Performance.
Backend & Databases8 min readParquet Row Groups Decide Whether Your Filters Skip Anything
Parquet row groups only skip data when the layout cooperates. Why unsorted writes make min/max statistics useless, and how to fix it.
The TweakPad Team
Web Development4 min readView Transitions Went Cross-Browser. Here Is What That Costs You
Firefox 144 completed the set at 90% support. How the snapshot model works, why one CSS rule animates a whole page, and the traps.
The TweakPad Team
Web Development4 min readJPEG XL Sits at 15%. AVIF Is at 95%. That Is the Whole Decision
Deployment settles the format argument, not compression. The real support numbers, and the four lines that serve all of them.
The TweakPad Team
- Web Development5 min read
INP: What the 200ms Threshold Measures and How to Miss It
INP measures the worst interaction on a page, not the average. Why 200ms is the bar, and the three phases that consume it.
The TweakPad Team
- JavaScript4 min read
Microtask vs Macrotask: The Two Queues That Decide JavaScript Order
Why a promise resolves before setTimeout(0), how the microtask queue drains between tasks, and the loop that freezes a page.
The TweakPad Team
- Backend & Databases5 min read
MongoDB Index Types: Which One Your Query Actually Needs
Single field, compound, multikey, text, wildcard, hashed, geospatial and TTL — what each is for, and the limits.
The TweakPad Team
- Web Development4 min read
Measuring Core Web Vitals in the Field with the web-vitals Library
Lighthouse cannot measure INP. How to collect LCP, INP and CLS from real users, and why attribution is what matters.
The TweakPad Team
- Backend & Databases9 min read
Why DAX Says Circular Dependency When Nothing Is Circular
CALCULATE inside a calculated column makes it depend on every column in the table. That is why two harmless columns collide.
The TweakPad Team
- Web Development6 min read
Does Minifying Still Matter With Brotli? 6% for CSS, 36% for JS
Minifying CSS saves 6% after Brotli. Minifying JS saves 36%. The difference is one step compression cannot do: mangling.
The TweakPad Team
- Backend & Databases4 min read
How to Create an Index in MongoDB (Without Locking Your Collection)
createIndex syntax, unique and partial and TTL options, building on a live replica set, and how to confirm the index is actually being used.
The TweakPad Team
- Backend & Databases4 min read
The ESR Rule: Getting Compound Index Field Order Right in MongoDB
Equality, Sort, Range — why index field order decides whether MongoDB sorts in memory, and how to prove it with explain.
The TweakPad Team
- Backend & Databases5 min read
UUIDv4 vs UUIDv7 as a Primary Key: What Actually Changes
Random UUID keys fragment your index. UUIDv7 fixes the ordering and keeps client-side generation. When the switch is worth making.
The TweakPad Team
- Backend & Databases5 min read
The Regex That Works Fine Until One Input Hangs Your Server
Catastrophic backtracking turns a working pattern into a CPU bomb. Why nested quantifiers explode, and how to spot and rewrite them.
The TweakPad Team
- Web Development4 min read
Core Web Vitals: What to Measure and What to Actually Fix
LCP, INP and CLS with their thresholds, the specific cause of each, and how lab data differs from the field data Google ranks on.
The TweakPad Team
- Backend & Databases2 min read
Node.js Streams: Processing Data You Cannot Fit in Memory
Why streams exist, the four types, and how pipeline() fixes the error handling and back-pressure bugs that pipe() leaves you with.
The TweakPad Team
- Backend & Databases2 min read
MongoDB Indexes: What to Create and How to Verify It Worked
Compound index ordering, the ESR rule, covered queries, and how to read explain() output to confirm an index is actually being used.
The TweakPad Team
- Backend & Databases2 min read
SQL Query Optimization: Read the Plan Before You Guess
How to diagnose a slow query with EXPLAIN ANALYZE, the index rules that matter, and the eight query patterns that defeat indexes.
The TweakPad Team
- Next.js2 min read
Next.js Image Optimization: Getting CLS and LCP Right
How next/image prevents layout shift, what sizes and priority really do, and the config mistakes that make images slower.
The TweakPad Team
- Next.js2 min read
Next.js Caching Explained: The Four Layers and How to Control Them
The Request Memoization, Data Cache, Full Route Cache and Router Cache — what each one caches, how long for, and how to opt out correctly.
The TweakPad Team
- React2 min read
React Performance: Fix the Things That Actually Matter
A diagnosis-first guide — how to find the real bottleneck with the Profiler, and the five fixes behind most real wins.
The TweakPad Team
- React2 min read
useMemo and useCallback: When They Help and When They Cost You
Memoisation has a real price. How to tell which of the three legitimate cases you are in, and why most useMemo is waste.
The TweakPad Team
- JavaScript2 min read
The JavaScript Event Loop: Microtasks, Macrotasks and Why Order Matters
How the event loop schedules work, why promises run before setTimeout, and how to stop long tasks freezing your page.
The TweakPad Team
- JavaScript2 min read
Async/Await in JavaScript: What It Actually Does
How async/await really works, the sequential-await mistake that costs 10x, and how to handle errors and parallel work.
The TweakPad Team