WPIntell

Source evidence

30k queries when creating new product

Brands for WooCommerce · support · 2025-01-19T12:45:00+00:00

complaintsentiment
mediumseverity
0.92relevance
2replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

4 / 27 rows with source links

14.8% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

23 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
Concensur unresolved
Hi, Brands for WooCommerce is causing quite some issues lately. I’m not able to save my nav menu in the menu editor. Disabling the plugin makes it possible again. The page is loading forever and then just dies. It’s not a memory issue. Also, when accessing the create new product page, the plugin is doing some 30k queries to the db which makes the page take 50 seconds to load. Check screenshot below: We are using version 3.8.6 Is this something we can expect to be fixed or should we stop using the plugin? delete_option() wp-includes/option.php:1207 delete_transient() wp-includes/option.php:1389 BeRocket_product_brand->clear_cache() wp-content/plugins/brands-for-woocommerce/main.php:1462 BeRocket_product_brand->clear_cache_on_edit_post() wp-content/plugins/brands-for-woocommerce/main.php:790 do_action('save_post') wp-includes/plugin.php:517 wp_insert_post() wp-includes/post.php:5060 get_default_post_to_edit() wp-admin/includes/post.php:759 This topic was modified 1 year, 4 months ago by Concensur . This topic was modified 1 year, 4 months ago by Concensur . Diving a little deeper, I see that the value berocket_product_brand_widget--1 is saved in the _transient_br_brands_cache_list 30k times, which is then causing clear_cache() in main.php:1456 to call delete_transient() over and over. I’m not sure how the transient list was able to grow that large. I’ll leave that to the plugin developers. For now I just deleted the _transient_br_brands_cache_list option from the db. Hello, What theme are you using and what version is it? Also, please extract the data from the db _transient_br_brands_cache_list and provide it here. There should not be so many entries. Regards, Dmytro

Comments

2 shown
Concensur 2025-01-19T14:13:00+00:00

Diving a little deeper, I see that the value berocket_product_brand_widget--1 is saved in the _transient_br_brands_cache_list 30k times, which is then causing clear_cache() in main.php:1456 to call delete_transient() over and over. I’m not sure how the transient list was able to grow that large. I’ll leave that to the plugin developers. For now I just deleted the _transient_br_brands_cache_list option from the db.

Dmytro Holovnia 2025-01-31T23:31:00+00:00

Hello, What theme are you using and what version is it? Also, please extract the data from the db _transient_br_brands_cache_list and provide it here. There should not be so many entries. Regards, Dmytro