Opened 17 years ago
Last modified 7 months ago
#4245 new defect
[PATCH] Tickets are slow with large amount of users and permissions — at Initial Version
| Reported by: | Owned by: | Jonas Borgström | |
|---|---|---|---|
| Priority: | high | Milestone: | next-stable-1.6.x |
| Component: | general | Version: | devel |
| Severity: | major | Keywords: | patch performance slow restrict_owner get_users_with_permission |
| Cc: | zach@…, leho@…, ismael@…, mmitar@…, osimons, peter@…, verm@…, dsd@…, Ryan J Ollos | Branch: | |
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
TicketSystem.get_ticket_fields() implements an exremely inefficient algorithm to find users that have a certain permission (O(n2users * perms_per_useravg)). I have added a more efficient function to PermissionSystem that enables querying users having a specified permission directly. It correctly resolves group memberships and hierarchical permissions.
Note:
See TracTickets
for help on using tickets.
Patch