Article Details
Id:21126
Product:finPOWER Connect
Type:FIX
Version:4.01.00
Opened:29/01/2024
Closed:29/01/2024
Released:29/04/2024
Job: J032806
High Importance

Debug Window; "Duration" reported for SQL queries was vastly inflated when the Debug Window was open

The Debug Window, Debug Trace tag, shows the "Duration" in milliseconds that an SQL query took to run.

When the Debug Window was open, this value was being vastly inflated, e.g., a query that took 1ms might be recorded as 50ms.

This was because the grid was being refreshed before and after a query was executed, therefore the time it took the user interface to update was being included in the duration.

Having the Debug Window open now should have a minimal affect on the duration shown. Maybe 1 or 2 milliseconds.