Steps to Analyze Profiler Statistics

The profiler tab-delimited report format can contain a great deal of information. You can process this data in a spreadsheet, database, or user-written program.

To process the data in the tab-delimited report:

1. Collect the cumulative data from the global information records. These lines begin with the numbers 0 through 5. Each of these lines appears only once, and always in ascending order.
2. Determine the type of database by finding the value of the "Method" field. This field is the second field of record type 1.
3. If the value in the "Method" field is greater than 400, the report comes from function profiling. If it is less than 400, the report comes from line profiling. The type of information in the local information records given later is directly related to this value.
4. In any one report, the local information records are always of the same type, either line information or function information.
5. Process data from the local information records. For example, to calculate the percentage of hits on a given function, divide the value of the "Count" field in record type 6 by the total number of hits from the "Total Hits" field of record type 3.
6. Remember that there can be only one type of local information record (either line or function information) in a report.
7. Send the results to a file or STDOUT.