React Cheatsheet 06 — Memoization (memo, useMemo, useCallback)
Cheatsheet: when to memoize, React Compiler, perf measurement.
Performance
MongoDB Cheatsheet 07 — Performance Tuning
Cheatsheet: indexes, explain, profiling, slow ops.
React Cheatsheet 07 — Performance Profiling
Cheatsheet: React DevTools profiler, common bottlenecks, code splitting, Suspense.
SQLAlchemy Cheatsheet 08 — Performance, N+1, Bulk Ops, Streaming
Cheatsheet: detect N+1, bulk insert/update, yield_per, load_only, defer, EXPLAIN, slow query logging.
Python Cheatsheet 09 — Profiling (py-spy, cProfile, scalene)
Cheatsheet: when to use each profiler, common commands, reading output.
Postgres SQLAlchemy Textbook Ch. 9 — Upsert, Bulk Insert, and COPY
Postgres-specific bulk operations: ON CONFLICT, RETURNING, bulk insert via execute, asyncpg COPY for huge data.
SQLAlchemy 2.0 Textbook Ch. 9 — Performance: N+1, Bulk Ops, Streaming
Practical SQLAlchemy performance: avoiding N+1, bulk_insert_mappings, server-side cursors, EXPLAIN ANALYZE patterns.
Pydantic v2 Textbook Ch. 10 — Performance, FastAPI Integration, and Alternatives
Pydantic v2 perf tips, hot path optimization, FastAPI patterns, and when to consider msgspec / attrs.
Nginx Cheatsheet 11 — Performance Tuning
Cheatsheet: worker tuning, sysctl, connection limits, profiling.
Linux Cheatsheet 17 — Performance Tuning
Cheatsheet: perf tools, sysctl, eBPF, network tuning.