Views Cache fills up gigabytes of data

Created on 23 February 2023, over 1 year ago
Updated 20 February 2024, 4 months ago

Problem/Motivation

I have just one view on the front page with 1 minute expiry for both query and rendered output. However, it fills up the DB in minutes. If left unnoticed, it can go on and fill up the database by multiple gigabytes resulting in server crash.

Filled it thousands of CIDs.

store_teaser_upgraded:page_7:results:xxx
store_teaser_upgraded:page_7:results:xxx
store_teaser_upgraded:page_7:results:xxx

Why is it saving same view again and again?

πŸ’¬ Support request
Status

Fixed

Version

3.18

Component

Miscellaneous

Created by

πŸ‡¦πŸ‡ΊAustralia standingtall

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @standingtall
  • πŸ‡¦πŸ‡ΊAustralia standingtall

    Some more information.

    I have a view which shows just the logos of from 10 taxonomy terms. Output is saved as all the fields on entire taxonomy term (20 fields attached to it). Why does output have to rendered all the fields to show just 1?

  • πŸ‡ΊπŸ‡ΈUnited States DamienMcKenna NH, USA

    It would depend upon how the output is configured.

    There are different options you could try to reduce the amount of rendering:
    1. Customize the the "default" view mode to hide all fields except for the logo. Then make sure that you have customized the "full" view mode for the normal term page.
    2. Add a new view mode to the taxonomy term, on this view mode hide all fields except for the logo, then use that view mode in the view.

  • Status changed to Fixed over 1 year ago
  • πŸ‡¦πŸ‡ΊAustralia standingtall

    Thanks mate. This fixed it.

  • πŸ‡ΊπŸ‡ΈUnited States DamienMcKenna NH, USA

    Excellent, I'm happy to hear it.

  • πŸ‡¦πŸ‡ΊAustralia standingtall

    Sorry just need a bit more help. I was able to hide fields on a taxonomy term but will need to create a different view for content types. How can I use a different display view in Views? I couldn't find any option. Cheers

  • Automatically closed - issue fixed for 2 weeks with no activity.

  • Status changed to Fixed 4 months ago
  • πŸ‡¦πŸ‡ΊAustralia standingtall

    Unfortunately, this has resurfaced again.

    1) I have hidden most fields on Taxonomy default view
    2) Full mode has been configured

    However, views cache result still picks up whole entity and saves it in cache_views_data and fills it up in no time.

    I have Entity Cache, Display Suite enabled as well.

    Only thing that helps if I turn off caching of Query results.

Production build 0.69.0 2024