Is there any way to get the break of the report execution time.
I mean to see how much time it took in DB to fetch the data and the time to display.
For e.g total execution time is 1 min ( 40 secs in DB & 20 secs in congos to format and display).
Thanks in advance.
Pinned topic How to get the break of the report execution time
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-31T14:44:41Z at 2013-01-31T14:44:41Z by DanielWagemann
DanielWagemann 2700058MAJ850 Posts
Re: How to get the break of the report execution time2013-01-31T14:44:41ZThis is the accepted answer. This is the accepted answer.There is a Perf.QFS trace that is covered in the following training course:
If you cannot take that, you will need schedule the report to completion to get the entire execution time, and in parallel trace the incoming query to the database.
TotalReportExecution-timeondatabase would give you the time the report takes to do its local processing and rendering. This would not cover any request transport time. (Time between dispatchers etc.)