[rt-devel] Override global ACL

[plasma]

On Sun, Feb 02, 2003 at 02:01:06AM +0800, plasma wrote:
> 
> Maybe some of you would like to override global ACLs in a queue.
> Attached is the patch against .64.

And I found a slowness caused by this patch.  Drop the following
index

  CREATE INDEX ACL1 on ACL(RightName, ObjectType, ObjectId,
  PrincipalType,PrincipalId);

by

  DROP INDEX ACL1 on ACL;

and add the following index:

  CREATE INDEX ACL1 on ACL(RightName, ObjectType, PrincipalType,PrincipalId);

Before the patch, some ACL queries will be VERY VERY slow.  Although
the index is for OverrideGlobalACL patch, it should work on vanilla
RT.


plasma

==========================================================
 «e¥b¦~­É¤Q¸U§K®§
 http://edm-prg.epaper.com.tw/click.php?ad_code=1401
==========================================================
 PC home Online ºô¸ô®a®x¡G·|­û²Ä¤@¡A¥xÆW³Ì¤jªº¤J¤fºô¯¸
==========================================================