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 owner will remain coderanger.
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.