Modify ↓
Opened 14 years ago
Last modified 8 years ago
#7001 new enhancement
Optimize SQL queries
Reported by: | austin | Owned by: | |
---|---|---|---|
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)
Change History (11)
comment:1 Changed 14 years ago by
Summary: | A few speed improvments → [Patch] A few speed improvments |
---|
comment:2 Changed 14 years ago by
Owner: | changed from Prentice Wongvibulsin to Ryan J Ollos |
---|
Reassigning ticket to new maintainer.
Changed 14 years ago by
Attachment: | th7001.diff added |
---|
comment:3 Changed 14 years ago by
Removed original attachment and attached a unified diff of the changes.
comment:4 Changed 12 years ago by
Summary: | [Patch] A few speed improvments → [Patch] A few speed improvements |
---|
comment:7 Changed 11 years ago by
Summary: | [Patch] A few speed improvements → Optimize SQL queries |
---|
comment:8 Changed 11 years ago by
comment:9 Changed 11 years ago by
Status: | assigned → new |
---|
comment:10 Changed 8 years ago by
Owner: | Ryan J Ollos deleted |
---|
Note: See
TracTickets for help on using
tickets.
It is always preferred to submit patches so the author can easily see what changes were made.