HPOS cleaning post/postmeta data

  • Resolved Colissimo

    (@iscpcolissimo)


    1 year, 4 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 15 replies - 1 through 15 (of 45 total)

  • Hello, I was also wondering today how to delete data from the old table.

    Have you found any reply somewhere else ?

    Thank you.

    Thread Starter Colissimo

    (@iscpcolissimo)

    Not yet, I’m quite surprised this wasn’t explained in the official HPOS guides, or at least I didn’t find this information.

    Actually it seems simple, just delete in sql ?

    but better wait that it is officially launched and that other people do it first ??

    Thread Starter Colissimo

    (@iscpcolissimo)

    We need an official answer, or instructions in an official guide. Trusting anyone outside of WooCommerce isn’t safe enough when running an e-commerce website with active data (even if multiple people say that a specific method works).

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @iscpcolissimo

    As of now, we do not have any official information about such an option being added. However, we do understand the need for optimizing your database and are continuously working on improving the performance of WooCommerce.

    Since last year, we’ve been actively working to develop and launch HPOS (High-Performance Order Storage) as a feature you can opt into. However, we’re still unsure when we’ll be able to add this as an option in the WooCommerce Core. Feel free to check out this announcement to learn more about it.

    As for manually deleting data from the post/postmeta tables, we strongly advise against running DELETE queries directly on your database unless you are absolutely sure of what you’re doing. This is because it can lead to data loss and potentially break your site if not done correctly. It’s always recommended to take a complete backup of your website before making any changes directly to the database.

    However, if you’re experiencing performance issues due to a large number of postmeta entries, we recommend you to consider using a plugin like WP-Optimize or Advanced Database Cleaner which can help you clean up your database safely.

    We highly recommend contacting a developer or a professional if you’re uncomfortable doing this yourself. If you need further assistance, feel free to ask.

    Thanks!

    Thread Starter Colissimo

    (@iscpcolissimo)

    Hi,

    Thank you for your answer, please keep us updated if something is decided about adding a data cleaning option.

    We’ll keep our data as it is for now and check the two plugins you mentioned ??

    Saif

    (@babylon1999)

    Hello @iscpcolissimo,

    You can track all HPOS-related enhancements from here: https://github.com/orgs/woocommerce/projects/124/views/3

    Our team also frequently posts on the WooCommerce development blog so I suggest you click the follow button to stay informed about WooCommerce-related updates. :?)

    I will be marking the thread as solved for now, but feel free to open a new thread if you have any other questions. :?)

    Cheers!

    I got here from googling around a way to clear the postmeta tables as mine has over 8 milions records and I am already using multiple caches (server and wp) but searching through posts is almost always pain so I would like to see a way to clean the old tables and allow the switch to new tables only (HPOS).

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @rwky

    I understand that you are experiencing the same issue.

    Since each site setup differs, and in order to align with forum best practices, please can you start your own topic so that we can address your issue(s) separately?

    Thanks!

    @shameemreza starting a different thread would leave other people that arrive here via internet searching with no answer.
    Even if I do start the new thread, I fail to see how would that help?

    @rwky I totally agree with you, they are so annoying with their BS new threads. When they have no useful and smart reply to tell they should just say it and apologise for being so useless…

    @catvetbeb yup, they even mark the issues as resolved… cleary not.

    @rwky yes, they are more cleaners than helpers, their only target is to close the posts and promote automaticc overpriced scam plugins…

    the plugins are not a scam, I have a few of them and they work very well; but the way they threat real problems is very… strong evidence the internal comunications between dev and support is non-existent.

    @rwky So you are exactly the same as them if you do not understand they scam pricing for people who manage many websites. Maybe you even think that they are a friendly company selling you things at a cheap price hahahaha…

Viewing 15 replies - 1 through 15 (of 45 total)
  • You must be logged in to reply to this topic.

Tags