Modify ↓
Opened 17 years ago
Closed 17 years ago
#2237 closed defect (wontfix)
Reports execute very slowly with plugin enabled
Reported by: | Collin Peters | Owned by: | Noah Kantrowitz |
---|---|---|---|
Priority: | high | Component: | PrivateTicketsPlugin |
Severity: | critical | Keywords: | |
Cc: | Trac Release: | 0.10 |
Description
When I login with a user with the TICKET_VIEW_GROUP permission, and try to view any of the standard reports, it takes a good 20+ seconds before results are returned. The results are correct. Both the apache and postgresql processes are at full CPU when this is happening.
Can I get some feedback on why this is happening? PostgreSQL issue? Code issue?
Attachments (0)
Note: See
TracTickets for help on using
tickets.
Given that every ticket returned in the report has to be checked (which is a good bit of CPU time and possibly a few DB queries) this is just a natural consequence. Make your reports return fewer tickets and it should be less of an issue.