Answers.Body: <p>Why are you saying it's the cause of the slowness? Did you manually make them null and measured an improvement of the speed? </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-24T17:29:29.790Z
Answers.Text: 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.
Answers.UserDisplayName: Eric H
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-09-24T08:46:53.150Z
Answers.LastActivityDate: 2015-09-24T08:46:53.150Z
Answers.UserDisplayName: Xavier
Body: <p>In the table <code>civicrm_group</code>, I've noticed that even my non-smart groups have the fields <code>where_clause</code>, <code>where_table</code>, and <code>select_table</code> filled in. These don't seem necessary and cause a fair amount of slowness. </p>
  
  <p>Is their a reason they exist, and is there a down-side to making those fields null in non-smart groups?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-09-24T09:01:02.430Z
Comments.Text: "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?
Comments.UserDisplayName: Chris Burgess
Tags: <groups><smartgroups>
Title: Attributes of dumb groups
ThreadText: # Attributes of dumb groups
  
  (Asked by: username_0 on 2015-09-23)
  
  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?
  
  **Tags:** groups, smartgroups
  
  > **Comments:**
  > **username_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?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-09-24. Score: -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?
  
  > **Comments:**
  > **username_0**: 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.  
  
  ---
  
  