magento2-db-performance
Installation
SKILL.md
Magento 2 DB Performance Patterns
Query Reduction Summary
| Operation | Before | After |
|---|---|---|
| DELETE in loop | N queries | 1 query |
| UPDATE same value in loop | N queries | 1 per group |
| CSV multiselect UPDATE | N SELECTs + N UPDATEs | 1 UPDATE per duplicate ID |
Pattern 1 — Bulk DELETE (IN clause)
Anti-pattern: $connection->delete() called inside a foreach loop.