[rt-devel] Users::WhoHaveRight and Sybase and Sudden MySQL slowness
John Stoffel
stoffel at lucent.com
Thu Jun 26 16:01:41 EDT 2003
Jesse> Nope. This Cache is Caching recursive group membership, which
Jesse> would otherwise hurt REALLY badly (O(n) SQL queries just as bad
Jesse> as the current query per acl question)
Then the question I ask is *why* have recursive group membership at
all? It seems to me that it just expands exponentially the number of
permutations to go through.
It would seem that it's simple enough, each user is a member is X
groups. Each group has Y privs. Is this what you're trying to cache?
John
More information about the Rt-devel
mailing list