Wrong time for queries into Performance Data in Servoy Admin

[dfernandez]

Hi,

Performance data shows 0 for Total Time and Avg Time for a Load Foundset query that took 16 seconds.

If you click on Avg Time to see the details, that query shows this:

Total Time Total (End-to-end) Time Count Avg Time Avg (End-to-end) Time Min Time Max Time Standard Deviation Standard Deviation/Average
00:00:000 00:16:031 1 00:00:000 00:16:031 00:16:031 00:16:031 0,0000 0,0000

All is in (mm:ss:ms)

Why if real time was 16 seconds, as showed in the detail, Total Time and Avg Time show 0?

Thanks

[rgansevles]

The sql is executed in a jdbc statement, this time is measured as total time.
Additionally, the time to fetch the data from the database to the application server is also measured, this is included in the end-to-end time.

Apperently, in this case, the driver does not really go to the data or take time when the statement is executed, but only when the data is fetched by Servoy.

Rob