Too many DB queries since 8.5.0

  • Resolved gerbull001

    (@gerbull001)


    1 year ago

    We have an issue since 8.5.0 whereby opening single orders results in over 6.5k db queries vs 200 queries rendering the process unusable in production due to page load speeds. We have had to rollback to 8.4.0 where the db queries are around 200 and the page load is normal.

    Using default Storefront theme, all other plugins are disabled, enabling HPOS doesn’t resolve the issue

    Thanks in advance

    Update – I think it might be related to order analytics being cached for each order and shown in the single order view?

    • This topic was modified 1 year ago by gerbull001.
Viewing 7 replies - 1 through 7 (of 7 total)
  • fox-didl

    (@fox-didl)

    We have the same issue. We checked the server and everything to get to know the reason for this massive slowing down and can’t find anything. And we found the same finally yesterday that the reason for this is WooCommerce itself. Please update this issue ASAP. We are going directly into technical issues because just of load time.

    fox-didl

    (@fox-didl)

    Tested now on staging site with 8.4. Opening a product for update in backend with 8.5.2 around 18 seconds, with 8.4 back again at 2 seconds. Images just loaded immediately know. No wait anymore necessary. We are prepairing going back to 8.4 now for all our shops – on weekend. Maybe a hotfix is possible about this.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @gerbull001 and @fox-didl,

    Have you had a chance to disable the Order Attribution feature? You can find it under WooCommerce > Settings > Advanced > Features. After disabling it, check if it resolves the issue.

    Let us know how that goes. Looking forward to hearing from you!

    B

    (@blclda)

    Hey @shameemreza, surely this can’t be only attributable to the Order Attribution feature? Our backoffice as also become extremely slow.

    Thread Starter gerbull001

    (@gerbull001)

    Hi @shameemreza,

    Thanks for your reply.

    Your suggestion of disabling Order Attribution feature does restore normal loading time for the single order detail, however we would like to use this feature without the load time issue.

    Appreciate your support.

    B

    (@blclda)

    A Ticket has been opened on github, you can access it here: https://github.com/woocommerce/woocommerce/issues/44345

    Important to have this issue fixed.

    Thanks.

    Hi @blclda,

    Thanks for sharing the link to the issue on GitHub. I suggest subscribing to the issue so as not to miss any new notifications and suggested solutions.

    Thanks.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Too many DB queries since 8.5.0’ is closed to new replies.