On a recent project using OG_Access with private content where users had thousands of group memberships, performance was poor. Two optimizations we identified that resulted in significant improvements:
#106721: Optimize node access query building - Which also requires an equivalent patch to Views' content access filter, forthcoming.
#2199001: Statically cache node access grants
Let's include those in Commons.
Comments
Comment #1
ezra-g commentedCommitted, including the recently rolled patch to Views at [#8516039].
http://drupalcode.org/project/commons.git/commitdiff/1b4529b?hp=14c8abdd...
Comment #2
ezra-g commentedIt helps to include the Drupal 7 core version of both patches : http://drupalcode.org/project/commons.git/commit/a513d6a .
Comment #3
ezra-g commentedThe D7 version of "Optimize node access queries" needed a re-roll. http://drupalcode.org/project/commons.git/commit/90817fe