Calculate Report Query execution time
Hi,
we are developing a report designing application for a client.and we have enabled server side printing for the web solution.Now customer needs to know report query execution elapsed time and printing elapsed time separately. i am trying to use
Report.prepare() method to calculate report query execution time and Report.Print() method to calculate the printing time. inside print method do u all have any query executions ? i need to calculate the values separately. what will be the best way of doing it ?
tnx in advanced
Chaminda
we are developing a report designing application for a client.and we have enabled server side printing for the web solution.Now customer needs to know report query execution elapsed time and printing elapsed time separately. i am trying to use
Report.prepare() method to calculate report query execution time and Report.Print() method to calculate the printing time. inside print method do u all have any query executions ? i need to calculate the values separately. what will be the best way of doing it ?
tnx in advanced
Chaminda
Comments
report.Prepare() method executes a query and builds the report. The report building phase may take longer time than executing a query (especially if you build a report with matrix object - 1000 rows query may generate 1000000 cells matrix). So you can't calculate query execution time precisely.
report.Print() method builds a report and prints it. You should probably use PrintPrepared() method instead of Print() - it just prints already prepared report. There is no queries executed at this phase, so the printing time may be calculated precisely.