[PATCH] performance issues
|Reported by:||mixedpuppy||Owned by:||hasienda|
|Cc:||andref.dias@…, otaku42, rjollos, osimons||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)
Changed 6 years ago by mixedpuppy
comment:1 Changed 6 years ago by andref.dias@…
- Cc andref.dias@… added
- Type changed from defect to enhancement
Changed 5 years ago by otaku42
comment:7 Changed 3 years ago by hasienda
- Cc otaku42 added
- Owner changed from otaku42 to hasienda
- Status changed from assigned to new
comment:27 Changed 5 months ago by hasienda
- Resolution set to fixed
- Status changed from assigned to closed