Posts: 893
Joined: 14-Dec-2003
# Posted on: 12-Dec-2018 19:42:16   

Is the duration column (see attached) calculating correctly or what goes into it besides db time and .net time?

I create an adapter, don't set keep open, use it to fetch a collection. It should then auto-close when done.

Filename File size Added on Approval
OrmProfilerV22018-12-12_13-05-02.png 26,093 12-Dec-2018 19:42.46 Approved
Walaa avatar
Support Team
Posts: 14848
Joined: 21-Aug-2005
# Posted on: 12-Dec-2018 20:20:27   

There can be a difference between the connection usage period duration time and the total DB times and .NET times. This is caused by the overhead inside the used ADO.NET provider to open / close a connection or commit a transaction, and overhead inside the used data-access system due to code executed after a connection was opened and before it was closed.

ref: Duration Explained