Modify

Opened 5 years ago

Last modified 17 months ago

#7001 new enhancement

Optimize SQL queries

Reported by: austin Owned by: rjollos
Priority: normal Component: TracTicketStatsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

The plugin is very useful. Thanks a bunch for that.

I've noticed the plugin queries database twice for the same dataset. Also the queries return large number of data elements. These slow down significantly in a system with lots of tickets.

Attached here is my modified ticketstat.py to speed things up. It only queries the dataset onc with and smaller dataset using SQL filer.

Attachments (1)

th7001.diff (8.4 KB) - added by rjollos 4 years ago.

Download all attachments as: .zip

Change History (10)

comment:1 Changed 4 years ago by rjollos

  • Summary changed from A few speed improvments to [Patch] A few speed improvments

It is always preferred to submit patches so the author can easily see what changes were made.

comment:2 Changed 4 years ago by rjollos

  • Owner changed from echo0101 to rjollos

Reassigning ticket to new maintainer.

Changed 4 years ago by rjollos

comment:3 Changed 4 years ago by rjollos

Removed original attachment and attached a unified diff of the changes.

comment:4 Changed 2 years ago by rjollos

  • Summary changed from [Patch] A few speed improvments to [Patch] A few speed improvements

comment:5 Changed 18 months ago by rjollos

  • Status changed from new to assigned

#9296 closed as a duplicate.

comment:6 Changed 18 months ago by rjollos

#3421 closed as a possible duplicate.

comment:7 Changed 18 months ago by rjollos

  • Summary changed from [Patch] A few speed improvements to Optimize SQL queries

comment:8 Changed 18 months ago by rjollos

(In [13107]) Refs #8703, #7001: Optimize SQL queries and properly utilize the Trac database API to prevent SQL injection and improve cross-DB compatibility.

comment:9 Changed 17 months ago by rjollos

  • Status changed from assigned to new

Add Comment

Modify Ticket

Action
as new The owner will remain rjollos.
Author


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

 
Note: See TracTickets for help on using tickets.