Currently, Opigno can get very slow. The many OG relationships require very heavy DB queries, and because many Views or displays are unique for each user, caching is generally avoided.

Proposed solution

Caching a lot of data per user is not necessarily advised, but 1000s of queries per user on each page refresh is probably worse. We should do some benchmarks, check how the database reacts when there are many, many cache entries. Even a 5min cache can make a huge difference on systems with many users.

Check how Memcache (or other systems) react when facing 1000s of entries.

Rewrite queries, maybe some menu alters, or check with OG team how we could implement this in a safe and sound way.

Comments

florisg’s picture

take a look at: https://www.drupal.org/project/views_og_cache
it helped us quite a bit.