[PATCH] performance issues
|Reported by:||Shane Caraveo||Owned by:||Steffen Hoffmann|
|Cc:||andref.dias@…, Michael Renzmann, Ryan J Ollos, Odd Simon Simonsen||Trac Release:||0.11|
The tags plugin is excellent, however, there are some pretty big performance issues.
One is, regardless of specifying a realm (via tags search page or a macro), all tag providers are asked for their tags, and only after that is the realm checked.
The second is checking permissions on each ticket (in the ticket provider). This is fine if you have a few hundred (or thousand) tickets. In a database with a couple hundred thousand tickets, the tags plugin becomes unusable. Relying on a ticket_view and tags_view at a "global" level is sufficient for the majority of cases.
The attached patch addresses both issues above, though I don't regard it as a "final" patch.
Change History (34)
comment:1 Changed 8 years ago by
|Cc:||andref.dias@… added; anonymous removed|
|Type:||defect → enhancement|
comment:7 Changed 5 years ago by
|Cc:||Michael Renzmann added|
|Owner:||changed from Michael Renzmann to Steffen Hoffmann|
|Status:||assigned → new|