search

UniversityOfAlberta / GrandForum

GRAND Forum
GNU General Public License v2.0
2 stars 2 forks source link

Improve performance of rolesCache #180

Closed Finalfantasykid closed 5 years ago

Finalfantasykid commented 5 years ago

The size of the roles cache has grown to the point where it is affecting performance and memory usage. Most requests need to fetch the full roles cache which takes time and memory.

This needs to be cached differently, or more efficiently queried.

Finalfantasykid commented 5 years ago

Reduced memory usage considerably by simplifying the cached data that is stored. This also sped up performance. It is using more db queries, but they are simple, and probably already cached by mysql.