Edgewall Software

Opened 13 years ago

Last modified 20 months ago

#4245 new defect

[PATCH] Tickets are slow with large amount of users and permissions — at Initial Version

Reported by: ants.aasma@… Owned by: Jonas Borgström
Priority: high Milestone: next-stable-1.2.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:


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.

Change History (1)

by ants.aasma@…, 13 years ago


Note: See TracTickets for help on using tickets.