Cache DB Table getting very big

  • Hi there,

    I have noticed that the Database Table “wp_yarpp_related_cache” is growing bigger and bigger. It has more than 800.000 entries now.

    Is there a safe way to get this smaller? And prevent it from growing?
    Is this Cache really needed in this size?

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Michael Nelson

    (@mnelson4)

    Hi @gerdski ya that is getting really big. Although it’s a pretty skinny table… out of curiosity, do you know how much diskspace that takes up?

    I see YARPP itself truncates that table (ie, removes all those rows) whenever you update its settings, so it seems safe to truncate the table manually.

    About how to prevent it from growing, I’m not sure yet. How many posts does your site have?

    Plugin Support Michael Nelson

    (@mnelson4)

    Update: YARPP stores an entry in there for every relation between posts meeting your threshold.
    Ie, if you set the matching threshold to 1, and when viewing a lost, there are 100 posts that meet that threshold for that post, there will be 100 more rows saved to that table. (Even if you only display 3 related posts… which is obviously inefficient. See https://github.com/mnelson4/yet-another-related-posts-plugin/issues/12)
    For now, if you increase the matching threshold, all those rows will be cleared, and fewer should be made in the future.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Cache DB Table getting very big’ is closed to new replies.