Woocommerce slows Plugins activate and deactivate
-
The Woocommerce plugin is slowing down the activation and deactivation of our plugins. Our hosting provider Robert Matthews, Tiger Technologies researched the issue when we reported that our site seemed very slow. Here are Robert’s findings:
If it helps you troubleshoot this with them, we were curious about this,
so we did some more troubleshooting. We found that this is caused by
code in this file (or related files): /wp-content/plugins/woocommerce/src/Admin/RemoteInboxNotifications/RemoteInboxNotificationsEngine.php Whenever any plugin is activated or deactivated, that code spends tens
of seconds completely rewriting the "wp_wc_admin_notes" and
"wp_wc_admin_note_actions" database tables, running queries like the
ones in the attached log. We've never seen Woocommerce do this before, but if you show them this
and they can see exactly what it's doing behind the scenes, they should
be able to figure it out. Good luck, and thank you again! --
Robert Mathews, Tiger Technologies
SELECT note_id FROM wp_wc_admin_notes WHERE name = 'wayflyer_bnpl_q4_2021' ORDER BY note_id ASC
SELECT * FROM wp_wc_admin_notes WHERE note_id = 1 LIMIT 1
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 1
SHOW FULL COLUMNS FROMwp_wc_admin_notes
UPDATEwp_wc_admin_notesSETname= 'wayflyer_bnpl_q4_2021',type= 'marketing',locale= 'en_US',title= 'Grow your business with funding through Wayflyer',content= 'Fast, flexible financing to boost cash flow and help your business grow \342\200\223 one fee, no interest rates, penalties, equity, or personal guarantees. Based on your store\342\200\231s performance, Wayflyer provides funding and analytical insights to invest in your business.',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2024-03-17 20:01:32',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '1'
DELETE FROM wp_wc_admin_note_actions WHERE note_id = 1
SHOW FULL COLUMNS FROMwp_wc_admin_note_actions
REPLACE INTOwp_wc_admin_note_actions(note_id,name,label,query,status,actioned_text,nonce_action,nonce_name) VALUES (1, 'wayflyer_bnpl_q4_2021', 'Level up with funding', 'https://woo.com/products/wayflyer/?utm_source=inbox_note&utm_medium=product&utm_campaign=wayflyer_bnpl_q4_2021', 'actioned', '', NULL, NULL)
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 1 SELECT note_id FROM wp_wc_admin_notes WHERE name = 'wc_shipping_mobile_app_usps_q4_2021' ORDER BY note_id ASC
SELECT * FROM wp_wc_admin_notes WHERE note_id = 2 LIMIT 1
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 2
UPDATEwp_wc_admin_notesSETname= 'wc_shipping_mobile_app_usps_q4_2021',type= 'marketing',locale= 'en_US',title= 'Print and manage your shipping labels with WooCommerce Shipping and the WooCommerce Mobile App',content= 'Save time by printing, purchasing, refunding, and tracking shipping labels generated by <a href=\\\"https://woo.com/woocommerce-shipping/\\\">WooCommerce Shipping</a> \342\200\223 all directly from your mobile device!',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2024-03-17 20:01:33',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '2'
DELETE FROM wp_wc_admin_note_actions WHERE note_id = 2
REPLACE INTOwp_wc_admin_note_actions(note_id,name,label,query,status,actioned_text,nonce_action,nonce_name) VALUES (2, 'wc_shipping_mobile_app_usps_q4_2021', 'Get WooCommerce Shipping', 'https://woo.com/woocommerce-shipping/?utm_source=inbox_note&utm_medium=product&utm_campaign=wc_shipping_mobile_app_usps_q4_2021', 'actioned', '', NULL, NULL)
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 2 SELECT note_id FROM wp_wc_admin_notes WHERE name = 'woocommerce-services' ORDER BY note_id ASC
SELECT * FROM wp_wc_admin_notes WHERE note_id = 3 LIMIT 1
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 3
UPDATEwp_wc_admin_notesSETname= 'woocommerce-services',type= 'info',locale= 'en_US',title= 'WooCommerce Shipping & Tax',content= 'WooCommerce Shipping & Tax helps get your store \\\"ready to sell\\\" as quickly as possible. You create your products. We take care of tax calculation, payment processing, and shipping label printing! Learn more about the extension that you just installed.',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2024-03-17 20:01:33',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '3'
DELETE FROM wp_wc_admin_note_actions WHERE note_id = 3
REPLACE INTOwp_wc_admin_note_actions(note_id,name,label,query,status,actioned_text,nonce_action,nonce_name) VALUES (3, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox', 'unactioned', '', NULL, NULL)
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 3 SELECT note_id FROM wp_wc_admin_notes WHERE name = 'your-first-product' ORDER BY note_id ASC
SELECT * FROM wp_wc_admin_notes WHERE note_id = 4 LIMIT 1
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 4
UPDATEwp_wc_admin_notesSETname= 'your-first-product',type= 'info',locale= 'en_US',title= 'Your first product',content= 'That\342\200\231s huge! You\342\200\231re well on your way to building a successful online store \342\200\224 now it\342\200\231s time to think about how you\342\200\231ll fulfill your orders.<br /><br />Read our shipping guide to learn best practices and options for putting together your shipping strategy. And for WooCommerce stores in the United States, you can print discounted shipping labels via USPS with <a href=\\\"https://href.li/?https://woo.com/shipping\\\" target=\\\"_blank\\\">WooCommerce Shipping</a>.',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2024-03-17 20:01:34',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '4'
DELETE FROM wp_wc_admin_note_actions WHERE note_id = 4
REPLACE INTOwp_wc_admin_note_actions(note_id,name,label,query,status,actioned_text,nonce_action,nonce_name) VALUES (4, 'learn-more', 'Learn more', 'https://woo.com/posts/ecommerce-shipping-solutions-guide/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more', 'actioned', '', NULL, NULL)
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 4 SELECT note_id FROM wp_wc_admin_notes WHERE name = 'wc-admin-optimizing-the-checkout-flow' ORDER BY note_id ASC
SELECT * FROM wp_wc_admin_notes WHERE note_id = 5 LIMIT 1
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 5
UPDATEwp_wc_admin_notesSETname= 'wc-admin-optimizing-the-checkout-flow',type= 'info',locale= 'en_US',title= 'Optimizing the checkout flow',content= 'It\342\200\231s crucial to get your store\342\200\231s checkout as smooth as possible to avoid losing sales. Let\342\200\231s take a look at how you can optimize the checkout experience for your shoppers.',content_data= '{}',status= 'pending',source= 'woocommerce.com',date_created= '2024-03-17 20:01:36',date_reminder= NULL,is_snoozable= '0',layout= 'plain',image= '',is_deleted= '',is_read= '' WHEREnote_id= '5'
DELETE FROM wp_wc_admin_note_actions WHERE note_id = 5
REPLACE INTOwp_wc_admin_note_actions(note_id,name,label,query,status,actioned_text,nonce_action,nonce_name) VALUES (5, 'optimizing-the-checkout-flow', 'Learn more', 'https://woo.com/posts/optimizing-woocommerce-checkout?utm_source=inbox_note&utm_medium=product&utm_campaign=optimizing-the-checkout-flow', 'actioned', '', NULL, NULL)
SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name\n\t\t\t\tFROM wp_wc_admin_note_actions\n\t\t\t\tWHERE note_id = 5The page I need help with: [log in to see the link]
Viewing 12 replies - 1 through 12 (of 12 total)
-
Thank you for your reply Afzal @afzalpansuvi .
I’m confused. Will the Woocommerce developers now fix this bug?
Best regards,
Marcus
<<<< Just to confirm. If you deactivate WooCommerce, are you able to activate other plugins normally?>>>>
Yes, I can activate other plugins once I deactivate Woocommerce and these plugins activate and deactivate quickly.
The issue is when the Woocommerce plugin is activated, the subsequent activation and deactivation of all other plugins is slowwwww.
When I reported this to my hosting provider, Tiger Technologies found that this is caused by
code in this file (or related files):
/wp-content/plugins/woocommerce/src/Admin/RemoteInboxNotifications/RemoteInboxNotificationsEngine.php
The reason for this is whenever any plugin is activated or deactivated, that code spends tens of seconds completely rewriting the “wp_wc_admin_notes” and
“wp_wc_admin_note_actions” database tables.
I hope this clarifies the issue.
Thank you very much.
Viewing 12 replies - 1 through 12 (of 12 total)
The topic ‘Woocommerce slows Plugins activate and deactivate’ is closed to new replies.
