[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