performance-hunter

Performance bottlenecks are slow components limiting system speed. Measure response times and resource usage across frontend, backend, database, and API layers using profiling tools, then identify which component consumes the most resources or time. This workflow guides you to prioritize fixes that yield the largest gains.

Database optimization targets slow queries through indexing, query rewrites, and caching. Profile query execution times, add indexes on frequently filtered columns, refactor inefficient joins, and cache repeated results. These techniques reduce latency and resource usage across backend systems.

Large bundles slow page load times. Measure current bundle size, identify unused code and dependencies, split code into smaller chunks, and apply minification. Frontend bundle reduction improves load performance across all browsers and network conditions.

Memory leaks and high CPU usage indicate inefficient resource allocation. Profile memory and CPU consumption to locate leak sources, then remediate through proper cleanup, garbage collection tuning, or algorithmic changes. Language-agnostic profiling workflows apply across any framework.

Common bottlenecks include unindexed database queries, missing caching layers, inefficient algorithms, and large bundle sizes. This workflow identifies quick wins—high-impact fixes requiring minimal effort—to accelerate performance gains before deeper optimization.

Performance diagnosis and optimization principles are language-agnostic. The measurement, profiling, and optimization templates apply to frontend frameworks, backend services, databases, and APIs regardless of the language or technology stack you use.