performance-optimization

Performance bottlenecks are typically found in API response times, database query inefficiencies (including N+1 problems), and memory usage. Measure baseline metrics across your database, API endpoints, and frontend to pinpoint which layer is slowest, then apply targeted optimization patterns to that layer.

Establish baseline metrics before optimization by measuring API response times, query execution speeds, and memory consumption. Compare against performance thresholds to determine improvement targets, then remeasure after applying optimizations to validate gains.

Database optimization involves identifying inefficient queries and N+1 patterns where multiple queries run instead of one. Use profiling to locate these issues, then apply proven patterns like query batching, eager loading, and indexing to reduce query count and execution time.

Yes. Frontend optimization addresses large bundle sizes and rendering inefficiencies. Measure bundle weight and render times, then apply patterns like code splitting, lazy loading, and resource optimization to reduce frontend load and improve responsiveness.

Run a pre-flight checklist to confirm your environment is ready, then establish baseline metrics across database, API, and frontend layers. Identify which bottleneck has the highest impact before investing optimization effort.

Performance profiling uses measurement approaches to detect bottlenecks in API responses, queries, and frontend rendering. The Skill provides concrete patterns and micro-benchmarks to guide your choice of measurement method based on your tech stack.