WordPress.org

Ready to get started?Download WordPress

Forums

Better Related Posts
Hugh Database Tables (9 posts)

  1. SantaCruze
    Member
    Posted 2 years ago #

    Heya there,

    Ive the Better Related Posts Plugin running on a WordPress Blog with about 16k Posts. About 2 days after activation, the postmeta Table is already at 1.6 Gigabyte of Data, most of em from Better Related Posts.

    Is that normal? I kept nearly everything like the standard configuration but 1.6 Gigabyte is much data in one table. Any Solutions?

    http://wordpress.org/extend/plugins/better-related/

  2. nkuttler
    Member
    Plugin Author

    Posted 2 years ago #

    Sounds about right. IIRC the scores are stored as postmeta, which means that wp serializes them into strings.

  3. SantaCruze
    Member
    Posted 2 years ago #

    Yeah sure, but my DB grew in a coupe of days from 100MB to 1.8GB so far. Is there any "check" if all entries are unique made?

  4. nkuttler
    Member
    Plugin Author

    Posted 2 years ago #

    The entries are unique, unless you change the storage_id setting on the admin page. It's also possible to store the scores as transients, see http://codex.wordpress.org/Transients_API . So it's for example possible to store them in memory with memcached.

    I've just checked the code and see that I never added the post meta cleanup code. I'll do this asap, the scoring data really should be dropped sometimes.

  5. SantaCruze
    Member
    Posted 2 years ago #

    Hey Nkuttler,

    Thanks that would be nice. Wel if i would em save in transients and if i get u right, my RAM would soon full of it. A Cleanup Code would be better i think :)

  6. allieai
    Member
    Posted 2 years ago #

    Hi there, Has this issue been fixed? If not yet, when will this be taken care of? Thanks.

  7. web559
    Member
    Posted 1 year ago #

    Also wondering what the status of this is.

  8. nattila
    Member
    Posted 1 year ago #

    post meta cleanup really would be a nice feature

  9. nkuttler
    Member
    Plugin Author

    Posted 1 year ago #

    Hey guys, sorry for not having added this yet.

    If some finds the time it can be implemented with

    http://codex.wordpress.org/Function_Reference/register_uninstall_hook

    http://codex.wordpress.org/Function_Reference/delete_post_meta

    and probably a WP_Query() to loop over all posts.

    I don't use wordpress personally any more, only for client projects, so I'm less motivated to fix stuff in my free plugins... sorry..

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic