1 Replies Last post: May 20, 2014 5:12 PM by Asia Rudenko  
Dexter V Newbie 1 posts since
Apr 26, 2014
Currently Being Moderated

Apr 26, 2014 10:41 PM

C# application profiling gives different results

Hi,

 

I'm new to profiling and dottrace profiler. I'm trying to profile a C# application which connects to an SQLite database and retrieve data. The database contains 146856400 rows and the select query retrieves 428800 rows after execution.

 

On the first execution the main thread takes 246686 ms

1st execution result.png

On second execution of the same code the main thread takes only 4296 ms

 

2nd execution result.png

 

 

After restarting the system

 

On the first execution the main thread takes 244533 ms

On the second execution of the same code the main thread takes only 4053 ms

 

 

Questions:

 

1) Why is there a hugh difference between the first execution timing and the second execution timing

2) After restarting the system why I'm not getting the same results.

 

Pls help

Asia Rudenko JetBrains 124 posts since
Nov 11, 2010
Currently Being Moderated
May 20, 2014 5:12 PM in response to: Dexter V
Re: C# application profiling gives different results

Hello Dexter,

I'm terribly sorry for such delay with the answer, I must have missed the notification about a new post. Are the scenarios the same in the both cases?

More Like This

  • Retrieving data ...