I work with a CiviCRM install with about 400 smart groups - but only about 30 of them are enabled. I'm seeing slow performance - I'm wondering if anyone knows definitively whether my disabled smart groups are affecting performance?
Pretty sure that we only consider active groups to regenerate the cache:
also most smart groups are regenerated on demand. The scheduled job invokes the loadAll function with groupsIDs as null, which in turn restricts the query to is_active groups