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?
Comments
Comment #2
standingtallSome 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?
Comment #3
damienmckennaIt 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.
Comment #4
standingtallThanks mate. This fixed it.
Comment #5
damienmckennaExcellent, I'm happy to hear it.
Comment #6
standingtallSorry 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
Comment #8
standingtallUnfortunately, 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.