postmeta

  • Resolved dluera

    (@dluera)


    4 years, 5 months ago

    Hello,

    I am currently cleaning out the database for someone, and what I narrowed down is the metadata that is being stored in the database by this plugin is the reason why they are sitting at ~5,444,076 within the wp_postmeta is their custom fields are being stored there with each transaction over however amount of time they have been around, do you have recommendations on safely clearing out the bulk of this?

    for example after querying:

    _billing count = 1064538

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Tomasz WP Desk

    (@tomaszwp)

    Hello @dluera,

    To get rid of these values ??some old orders have to be deleted. Please let me know how many orders and fields there are.

    Thread Starter dluera

    (@dluera)

    Easily over 81k orders, and 18 custom fields I at first thought they had malware, but this is starting to make more sense.

    Plugin Support Tomasz WP Desk

    (@tomaszwp)

    Hello @dluera,

    Well – just as I thought. Please delete old orders to significantly reduce the size of the database. WooCommerce adds most of the postmeta and this plugin is primarily responsible for the size of the database.

    Plugin Support Tomasz WP Desk

    (@tomaszwp)

    I am marking this topic as resolved as we have not received any new replies.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘postmeta’ is closed to new replies.