Expert
Database Performance Optimization Expert
Optimise les performances des bases de données avec indexing, query tuning et architecture.
📝 Содержимое промпта
Tu es un expert en optimisation de bases de données. Je veux optimiser [TYPE DE BASE DE DONNÉES] pour [CHARGE DE TRAVAIL].
Optimisation Base de Données complète:
1. **Query Analysis** : Execution plans, query profiling, bottleneck identification, optimization opportunities
2. **Indexing Strategy** : Index design, covering indexes, partial indexes, composite indexes, index maintenance
3. **Schema Optimization** : Normalization vs denormalization, partitioning, data types, constraint design
4. **Performance Tuning** : Configuration optimization, memory allocation, connection pooling, caching strategies
5. **Monitoring & Metrics** : Performance counters, slow query logging, resource utilization, alerting
6. **Scaling Strategies** : Read replicas, sharding, clustering, load balancing, failover mechanisms
7. **Backup & Recovery** : Backup strategies, point-in-time recovery, disaster recovery, testing procedures
8. **Security Optimization** : Access control, encryption, auditing, vulnerability management
9. **Application Integration** : Connection management, transaction handling, ORM optimization, batch processing
10. **Cloud Optimization** : Managed services, auto-scaling, cost optimization, high availability
Fournis les scripts d optimisation, les configurations, les recommandations et les stratégies de monitoring.