woocommerce_order_itemmeta

  • Resolved Paul

    (@biopaul777)


    1 year, 6 months ago

    Hello. My woocommerce have a woocommerce_order_itemmeta table with more than 95 millions of rows and 20GB. At the same time have only 16.000 orders in total.

    Is this a normal behavior?

    We constantly delete unpair or fail orders and I′m wathching the information related to this oreders keep on this table…

    Do you know any way to optimize this table? I want delete all residual information on it.

Viewing 1 replies (of 1 total)

  • Hi @biopaul777

    woocommerce_order_itemmeta?contains metadata for the items purchased in an order. If you take a look at the staging site and view one of the orders, you’ll notice that a lot of details.

    It’s not normal for the?woocommerce_order_itemmeta?table to have such a high number of rows compared to the total orders. It seems there could be some orphaned data in the table.

    Here’s a safe way to optimize and clean up the woocommerce_order_itemmeta table. Please keep in mind to always backup your database before you proceed with any cleaning or optimization steps, as mistakes can cause data loss.

    You can try the free WP-Optimize plugin from the?www.ads-software.com?repository. And optimize the tables, for more detail check this article: https://wpastra.com/guides-and-tutorials/wordpress-database-optimization-guide/

    Remember to always take a backup of your database before executing any optimization steps.

    Thanks!

Viewing 1 replies (of 1 total)
  • The topic ‘woocommerce_order_itemmeta’ is closed to new replies.