Support » Plugin: WP-Optimize » Compressing woocommerce database

  • Resolved birudaunwebstudio

    (@birudaunwebstudio)


    Hi, i love your plugin; so far i’ve run the optimization and it works very well.

    BTW, i have a 475MB woocommerce database and its optimized already. I am not sure if I can reduce it into 50% in term of size lol. Upon installing this plugin, I see in WordPress Admin – Comments it shows all the Woocommerce log such as New Order created, Order status changed from processing etc etc. There are 8,500 comments. I don’t have post/page comments in here, just woocommerce log. I did not see this before (before i install wp-optimized) or in other website. I am not sure if this can be deleted or not. The biggest table is wp_posts which is 175MB with 772,910 records. The site has about 15 pages with 40 products. FYI i have this info: No orphaned comment meta data in your database, No orphaned relationship data in your database. Any idea how to work on this? Thank you in advanced

Viewing 1 replies (of 1 total)
  • Plugin Contributor DNutbourne

    (@dnutbourne)

    Hi,

    In WordPress, most things are ‘posts’.
    Specifically, in this case, all WooCommerce products and orders are stored in the posts table.

    If you have a lot of orders, then it is unlikely that the size of the database can be reduced

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