[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