Discussion Forum

tsamant

Member

From: Chicago

Registered: May 14, 2015

Posts: 52

Clearing the view cache

I am about to run

delete from `bigtree_module_view_cache`;

directly on the production server.

Am I right in thinking that this will definitely, absolutely have no effect whatsoever on the user-facing site?

Thanks,
Tushar

(this one table is now 2/3rds of the db)

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 974

Re: Clearing the view cache

Right, you can safely clear the module view cache - it will be rebuilt when you revisit a module view and has no effect on the front end.

The only advantage to emptying it is if you have stale data (e.g. you didn't properly cache an item when adding it to the database). It'll grow back to its original size once you visit all the module views that feed it.

tsamant

Member

From: Chicago

Registered: May 14, 2015

Posts: 52

Re: Clearing the view cache

OK, I think I will not clear module view caches after all.

It's still good to know--for instance I could clear it on a staging server etc.

Thanks!
Tushar