search

compucorp / uk.co.compucorp.civicrm.pivotreport

CiviCRM Pivot table reporting solution
Other
8 stars 13 forks source link

database table civicrm_pivotreportcache #120

Open mikantchap opened 4 years ago

mikantchap commented 4 years ago

Hi

We recently had an issue with the database table civicrm_pivotreportcache.

It grew to about 18GB and crashed the whole server (disk full) taking down several sites.

Have you had any reports or issues regarding this table?

jamienovick commented 4 years ago

@mikantchap Thats very possible. We did our best to try and optimse the library to work with larger data sets but unfortunately the way the library works is to try and load all the data to your browser in advance so you can pivot on it in the browser. The cache table tried to prepare that data so the loading was a quick as possible, but that might not be suitable for all server setups unfortunately.

Which entity are you trying to create pivot reports on?

jitendrapurohit commented 4 years ago

In our case, it was with log_civicrm_pivotreportcache table. Probably we should rename the main table civicrm_pivotreportcache to civicrm_pivotreport_cache so the log table isn't created by civicrm?

jitendrapurohit commented 3 years ago

Have raised https://github.com/compucorp/uk.co.compucorp.civicrm.pivotreport/pull/122 to fix the above comment after we see the log table problem on another server.