Plugin slowing down backend product list page

  • Resolved javierdemuga

    (@javierdemuga)


    4 years, 6 months ago

    I am seeing many slow queries created by Back In Stock Notifier at the woocommerce product list backend page.

    `SELECT wp_posts.*
    FROM wp_posts
    INNER JOIN wp_postmeta
    ON ( wp_posts.ID = wp_postmeta.post_id )
    WHERE 1=1
    AND ( ( wp_postmeta.meta_key = ‘cwginstock_product_id’
    AND wp_postmeta.meta_value IN (‘55255’) ) )
    AND wp_posts.post_type = ‘cwginstocknotifier’
    AND ((wp_posts.post_status <> ‘trash’
    AND wp_posts.post_status <> ‘auto-draft’
    AND wp_posts.post_status <> ‘wpzoom-hidden’))
    GROUP BY wp_posts.ID
    ORDER BY wp_posts.post_date DESC

    WP_Query->get_posts()

    Plugin: back-in-stock-notifier-for-woocommerce 0,1060 seconds

    This query is loading for every product in the product list so if a hundred products are shown the query time is 10 seconds. Is there any way of deactivating View Subscribers option at the product list page so this query is not executed?
    This backend page is core so loading times are really important.

    Thank you for looking at it

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author CodeWooGeek

    (@codewoogeek)

    4 years, 6 months ago

    Hello there,

    Good Day!!!

    We’re here to assist you with this one.

    Could you please try the below steps to confirm whether this helps in reduce the query run by our plugin?

    Go to the Admin Dashboard -> Products in that page top right corner click screen options, you will see list of columns checked(checkbox) for product, just uncheck Subscribers Count checkbox.

    If the above steps not helps in reducing number of queries please let us know.

    Thanks.

    Thread Starter javierdemuga

    (@javierdemuga)

    4 years, 6 months ago

    Thank you for your fast answer,

    It is already deactivated and it does not help as Subscriber Count is still being calculated and visible at the Name Column close to Edit and Quick Edit

    (e.g: View Subscribers( 8 ) ) –

    I wonder if it is a useful information to have this information at Product list level, not for me, as this subscribers number is the accumulated subscribers even though they might have received already the back in stock email. If a product was for a long time out of stock but it is not any more the number might be high but it does not help to know if the product is very trendy right now.

    Thanks for your time

    CodeWooGeek Support

    (@codewoogeeksupport)

    4 years, 6 months ago

    Hello there,

    Good day !!

    We’ve added a troubleshoot option to remove the view subscriber link in the product list table as an option (Admin Dashboard -> Instock Notifier -> Settings -> Troubleshoot Settings (Experimental) -> Remove View Subscribers Link in Product List Table(Admin Dashboard -> Products)).
     
    But we have yet to update it on WordPress (you will receive an update in a day or two). In the meantime, if you want to use the fixed version, please download it from the below drive link and check it out.

    https://drive.google.com/drive/folders/1hxNrenrahMmG2y6LqJrZKVsjFPFu2p5H

    Let us know.

    Thanks.

    Thread Starter javierdemuga

    (@javierdemuga)

    4 years, 6 months ago

    Thank you for your fast fix! Great job, it works wonders.

    CodeWooGeek Support

    (@codewoogeeksupport)

    4 years, 6 months ago

    Hello there,

    Glad to know your reported problem has been resolved. If you feel our plugin is helpful please do rate our plugin in WordPress with your valuable feedback.

    https://wordpress.org/support/plugin/back-in-stock-notifier-for-woocommerce/reviews/

    Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Plugin slowing down backend product list page’ is closed to new replies.