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.
I have disabled plugins and still running into issues.
I need to increase the performance and variation images is important to have.
Need your help!
Attachments:
You must be
logged in to view attached files.
Hello,
We need to be able to monitor your performance in real time. Also, explain how we can see his usage information in your hosting provider panel. Provide us with all the related access so we can troubleshoot this.
Kind Regards
Hi, we have connected our server to newrelic. I went ahead and pasted the information below. We’ve been tracking server performance for the last 96 hours and you can monitor performance in real time with the lead issue being get_available_variations() function.
I have pasted a URL to the exact issue. Please view below
Hello,
Please disable all plugins that are not related to our theme temporarily so we can check this.
Kind Regards
Hi,
I have disabled all the plugins not related to your theme.
Can you please inspect?
Hello,
We still see plugins active. Please disable all plugins that are not related to our theme.
Kind Regards
Hi,
Can you please visit my website and see what is going on? I have disabled all plugins beside Query Monitor which i’m using to check server load time and it’s currently at 22 seconds. Your help is greatly appreciated. I have been having this performance issue for over a month now.
https://wordpress-1466796-5549930.cloudwaysapps.com/shop/
Hello,
Please disable all plugins that are not related to our theme and test with the default theme to see if it is somehow related to WoodMart or not.
Kind Regards
I have provided the admin credentials. Can you simply disable the plugins? You can disable anything and everything that is required. I’ve disabled them but while waiting for a reply, I am trying to diagnose what is going on. I give full authority to disable the plugins when you login so you can see the performance issues I am having
Hello,
As we can see, your website is much faster when plugins are disabled. But it is still not as fast as it is supposed to be. We tested with the default theme, and it is also slow (while a bit faster than with WoodMart because of a smaller number of elements displayed when you switch to that theme). I suppose that you have a problem either with the server itself or with your database. We tried to disable the “Additional variations images” as you wrote initially, but it doesn’t make any difference.
Kind Regards
Hi,
It’s not the server as we ran tests and the server response is .01 seconds. Additionally, we’re running on 16GB of ram, 95GB of disk space, 8 core processor, and 6TB bandwidth.
We also are running on query monitor and there isn’t any indication that the database queries are slow.
Could you enable the additional variation images so I can continue to debug this?
Hello,
Server response time is much higher on your website, both with our theme and with other themes.
Yes, you can enable this option and continue investigating the issue.
Kind Regards
.
