wp_wc_order_stats randomly taking a long time to fill out

  • I have noticed that the data from an order can sometimes take a really long time to populate. I have a program checking for new orders and when one is created and processing, it will grab the info for our production staff. I have not seen any rhyme or reason to when this occurs. An order has to be 2 minutes old before downloading. It grabs customer info first just fine, but when it tries to get info from this table, it will sometimes be empty. Most of the time, there is no delay whatsoever. Then randomly, it will be empty for anywhere from 2 minutes to almost an hour. I do have one recurring crit error but has to do with a coupon plugin, but I don’t think that is affecting this.

    for instance, this morning, an order had problems downloading starting at 3:45 and didn’t get into our system until 4:37. Another order came in later at 745, had a few minutes hard time and was in by 7:50. an hour later, an order came in at 8:45 with no delay. It usually has a slow down at least once per day, but it can be in the middle of the night or day.

    Thanks for any insight.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    I recommend asking at https://www.ads-software.com/support/plugin/woocommerce/#new-post so the plugin’s developers and support community can help you with this.

    It sounds like there may be an issue with the way your program is retrieving data from the orders table in your database. The fact that the data is sometimes empty for a long period of time, and that there doesn’t seem to be a clear pattern to when this occurs, suggests that the issue may be related to the performance of the database or the server.

    There are a few things you can try to troubleshoot this issue:

    Check the server’s resources: Make sure that your server has enough resources (e.g. CPU, memory) to handle the volume of requests your program is making. High server load can slow down database performance.

    Check the database performance: Use a tool like MySQL Tuner to check the performance of your database, and make sure that it is properly configured for the volume of data you are working with.

    Check your program’s code: Make sure that your program is optimized for performance and that it’s not making unnecessary requests to the database.

    Check the server’s logs: Check the server’s error logs to see if there are any errors related to the database or your program that may be causing the issue.

    Check for external factors: It could be due to external factors, like network connectivity issue or any other issue that might occur during the time of the query.

    It’s recommended to check the above points and see if you can identify the root cause of the issue. If you are still unable to resolve the problem, it may be necessary to consult with a developer or a system administrator with more experience in troubleshooting database and server issues.

    Thread Starter homeschooldiplomait

    (@homeschooldiplomait)

    thanks sorry i’ll get it over to woocommerce, that slipped my eyes

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_wc_order_stats randomly taking a long time to fill out’ is closed to new replies.