performance

Fix N+1 query problems by applying ORM-level eager loading and query batching techniques. This Skill guides you through detecting redundant database queries and implementing batching patterns to eliminate the latency overhead caused by iterative data fetching.

Profile CPU, memory, and I/O bottlenecks by running targeted diagnostic passes on your services. This Skill provides concrete tooling guidance and steps to identify execution hotspots and resource exhaustion points that degrade endpoint performance.

Establish latency budgets by defining per-endpoint performance targets and allocating time limits across service operations. This Skill helps you set concrete performance thresholds to ensure your APIs meet strict response time requirements before implementing optimizations.

Choose between in-process, Redis, or HTTP caching by evaluating your scalability needs and data consistency requirements. This Skill assists in matching the appropriate caching strategy to your specific service architecture to maximize latency reduction.

Use async patterns to optimize slow I/O operations by parallelizing non-blocking tasks within your service execution flow. This Skill provides best practices for implementing asynchronous workflows to prevent I/O bottlenecks from stalling endpoint response times.