performance-analyst

N+1 query detection identifies inefficient database access patterns in web applications and provides actionable remediation guidance. It pinpoints repeated single-record fetches within loops and recommends eager loading or batch fetching to eliminate redundant database round-trips.

Slow query optimization analyzes suboptimal index usage and recommends targeted SQL tuning strategies. It evaluates query execution plans, identifies missing or ineffective indexes, and provides concrete guidance to restructure queries for faster database retrieval.

Caching strategy design identifies data access bottlenecks and formulates optimal cache layering for high-traffic workloads. It recommends appropriate cache invalidation policies and storage mechanisms to reduce database load and improve application scalability.

Capacity planning for diverse workloads analyzes server-side resource utilization and scalability requirements. It provides concrete, actionable guidance for tuning server configurations and planning infrastructure capacity to handle varying traffic loads efficiently.

No, this performance analysis explicitly requires no security audits. It focuses exclusively on resolving performance bottlenecks like slow queries, caching gaps, and scalability issues rather than identifying database security vulnerabilities.