Database bloat

  • Resolved jamminjames

    (@jamminjames)


    1 year, 1 month ago

    I noticed a ton of postmeta table entries in our database with a meta_key of “id_field”, “filter” and “__defaults_set” (11450 entries each) and others apparently tied to NextGen. They all have the same value (eg, “1” for “__defaults_set”). Are all these entries necessary? If not, is there a way to clean them out?

    I started looking into it because we are getting very slow postmeta queries by the WordPress core, from the wp-admin/includes/template.php file, meant to get custom fields on a post/page edit screen. So, we’re looking to clean that table up, if possible.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Imagely

    (@imagely)

    Hi @jamminjames,

    Thanks for asking us. We don’t recommend deleting these, as NextGen Gallery stores its settings there, and it’d be easy to delete something that’s necessary.

    We’ll check with the devs to see if they perhaps have any other suggestions.

    • This reply was modified 1 year, 1 month ago by Imagely.
    • This reply was modified 1 year, 1 month ago by Imagely.
    Thread Starter jamminjames

    (@jamminjames)

    I hope they can fix it so it doesn’t continue to record the same info over and over again. It’s a real database bloater, as I said.

    Thread Starter jamminjames

    (@jamminjames)

    Looking into this further, it seems to be recording these entries for every single post, whether or not a NextGen gallery is present. Since we have many thousands of posts, it really adds up. Please suggest to them that they code it so it only records these entries for posts or pages with a NextGen gallery.

    Plugin Contributor Imagely

    (@imagely)

    Hi @jamminjames,

    We have received our developers’ reply mentioning that these meta entries are semi-necessary. ?If you are not using Pro, you can safely delete them, but they’ll get recreated.

    We plan to replace our whole?DataMapper?system sometime in the future to avoid this behavior.

    Thread Starter jamminjames

    (@jamminjames)

    Okay, thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Database bloat’ is closed to new replies.