Modify ↓
      
        Opened 18 years ago
Closed 18 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.