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?
Sounds about right. IIRC the scores are stored as postmeta, which means that wp serializes them into strings.
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?
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.
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 🙂
Hi there, Has this issue been fixed? If not yet, when will this be taken care of? Thanks.
Hey guys, sorry for not having added this yet.
If some finds the time it can be implemented with
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..
- The topic ‘[Plugin: Better Related Posts] Hugh Database Tables’ is closed to new replies.