Modify

Opened 7 years ago

Closed 7 years ago

#2237 closed defect (wontfix)

Reports execute very slowly with plugin enabled

Reported by: cpeters@… Owned by: coderanger
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 7 years ago by coderanger

  • Resolution set to wontfix
  • Status changed from new to closed

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.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.