django-perf-review

What problem does it solve?

This Skill identifies and helps resolve critical performance bottlenecks within Django applications, preventing slow load times, database strain, and potential outages.

Core Features & Use Cases

• N+1 Query Detection: Finds inefficient database query patterns that lead to excessive database calls.
• Unbounded Queryset Analysis: Identifies potential memory exhaustion issues from loading large datasets.
• Index Optimization: Recommends and validates the addition of database indexes for faster data retrieval.
• Write Operation Efficiency: Detects and suggests improvements for bulk create, update, and delete operations.
• Use Case: Review a Django codebase to find and fix N+1 queries in user profile views, ensuring faster page loads for logged-in users.

Quick Start

Use the django-perf-review skill to audit the performance of the User.objects.all() queryset in views.py.