Opened 4 years ago

Closed 2 years ago

#9296 closed enhancement (duplicate)

Please, consider following patch for Trac 0.12

Reported by: abondar@… Owned by: rjollos
Priority: normal Component: TracTicketStatsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12


It optimizes SQL requests

Attachments (1) (3.2 KB) - added by anonymous 4 years ago.

Download all attachments as: .zip

Change History (2)

Changed 4 years ago by anonymous

comment:1 Changed 2 years ago by rjollos

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

We do need to optimize the queries, however I'm not sure that your patch gets it quite right. Your patch appears to query the database and retrieve the current status of each ticket, only putting restrictions on the creation time. Rather, we need to look at the ticket_change table to determine the number of opened and closed tickets on a particular date.

I will close this as a duplicate of #7001 and commit a patch against that ticket. Please track the changes and test if you are able.

Add Comment

Modify Ticket

as closed The owner will remain rjollos.
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.