In the table civicrm_group, I've noticed that even my non-smart groups have the fields where_clause, where_table, and select_table filled in. These don't seem necessary and cause a fair amount of slowness.

Is their a reason they exist, and is there a down-side to making those fields null in non-smart groups?

  • 1
    "and cause a fair amount of slowness" - I'd be interested to hear more - where/what speed improvement are you seeing when these are NULL? Sep 24, 2015 at 9:01

1 Answer 1


Why are you saying it's the cause of the slowness? Did you manually make them null and measured an improvement of the speed?

  • 2
    Yes. This was my method: I loaded a 14,000 record group five times. Load time averaged 30 seconds. I then made where_clause, where_table, and select_table NULL for that group and loaded the group 5 more times at an average of 23 seconds. To be fair, I have to concede that there may have been other variables at play since the site was online while I did this.
    – Eric H
    Sep 24, 2015 at 17:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.