[rt-devel] Users::WhoHaveRight and Sybase and Sudden MySQL slowness

[Jesse Vincent]

On Thu, Jun 26, 2003 at 04:01:41PM -0400, John Stoffel wrote:
> 
> 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?

Jeff is a member of the sysadmin group. the sysadmin group is a memeber
of the operations team, etc. This sort of functionality is critical in a
number of organizations.

> 
> John
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.