How to work with CSV exported results

[ngajjar]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[ngajjar]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521