WooCommerce make slow queries?

  • Resolved Paul Vek

    (@paulvek)


    11 months ago

    hello and thank you for your plugin

    i have a question. does WooCommerce make slow queries? please see this pictur

    Query

    SELECT method_id, method_order, instance_id, is_enabled
FROM wp_woocommerce_shipping_zone_methods
WHERE zone_id = 1

    Caller

    WC_Shipping_Zone_Data_Store->get_methods()
wp-content/plugins/woocommerce/includes/data-stores/class-wc-shipping-zone-data-store.php:167
WC_Data_Store->__call()
wp-content/plugins/woocommerce/includes/class-wc-data-store.php:224
WC_Shipping_Zone->get_shipping_methods()
wp-content/plugins/woocommerce/includes/class-wc-shipping-zone.php:164
WC_Shipping_Zones::get_zones()
wp-content/plugins/woocommerce/includes/class-wc-shipping-zones.php:36
Automattic\W\B\S\ShippingController->hydrate_client_settings()
wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/Shipping/ShippingController.php:306
do_action('admin_enqueue_scripts')
wp-includes/plugin.php:517

    Time

    0,0729

    this is for woocommerce or other plugins conflict with this? Thank you in advance for your reply.

Viewing 8 replies - 1 through 8 (of 8 total)
  • anastas10s

    (@anastas10s)

    Hi there @paulvek ??

    Thanks for reaching out to Woo Support!

    does WooCommerce make slow queries? please see this pictur
    […]
    this is for woocommerce or other plugins conflict with this?

    From what I gather, you are noticing a 3rd party plugin reporting 7/100s of a second as slow queries at your store. Correct?

    Just to clarify, how are you measuring this? Additionally, only the WooCommerce plugin is installed and activated on top of WordPress, or otherwise?

    Once I hear back from you, I will be happy to investigate this further.

    Regards,

    Thread Starter Paul Vek

    (@paulvek)

    Thank you for your response @anastas10s

    Other plugins are also installed. But these are only created for WooCommerce according to the image I attached.

    Hey, @paulvek!

    Other plugins are also installed. But these are only created for WooCommerce according to the image I attached.

    All right. Can you tell us how you are measuring this?

    To see if another plugin is causing conflicts you can perform a plugin conflict test.

    To test, you’ll first want to change the theme on your site to Storefront, then check to see if the issue is still present. If that resolves the issue, you’ll want to get in touch with your theme’s developer and see if they have an update or fix for you.

    If changing the theme doesn’t help, you’ll want to deactivate all plugins except for WooCommerce and take a look. If that fixes the problem, re-enable the other plugins one by one (gradually), checking after each, to see where the issue is coming from.

    You can find more about this in this guide.

    I hope this was clarifying. If you face any issues or have any questions, please let us know so we can assist you further.

    Have a wonderful day!

    Thread Starter Paul Vek

    (@paulvek)

    I will do this as soon as possible @carolm29

    here is my gist

    https://gist.github.com/paulvek/31a0bc693753d71a5c2b1be6b553ae6e#file-gistfile1-txt

    Could this help you before I test them?

    Hey, @paulvek!

    Thank you for sharing the status report. I don’t see anything on the report that seems wrong.

    Please let us know if the conflict test helped ??

    Have a wonderful day!

    Thread Starter Paul Vek

    (@paulvek)

    hi @carolm29 , @anastas10s I checked today and didn’t see this problem again! Could it be because of the pressure on the server and the quality of shared hosting? Or does it have nothing to do with it?
    Anyway, these are all possibilities. I will check again, if there is a problem and I encounter it again, I will do the test in different conditions and report the result to you. Thank you very much for your reply.

    • This reply was modified 10 months, 4 weeks ago by Paul Vek.
    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Paul Vek,

    Thank you for your reply.

    I am delighted to hear that the issue you were experiencing was resolved.

    It is indeed possible that the problem was related to server pressure, particularly if you’re on a shared hosting environment.
    Shared hosting can sometimes face performance fluctuation, especially if other sites on the same server are experiencing high traffic.

    For a better understanding of optimal server conditions and how they can impact your WooCommerce store, you might find the following guides useful:
    – Server Requirements for WooCommerce
    – Choosing the Best Host for Your WooCommerce Store

    Please keep an eye on your site’s performance, and if the issue reoccurs or if you have any further questions, don’t hesitate to get back in touch.
    We’re here to help you ensure your store runs smoothly.

    Have great day! ??

    Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Hey there ??,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.

    Cheers!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘WooCommerce make slow queries?’ is closed to new replies.