Lesson 3: Comparing the procedure profiling results

To compare the procedure profiling results

  1. In Sybase Central, choose Mode » Application Profiling.

    If the Application Profiling Wizard appears, click Cancel.

  2. In the left pane of Sybase Central, in Procedures & Functions, click the baseline procedure.

  3. In the right pane, click the Profiling Results tab.

  4. Choose View » Refresh Folder.

    Two new columns, Execs. +/- and ms. +/-, appear.

For each line in the procedure, the profiling results show the number of executions, the number of executions relative to the baseline procedure, the duration of execution, the duration of execution relative to the baseline procedure, and the percentage of total time the line took to execute.

The Execs. +/- and ms. +/- columns result from comparing statistics in the profiling log file to the statistics captured during the most recent execution of the procedure. Specifically, they compare number of executions and duration of execution, respectively, for each line of code in the procedure.

Typically, you are interested in the ms. +/- column, which indicates whether you improved the execution time for lines of code in the procedure. Faster times are indicated by a minus sign and red font. Slower times are indicated by no sign, and green font. In this tutorial, the value in the ms. +/- column should be a + sign along with a execution time in green font. The INSERT statement in the updated procedure has a slower time than the INSERT statement in the baseline procedure.

See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1