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.
Related skills
More from tuanhaviet22/magento-skills
magento2-backend-toolkit
>
19magento2-custom-logger
>
4magento2-db-sql-csv
Magento 2 best practices for database queries and CSV exports. Use when writing SQL queries, fetching data from DB, or exporting data to CSV files. Triggers on tasks involving raw SQL, SELECT queries, JOIN operations, CSV generation, or file export adapters. DO NOT use for frontend, caching, or search topics.
4magento2-warden
>
3