Okay
  Public Ticket #1077875
postmeta table is HUGE!!
Closed

Comments

  •  2
    Larry Levenson started the conversation

    My postmeta table has soared to 138454 rows -- it's HUGE! How can I clean this table without losing something important.

    I am very comfortable working in phpMyAdmin. Can you suggest a few queries to start to cleanup this table? Most of the rows have a meta_key that starts with _nectar_.

    I'm running Salient theme.

    Thanks!

    Larry

  •  3,030
    Andrew replied

    Hi Larry,

    I hope you are having an awesome day and thanks for contacting us regarding your query.

    What version of the theme are you using? Using an older version may have some effect on this, so kindly send through that information, along with a link to your site so that we can make some further inspections.

    Also, you may try to use the WP Optimize plugin and see if that can do some cleaning in your database without you lifting much weight.

    https://wordpress.org/plugins/wp-optimize/

    I look forward to your reply 

    Cheers! 

  •  2
    Larry Levenson replied

    I'm running Salient 7.6. Took down the Coming Soon page so you want see it -- still under construction.

    Larry

  •  3,030
    Andrew replied

    Hi Larry, 

    Thanks for that, but I'd still need a link to your site to have a look. 

    Have you tried the plugin? 

    Let me know how it goes. 

    Cheers