Admin product page make 60second to show with the last version

  • Resolved calyweb

    (@calyweb)


    1 year, 4 months ago

    Hi,
    There is a big problem with your last version 5.0.1, the admin product page take 60 seconds to show whereas if i disabled it, it take 2 seconds

    I just check your requests and they are all the same

    SELECT?gubiq8c6oy_posts.ID?
    FROM?gubiq8c6oy_posts?
    INNER?JOIN?gubiq8c6oy_postmeta
    ON?( gubiq8c6oy_posts.ID = gubiq8c6oy_postmeta.post_id )?
    WHERE?1=1?
    AND?( ( gubiq8c6oy_postmeta.meta_key = ‘cwginstock_product_id’
    AND?gubiq8c6oy_postmeta.meta_value?IN?(‘477697’) ) )
    AND?gubiq8c6oy_posts.post_type = ‘cwginstocknotifier’
    AND?((gubiq8c6oy_posts.post_status = ‘cwg_subscribed’))?
    GROUP?BY?gubiq8c6oy_posts.ID?
    ORDER?BY?gubiq8c6oy_posts.post_date?DESC

    You do this for all the product, and so of course, it takes a long time for nothing because i don’t need these informations. I already tried your experimental tools to disable the stats on product admin page, but it does not change anything
    Thanks for your help

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support CodeWooGeek Support

    (@codewoogeeksupport)

    Hello there,

    Good Day!!

    We’re here to assist you with this one.

    We’d like to inform you that the performance issue you reported with the ‘Subscriber Count’ display in the product list table is due to a large number of products.

    This has been addressed in Version 5.1.0, which you can download from the following link: https://drive.google.com/file/d/1TF5xhyBKGLQRYJG7ifoi6C2u9baoeNZU/view

    To update the plugin, download the updated zip file from the above link. Navigate to  Admin Dashboard > Plugins > Add New > Upload Plugin, choose the zip file, and click Install and Activate it.

    Version 5.1.0 resolves this issue by default, disabling the subscriber count display load at all times to ensure smoother performance. You can enable it as needed.

    For an immediate solution without updating, you can navigate to the Admin Dashboard > WooCommerce: Product > Screen Options > Subscriber Count > Disable. This will streamline the page loading process.

    Let us know.

    Thanks.

    Thread Starter calyweb

    (@calyweb)

    Hi,

    Thanks for your feedback, i will try your update

    Just in case, your last solution don’t change anything, even if i disable the column in the screen options, your requests are still there ??

    Plugin Support CodeWooGeek Support

    (@codewoogeeksupport)

    Hello there,

    Thanks for trying the update.

    Could you please share the screenshot with us after installing any query monitor plugin to get more details about the loading time?

    This additional information will assist us in pinpointing the issue and providing a more effective solution.

    Let us know.

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Admin product page make 60second to show with the last version’ is closed to new replies.