Severe server performance degradation
-
After enabling the option to allow multiple images per variation for variable products (https://prnt.sc/nfVqaxO79OFs), we are experiencing severe server performance degradation. Specifically:
- Extremely slow queries are being executed (taking more than 7 seconds).
- CPU usage spikes to 90–100%, especially during product load operations.
- This is particularly problematic when products are rendered, severely affecting user experience and site stability.
- The main performance bottleneck appears to be the get_available_variations() function.
- The problem is strongly linked to the file variation-gallery-new.php, which is part of the Woodmart theme integration.
- Performance normalizes when the multiple images per variation feature is disabled.
Hello,
Thank you for reaching out to us regarding the performance issues you are encountering with the server after enabling the multiple images per variation option in the WoodMart theme.
To address the performance degradation and pinpoint the source of the issue, please follow these steps:
1. Temporarily disable all non-essential plugins to see if there’s a plugin conflict contributing to the server load. Check your site’s performance after each plugin is deactivated to identify the possible culprit.
2. For us to further investigate the problem and provide a precise solution, please provide us with temporary admin access to your site. You can use the Private Content field to share these credentials securely.
Looking forward to your response.
Regards
All plugins (except WooCommerce and the theme itself) were already disabled during our tests.
The issue persists even with no third-party plugins active.
For now, we prefer not to grant access and would first appreciate configuration guidance based on the log details already provided.
- Are there any known configuration adjustments we should try (e.g., disabling certain theme modules, changing gallery loading behavior)?
- Is there a way to limit get_available_variations() ?
- Are there theme hooks or filters to defer or conditionally disable variation gallery processing?
This problem needs additional troubleshooting. That is why we need your admin access and, most likely, will need FTP as well. There are no configuration fixes for this at the moment.
.
