On Jan 18, 2017 4:06 PM, "Skarbek, John" <[email protected]> wrote:
Good Morning, I was spying on my logs and something out of the ordinary popped out at me. We are getting a status code of -1. This (-1) is the marker for a null/nil/NaN/non-existent/inapplicable values. The associated timer is not applicable to this request because of the session state at disconnect (CD). It would be improper to log these as 0 since "0 milliseconds elapsed" is not actually true. If you were loading the logs into a database for analyis, you'd actually store a -1 from the log as NULL in the database so that aggregate functions like AVG() and COUNT() will correctly exclude them. In SQL, the AVG() of (5, NULL, 10) is actually 7.5... while the average of (5, 0, 10) is of course 5... so you can perhaps see the importance of having a distinct marker for absent values.
