Modify

Opened 10 years ago

Closed 10 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)

Change History (1)

comment:1 Changed 10 years ago by Noah Kantrowitz

Resolution: wontfix
Status: newclosed

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Noah Kantrowitz.
The resolution will be deleted.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.