Databases
StackOverflow2013
Postsdbo
POdotTrace and performance profiling?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POdotTrace and performance profiling?
    primarykey
    data
    text
    <p>I recently re-wrote my file format writing library. I realized my code was messy, made everything way too complicated, and was generally just hard to keep maintained.</p> <p>So my new library is so much more organized and clean. I realized that many of the ways I accomplished tasks in the old library was WAY more complicated than it needed to be, so I expected my new code to be ALOT faster.</p> <p>Well, not exactly. I tested performance at first by using the Stopwatch class in the .Net framework. My old library was consistently faster, which shocked me, since there were too many improvements and optimizations to count.</p> <p>I then tested both using the dotTrace Performance Profiler. As expected, my NEW library was faster - about 2 <strong>times</strong> faster! My old library measured 62 milliseconds, and my new one measured 28 milliseconds!</p> <p>So I'm not sure what is going on. In Visual Studio my new library is much slower - in fact, it is VERY inconsistent, it will range from a time of 00::00::00.042 to 00::00::00.351!!</p> <p>Does anyone know why this may be happening? dotTrace says it's 2 times faster, the Stopwatch says it is 2-4 times slower.</p> <p>Thanks to everyone for your help.</p> <ul> <li>Alex</li> </ul> <p>EDIT:</p> <p>The code is the same for both libraries, both just reference the new and old library. This was tested on a Console application:</p> <pre><code>class Program { static void Main(string[] args) { Stopwatch sw = new Stopwatch(); sw.Start(); Textstring txt = new Textstring("TestText"); txt.Text = "This is a test textstring."; RdwFile f = new RdwFile("Test"); f.Add(txt); f.Save(); sw.Stop(); Console.WriteLine(sw.Elapsed.ToString()); Console.ReadKey(); } }; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlex
    1. USAlex
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COWe need to see how to used Stopwatch. For example, did you run it first so it was properly JITed, then time a second run? I don't know if dotTrace measures JIT time. I would think it doesn't.
      singulars
      1. POdotTrace and performance profiling?
      1. USvcsjones
    2. COYou can't get good results with such short tests. Write a test that exercises your code many times and runs for several seconds and compare.
      singulars
      1. POdotTrace and performance profiling?
      1. USTJD
    3. COI ran each test 20 times, for both the Stopwatch method and dotTrace profiler. The old library measured an average of 00::00::00.034 for the Stopwatch and an average of 63 for dotTrace (Profile type: Sampling, Measure: Thread). My new library measured an average of 00::00::00.08, but it really did range from 00::00::00.04 to 00::00::00.3 for the Stopwatch. It measured an average of 30 milliseconds in dotTrace.
      singulars
      1. POdotTrace and performance profiling?
      1. USAlex
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload