Database is over 9000k! WP Post Meta orphans?

  • R J

    (@tzzel)


    10 years, 2 months ago

    Hi everyone,

    I have a client’s site that is oddly slow. I say oddly because when I do load tests, I never get anything over 4.5s. However, when I am actually editing it myself, the site can become downright unresponsive!

    It’s hosted on Hostgator (I know it’s not the best shared host). It’s a WordPress site. Looking at the SQL file, it measures in at just over 9MB (it was about 14MB before I optimized it). A bulk of the size comes from the wp_post_meta table.

    _wp_attached_file = 6005 items
    _wp_attachment_metadata = 5985

    I did not design the site, so I’m not sure where all these items came from. However, I know that given the site, that 6000 attachments must mean that there are a lot of orphans.

    Can anyone verify? And can anyone please let me know the best approach for this? I just want to edit my client’s site without going crazy waiting for it to load.

    Thank you.

    -RONALD

  • The topic ‘Database is over 9000k! WP Post Meta orphans?’ is closed to new replies.