Red Gate forums :: View topic - How to work with CSV exported results
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
ANTS Performance Profiler 6
ANTS Performance Profiler 6 forum

How to work with CSV exported results

Search in ANTS Performance Profiler 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ngajjar



Joined: 19 Jul 2011
Posts: 7

PostPosted: Tue Jul 19, 2011 1:26 pm    Post subject: How to work with CSV exported results Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Tue Jul 19, 2011 5:03 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
ngajjar



Joined: 19 Jul 2011
Posts: 7

PostPosted: Tue Aug 02, 2011 11:00 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Tue Aug 02, 2011 11:35 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group