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

ezra-g’s picture

Status: Active » Fixed

Committed, including the recently rolled patch to Views at [#8516039].

http://drupalcode.org/project/commons.git/commitdiff/1b4529b?hp=14c8abdd...

ezra-g’s picture

It helps to include the Drupal 7 core version of both patches : http://drupalcode.org/project/commons.git/commit/a513d6a .

ezra-g’s picture

The D7 version of "Optimize node access queries" needed a re-roll. http://drupalcode.org/project/commons.git/commit/90817fe

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.