cache build so quickly and become huge table especially cache_views_data. Example- database size:
Before clearing cache: 1.0GB (of that 618.2 MiB for cache_views_data)
After clearing cache : 339.1 MiB

Views version is 6.x-2.12, Drupal Pressflow 6.20.

Any thoughts?

Comments

dawehner’s picture

dawehner
Primary language German
commented

On what views do you have setup views caching?

tcibah’s picture

tcibah commented

View: Nodecomment, Caching: Nodecomment thread

Entries of cache_views_data table are like:
nodecomments:nodecomment_comments_1:results
nodecomments:nodecomment_comments_1:output

dawehner’s picture

dawehner
Primary language German
commented
Project: Views (for Drupal 7) » Node Comments
Version: 6.x-2.12 » 6.x-3.x-dev

Let's move to nodecomment first.

Maybe it's a problem of it's cache plugin implementation. How many nodes do you have on your sites?
It could be that one entry per node is created and so quite big.

  function option_defaults(&$options) {
$options['argument'] = '';
  }

This small code should use option_defintion instead of option_defaults.

tcibah’s picture

tcibah commented

Thanks for your very responsive support.

Node_comment nodes: 34,884 growing rapidly
All node inclusive of node_comment: 65,768

Yes. File nodecomment/views/nodecomment_plugin_cache_comments.inc has that code;

class nodecomment_plugin_cache_comments extends views_plugin_cache {
function option_defaults(&$options) {
$options['argument'] = '';

Are you saying we change:
function option_defaults(&$options) {
to
function option_defintion (&$options) {

crea’s picture

crea commented

how many nodes (that have comments) do you have ?