Jeremy_Clere_7804

Trace and DB performance

Discussion created by Jeremy_Clere_7804 on Sep 29, 2017
In the traces you can find the following information:


20170929/143411.997 - UCUDB32 SLCU RET 0000 HSTMT: 000000001CD81A10 VALUE: 000000001CD81A10 ALL:  0.00642 DB:  0.00576 ODBC:  0.00006 UDB:  0.00060


It can be seen that the SELECT (SLCU) request lasted 0.006 seconds (ALL: 0.00642).

We can then have an idea of the performances by comparing with the table below:
 > 0.2 seconds Review
> 0.05 seconds To be improved
> 0.02 seconds OK
<0.02 seconds Perfect

Outcomes