Gonçalo Borrêga
Analytics: Report on highly used queries/actions
861
Views
2
Comments
Implemented
Lifetime

Create a report that shows how many times, per request, a query is done. The slow query report is a valuable one, but we could extend it to find those queries that do not take long to run (less than the 200ms range) but are executed several times per request (inside a foreach for instance)

Gonçalo Borrêga
Maybe even being able to state, per query or action, that metrics should be collected, and a report could be generated showing that that action/query, runs in average X times per request, with an average time of Y
Changed the status to
Implemented
on 07 May 2013

This is solved by LifeTime Analytics where the number of executions is correlated with the time a query takes to execute in the different requests.