How to work with CSV exported results

Code profiling for .NET Developers

Moderators: Luke Jefferson, StephenC, Alex.Davies, AndrewH, melvyn.harbour, Laura Morley

How to work with CSV exported results

Postby ngajjar » Tue Jul 19, 2011 1:26 pm

When I export the results into CSV format, the content is not same as what is displayed in grid. I think it is throwing more function in CSV.

can someone explain the meaning of each column in CSV, for example what is CPU ticks and Wallclock ticks?

Thanks
-nilesh
ngajjar
 
Posts: 7
Joined: Tue Jul 19, 2011 1:09 pm

Postby Brian Donahue » Tue Jul 19, 2011 5:03 pm

You probably want to change the time to display in seconds or milliseconds rather than ticks. Ticks are measurements of time specific to the CPU as far as I know. If you go to "Milliseconds" on the "View" menu, the methods grid is shown as milliseconds and then you can export these results.

When you export, you are probably getting all methods in the file and not the "filtered" display you see on screen. By default you only see methods from your own source code. You can change the filter to "all methods" and the grid should match the CSV.

Wallclock is real time and CPU time is the amount of time the function actually spent running code and not waiting for IO or thread synchronization to complete.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby ngajjar » Tue Aug 02, 2011 11:00 am

Brian

Thanks for your reply.

You are right about second/milliseconds in view menu. It works fine on GUI however when we do the export some how Ants always export the results in one format. By format I mean the number of columns and unit value for the number, which is always in ms and ticks.

This is true for HTML or CSV export of Call Tree or Call Grid.

I do not see an option for sending an attachment in this forum, otherwise i would have sent the gui snapshot and csv/html file.

Thanks
-nilesh
ngajjar
 
Posts: 7
Joined: Tue Jul 19, 2011 1:09 pm

Postby Brian Donahue » Tue Aug 02, 2011 11:35 am

It seems to dump all possible formats. At least it's not leaving anything out. You can cut the columns you are not interested in when you load it into Excel.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to ANTS Performance Profiler 6

Who is online

Users browsing this forum: No registered users and 0 guests