Big Database – 40k+ Orders

  • Resolved antanast

    (@antanast)


    5 years, 1 month ago

    Hi everyone.

    We have about 40k orders on our shop and the DB is getting quite big. I am wondering, what would the best practices be in such cases? Looking at our DB our woocommerce_order_itemmeta is about 300 MB with hundreds of rows.

    What would our best options be? Someone suggested exporting orders and deleting them from the site, but that means customers would lose history and track of their orders.

    Thanks!

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

  • Hi @antanast,

    If you aren’t keen on deleting/exporting orders, then you’d want to look at the best ways to optimize your site.
    I suggest reaching out to Mindsize to see if they can offer any assistance.
    Due to their strong history in scaling larger sites, they would be the best to assist in ensuring your site’s performance doesn’t begin going downhill anytime soon.

    Thank you,
    Joey

    Thread Starter antanast

    (@antanast)

    Thx man!

    Already looking to optimize the db. Is exporting / deleting the old orders something common for big sites on woo? If so, how would customers be able to retrieve their old purchases?

    40k orders is not that many. If you were dealing with 1-1.5 million orders then that might be something else.

    You could test the custom orders table plugin on a staging site.
    https://github.com/liquidweb/woocommerce-custom-orders-table

    @antanast,

    @lukefiretoss is right here and I might have overestimated.
    I’d check with his solution and see how that works for your situation.

    Thank you,
    Joey

    We haven’t heard back from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any further questions!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Big Database – 40k+ Orders’ is closed to new replies.

Tags