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

standingtall created an issue. See original summary.

standingtall’s picture

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?

damienmckenna’s picture

Category: Bug report » Support request

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.

standingtall’s picture

Status: Active » Fixed

Thanks mate. This fixed it.

damienmckenna’s picture

Excellent, I'm happy to hear it.

standingtall’s picture

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

Status: Fixed » Closed (fixed)

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

standingtall’s picture

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.