Performance: Excessive SQL usage in Sales and Products Grid
lbajsarowicz opened this issue · 0 comments
lbajsarowicz commented
Issue Description
Preconditions
- Magento 2.4.5-p1
- Mailchimp 103.4.53
Steps to reproduce
As an Administrator, visit Products Grid.
Actual and Expected result
Mailchimp extension performs over 1000 unnecessary MySQL requests to load Product Listing.
Diff when Mailchimp is disabled (for a grid of 100 products):
Additional information
Poor extension architecture and the fact it's an official extension affects thousands of stores around the globe, wasting huge amount of resources. Minor optimizations would not only help merchants better utilize their employees time (lower load times), but also waste lest natural resources.