[rt-users] RT 3.6 performance problems

[Jackie Hamilton]

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