CiviCRM Community Forums (archive)

I am having performance problems that seemed to be tied to a lot of SQL updates that all look like:


UPDATE civicrm_group gSET refresh_date = 20140307162734WHERE TIMESTAMPDIFF(MINUTE, cache_date,

 UPDATE civicrm_group gSET cache_date = null, refresh_date = nullWHERE id IN ( 4257 )

There are a ton of these updates being generating in a very small time window, which is leading to contention/waits on certain rows.

The groups in question are not smart groups, but are the parent group of several other groups.

Any ideas on how to address this?