M2.3.7, v1.1.7: The server load goes up (100%) when enabling the module

ISSUE:

After enabling the Matrix View module, the Server Resource all goes to 100%. After disabling it slowly goes down (<5% as normal)

SOLUTION:

As the module has not been optimized for websites with a great number of child products, Mysql will be failed when there are too many requests at the same time occurring on your site.

To temporarily improve your server, please edit the file app/code/Bss/ConfigurableMatrixView/Model/ResourceModel/Product/Type/Configurable.php as below:

Or download the file attached below to override the current file on your site. 

Kindly note that our solution only works in case the Multi-Source Inventory (MSI) of Magento default is disabled.

If you need any further assistance, please feel free to contact us. We'd be happy to support you!

Get to know us

BSS Commerce is a full-service ecommerce agency with 14+ years of experience, supporting 75,000+ customers worldwide. As an Adobe Commerce Solution Bronze Partner and Select Magento Extensions Builder, we deliver trusted end-to-end solutions.

Our core strength is Magento, with 150+ extensions designed to enhance store performance and drive growth. With deep expertise from years of working on Magento websites, we deliver scalable, high-impact solutions backed by strong client trust.

Discover our extensions: https://bsscommerce.com/magento-2-extensions.html 

Here are our most powerful plugins:

• BSS Commerce’s Magento 2 B2B Extension enhances B2B performance with streamlined workflows and tailored pricing strategies.
• BSS Commerce’s Magento 2 SEO Extension improves rankings and maximizes organic growth through advanced SEO automation.