Back to Ideas
9
Like
Follow Idea
2016-11-21 23-23-05
Gonçalo Borrêga
Analytics: Report on highly used queries/actions
1235Views
2Comments
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)

13 May 2010
Copy link to comment
2016-11-21 23-23-05
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
13 May 2010
Copy link to comment
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.

12 Apr 2018
Copy link to comment