🏠 首页
基准测试
📊 所有基准测试 🦖 恐龙 v1 🦖 恐龙 v2 ✅ 待办事项应用 🎨 创意自由页面 🎯 FSACB - 终极展示 🌍 翻译基准测试
模型
🏆 前 10 名模型 🆓 免费模型 📋 所有模型 ⚙️ 🛠️ 千行代码模式
资源
💬 💬 提示库 📖 📖 AI 词汇表 🔗 🔗 有用链接
Expert

Database Performance Optimization Expert

#database-optimization #sql-tuning #indexing #performance #postgresql

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.