Website getting slow

Hello @sanchitvarshney,

Thank you for reaching out to WooCommerce support forum.

UPDATE 'wp_options' SET option_value = 1701286503' WHERE "option_name" = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl'

I understand the transient in WooCommerce is being set multiple times, which is causing the website to slow down.

The query you’ve mentioned is updating the option value of the ‘_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl‘ in the ‘wp_options‘ table. This is likely related to the WooCommerce Blocks plugin, which provides block-based frontend content for your store.

One solution to prevent this from happening is to use a plugin that manages transients, such as Transients Manager. This plugin allows you to view, search, edit, and delete transients at will. It also provides a way to delete all expired transients.

Alternatively, you can add a filter in your functions.php file to change the expiration time of the transient. For example, you can set the transient to expire after one hour instead of constantly updating with every request. If you require more help with the actual coding, we’d recommend hiring a developer or one of the customization experts.

Should you need further assistance, don’t hesitate to get back to us.

Cheers.

I am using a custom theme which does not use woocommerce blocks, So why is it getting triggered? Also the expiration is 30 days, but still, it is triggering every time a user is on the website. Why does this even trigger for the front end of the website as this is related to API so needs to trigger for API requests only?

Hello @sanchitvarshney,

Just to confirm, do you see this on a certain page/directory?

Could you also attach a copy of your site’s System Status report? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support” (after you scroll down a bit)”. Once done, please paste it here in your reply or via a text-sharing service like https://gist.github.com/.

Look forward to hearing back from you.

Here it is https://gist.github.com/sanchit-hwd/38cfa1ba3fad8c8e5ac7d80d97b28b8e

Here it is https://gist.github.com/sanchit-hwd/38cfa1ba3fad8c8e5ac7d80d97b28b8e

Thank you!

I can’t see the mentioned database query with Query Monitor. Could you please confirm if it’s called on a certain page or when performing a certain action?


Additionally, have you tried disabling all other plugins other than WooCommerce and switching to the default Storefront theme?

• More on how to perform a conflict test can be found here.

Look forward to hearing back from you.