Optimize SQL queries
|Reported by:||austin||Owned by:|
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 (11)
comment:4 Changed 4 years ago by
|Summary:||[Patch] A few speed improvments → [Patch] A few speed improvements|