HPOS cleaning post/postmeta data

  • Resolved Colissimo

    (@iscpcolissimo)


    1 year, 7 months ago

    Hello,

    Will you be adding an option to clean the post and postmeta tables from WooCommerce data once the HPOS option is stable?

    We have over 2.5M postmeta entries related to WooCommerce order/subscriptions/addresses that slow down a lot our website. The main purpose of the HPOS feature is to avoid that, but if there is no way to clean the data once the sync is done, it doesn’t help much.

    If you don’t intend to add an option to clean the wc data from the post/postmeta tables, could you tell me if it’s safe to run DELETE queries on these tables for shop_order/shop_subscription posts?

    Thank you

Viewing 3 replies - 46 through 48 (of 48 total)

  • The delete old post meta or posts, is not working, it just ran 3 times and then does nothing to the database size with me. my postmeta table is 800mb and is about 90% orders and i disabled every optimalization plugin (yes also caching, combining, minifying).. can you explain what is wrong with the feature?

    As Shadowbox has just pointed out above, and I have also just discovered, the tool runs but does NOT remove order data from postmeta table so it is still very large and WordPress admin pages are very slow.

    This is clearly NOT RESOLVED.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello shadowbox0028, Will Dobson

    Thank you for your message here.

    As per forum guidelines, I suggest you create new topics so we can assist you separately.
    I appreciate your cooperation.

    Have a great day!

Viewing 3 replies - 46 through 48 (of 48 total)
  • You must be logged in to reply to this topic.

Tags