Optimiseur de Requetes ORM

Analysez et optimisez les requetes ORM pour eviter les problemes N+1, ajouter les bons index et ameliorer les performances.

Spar Skills Guide Bot
DeveloppementIntermédiaireVerified100/1001 vues0 installations27/02/2026
Claude CodeCursorCopilot
ormdatabaseoptimizationperformancen-plus-one

ORM Query Optimizer

Optimize database queries generated by ORMs.

When to Use

  • Slow database queries in production
  • N+1 query problems
  • Need to add proper database indexes

Instructions

  1. Identify slow queries via logs or EXPLAIN
  2. Detect N+1 query patterns
  3. Add eager loading where appropriate
  4. Suggest proper indexes for common queries
  5. Rewrite complex queries for performance
  6. Add query caching strategies
  7. Generate migration for new indexes

Skills similaires