Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > ORM Profiler> Duration
 

Pages: 1
ORM Profiler
Duration
Page:1/1 

  Print all messages in this thread  
Poster Message
arschr
User



Location:
Atlanta, Georgia; USA
Joined on:
14-Dec-2003 16:57:29
Posted:
876 posts
# Posted on: 12-Dec-2018 19:42:16. Goto attachments  
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.

- Al  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14470 posts
# 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


  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.