Optimize SQL queries
|Reported by:||austin||Owned by:||rjollos|
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.
Change History (10)
comment:1 Changed 4 years ago by rjollos
- Summary changed from A few speed improvments to [Patch] A few speed improvments
Changed 4 years ago by rjollos
comment:4 Changed 2 years ago by rjollos
- Summary changed from [Patch] A few speed improvments to [Patch] A few speed improvements
comment:7 Changed 18 months ago by rjollos
- Summary changed from [Patch] A few speed improvements to Optimize SQL queries