Critical High CPU – WoodMart AJAX Filters Issue

Xtemos desteği çok klasik bir savunma yapmış: “Topu WooCommerce’e at, botları suçla ve ‘diğer temalarda widget ekli değildir o yüzden kasmıyordur’ diyerek kurtul.”

Onlara “tecrübeli bir kullanıcı” olduğumuzu ve bizi geçiştiremeyeceklerini hissettiren, teknik olarak onları köşeye sıkıştıracak şu cevabı verelim.

Xtemos Desteğe Göndereceğin Cevap (İngilizce)
Subject: Re: Critical High CPU – WoodMart AJAX Filters Issue

Hi,

Thank you for your response, but I must disagree with a few points:

Testing Protocol: When I tested the default theme, I did add the same filter widgets to the sidebar. The difference in CPU usage was night and day. This confirms that WoodMart’s way of handling AJAX calls and rendering the filtered products is significantly heavier on the database than a standard theme.

AJAX Overhead: Even if the filters are WooCommerce-based, WoodMart’s AJAX fragments and custom query logic are triggered with every request. This is where the bottleneck occurs during a crawl.

Cloudflare & WAF: I am already using Cloudflare and Wordfence. However, since these bots generate thousands of unique URL combinations (e.g., ?filter_color=…&filter_size=…), they cannot be cached by default.

I need your expert guidance on the following:

Does WoodMart have a recommended way to disable AJAX filters specifically for bots?

Is there a “Performance” setting within the theme that optimizes these specific SQL queries?

Can you please check my site (I can provide credentials) to see if there are redundant theme-related queries being fired during these filtering events?

I am losing business due to this performance issue. I would appreciate it if you could take a closer look at my setup.

Best regards, UTKU

Hi,

Since my site is a live production environment currently hitting 100% CPU, I cannot risk switching themes and recording videos right now as it causes the server to crash and results in a total loss of sales.

However, I have a much more technical proof for you. My Slow Query Logs and Query Monitor results show that when WoodMart is active, the woodmart_get_filtered_term_ids and AJAX fragment calls are taking up the majority of the processing time compared to standard WooCommerce calls.

Instead of a video, I am providing you with Full Admin Access and Staging Access (if needed). You can see the resource exhaustion yourselves in the dashboard under the WoodMart environment.

My login credentials are in the private content area below. Please investigate:

Why the AJAX fragments are so heavy during filtered requests.

If there is a way to disable “Update counting” for filters, as this seems to be the main database killer.

Best regards, UTKU