[rt-users] RT 3.6 performance problems

[Jesse Vincent]

I'm betting it's your "research" queue.

On Wed, Sep 13, 2006 at 05:13:54PM -0500, Jackie Hamilton wrote:
> 
> Sorry to rehash this thread, but I'm still having trouble with the Tickets page having all 150K+ users in the "Owner" pull down, rendering the page unusable. I downgraded our MySQL to 4.1.21, so I know it's not a MySQL 5.0 issue.
> 
> I've reviewed the previous thread where another user was having this problem. I'm not clear on the solution though. In Theo's case it looked like it was related to a disabled queue having OwnTicket rights. However, none of the queues on my system are disabled:
> 
> mysql> SELECT * FROM ACL WHERE RightName = 'OwnTicket' order by ObjectId;
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> | id  | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId | DelegatedBy | DelegatedFrom |
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> |   2 | Group         |          11 | OwnTicket | RT::System |        1 |           0 |             0 |
> |  19 | Group         |      332274 | OwnTicket | RT::Queue  |        3 |           0 |             0 |
> |  37 | Group         |      332273 | OwnTicket | RT::Queue  |        4 |           0 |             0 |
> |  64 | Group         |      193983 | OwnTicket | RT::Queue  |        5 |           0 |             0 |
> |  63 | Group         |      203501 | OwnTicket | RT::Queue  |        5 |           0 |             0 |
> |  65 | Group         |      294765 | OwnTicket | RT::Queue  |        5 |           0 |             0 |
> | 104 | Group         |      217313 | OwnTicket | RT::Queue  |        6 |           0 |             0 |
> | 103 | Group         |      332274 | OwnTicket | RT::Queue  |        6 |           0 |             0 |
> | 130 | Group         |      332273 | OwnTicket | RT::Queue  |        8 |           0 |             0 |
> | 154 | Group         |      332275 | OwnTicket | RT::Queue  |        9 |           0 |             0 |
> | 155 | Group         |      179139 | OwnTicket | RT::Queue  |        9 |           0 |             0 |
> | 156 | Group         |      203501 | OwnTicket | RT::Queue  |        9 |           0 |             0 |
> | 183 | Group         |      332276 | OwnTicket | RT::Queue  |       10 |           0 |             0 |
> | 203 | Group         |      332277 | OwnTicket | RT::Queue  |       11 |           0 |             0 |
> | 220 | Group         |           3 | OwnTicket | RT::Queue  |       12 |           0 |             0 |
> | 221 | Group         |      332273 | OwnTicket | RT::Queue  |       12 |           0 |             0 |
> | 244 | Group         |      332278 | OwnTicket | RT::Queue  |       13 |           0 |             0 |
> | 265 | Group         |      294765 | OwnTicket | RT::Queue  |       15 |           0 |             0 |
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> 18 rows in set (0.00 sec)
> 
> mysql> select id,Name,Created,LastUpdated,Disabled from Queues where id in (1,3,4,5,6,7,9,10,11,12,13,15);
> +----+------------+---------------------+---------------------+----------+
> | id | Name       | Created             | LastUpdated         | Disabled |
> +----+------------+---------------------+---------------------+----------+
> |  3 | backlog    | 2003-11-07 00:14:17 | 2003-11-07 00:14:17 |        0 |
> |  4 | general    | 2002-09-09 13:13:55 | 2002-09-12 06:53:25 |        0 |
> |  5 | inventory  | 2004-10-12 13:58:14 | 2004-10-12 13:58:14 |        0 |
> |  6 | it         | 2003-01-10 02:09:41 | 2003-01-10 02:09:41 |        0 |
> |  7 | jobs       | 2006-06-01 15:15:44 | 2006-06-01 15:15:44 |        0 |
> |  9 | ops        | 2003-01-10 02:10:16 | 2003-01-10 02:10:16 |        0 |
> | 10 | pr         | 2003-01-10 02:02:30 | 2003-01-10 02:02:30 |        0 |
> | 11 | promotions | 2003-03-06 13:35:56 | 2003-03-06 13:35:56 |        0 |
> | 12 | research   | 2005-02-18 15:50:25 | 2005-02-21 12:40:33 |        0 |
> | 13 | sales      | 2003-01-07 12:59:26 | 2003-01-08 16:58:23 |        0 |
> | 15 | suggest    | 2005-08-12 14:16:21 | 2005-08-12 14:18:11 |        0 |
> +----+------------+---------------------+---------------------+----------+
> 11 rows in set (0.00 sec)
> 
> 
> How do I fix this so the "Owner" list doesn't consist of every user in the db? What should I be looking for, here?
> 
> Thanks,
> 
> -- Jackie Hamilton 
> kira at lightsphere.com
> _______________________________________________
> 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
> 

--