[rt-users] RT 3.6 performance problems

[Jesse Vincent]

On Fri, Aug 25, 2006 at 01:56:59PM +0200, Theo Kramer wrote:
> On Thu, 2006-08-24 at 11:56 -0400, Jesse Vincent wrote:
> 
> > Send this to the list:
> > 
> > SELECT * FROM ACL WHERE RightName = 'OwnTicket';
> > 

Next up:
SELECT * from Groups where id = 11;
SELECT * from Groups where id = 3;

> Attached
> -- 
> Regards
> Theo

> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> | id  | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId | DelegatedBy | DelegatedFrom |
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> |  34 | Group         |       66700 | OwnTicket | RT::Queue  |        3 |           0 |             0 |
> | 211 | Group         |       66700 | OwnTicket | RT::Queue  |        7 |           0 |             0 |
> |  53 | Group         |       66705 | OwnTicket | RT::Queue  |        7 |           0 |             0 |
> | 207 | Group         |       66706 | OwnTicket | RT::Queue  |        7 |           0 |             0 |
> |  59 | Group         |       66701 | OwnTicket | RT::Queue  |        8 |           0 |             0 |
> |  75 | Group         |       66702 | OwnTicket | RT::Queue  |       10 |           0 |             0 |
> |  84 | Group         |       66704 | OwnTicket | RT::Queue  |       10 |           0 |             0 |
> | 218 | Group         |       46741 | OwnTicket | RT::Queue  |       11 |           0 |             0 |
> |  95 | Group         |       66706 | OwnTicket | RT::Queue  |       11 |           0 |             0 |
> | 110 | Group         |       66707 | OwnTicket | RT::Queue  |       12 |           0 |             0 |
> | 123 | Group         |           3 | OwnTicket | RT::Queue  |       13 |           0 |             0 |
> | 137 | Group         |       56299 | OwnTicket | RT::Queue  |       13 |           0 |             0 |
> | 147 | Group         |       56299 | OwnTicket | RT::Queue  |       14 |           0 |             0 |
> |   2 | Group         |          11 | OwnTicket | RT::System |        1 |           0 |             0 |
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> 14 rows in set (0.03 sec)
> 

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

--