Debugging values for min, max and avg do not seem to be consistent

Description

The debugging query that returns the executed pages contains 7 important columns:

  • count number of executions

  • min (the fastest execution of the template (if executed more than once, else equals to max))

  • max similar to the above

  • avg normally the average of the total execution time divided by the number of executions

  • load time to load/compile the template

  • query time taken for query operations

  • app CFML execution time
    The numbers do not add up properly. IMHO the following should apply
    avg = (app + load + query) / count
    min and max and avg should as well be equal if count = 1
    and min and max are actually just informative numbers

Environment

None

Activity

Pothys - MitrahSoft 
7 February 2017 at 06:00

I've analyzed this ticket a lot & confirmed that average value is not consistent. In lucee, While calculating average value it takes totaltime = applicationtime+querytime, It ignores Startup/Compilation time.
For example,
3.722 ms Application time
0.105 ms Startup/Compilation time
0.810 ms Query time
4.638 ms Total time

But while calculating average time, it takes.
Total time = 4.532 (excluding Startup/Compilation time)

I'm not sure whether this is an issue or not?

Please check & confirm this.

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Created 15 October 2015 at 13:40
Updated 19 May 2021 at 11:37