Compare the procedure profiling results to determine if the updated procedure improved on execution times.
This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Baselining with procedure profiling.
This lesson assumes that you have completed all preceding lessons. See Lesson 1: Creating a baseline procedure.
In Sybase Central, click Mode » Application Profiling.
If the Application Profiling Wizard appears, click Cancel.
In the left pane of Sybase Central, in Procedures & Functions, click the baseline procedure.
In the right pane, click the Profiling Results tab.
Click View » Refresh Folder.
Two new columns, Execs. +/- and ms. +/-, appear.
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.
The ms. +/- column 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 a plus sign, and green font.
In this tutorial, the value in the ms. +/- column should be a plus sign along with an execution time in green font. The INSERT statement in the updated procedure has a slower time than the INSERT statement in the baseline procedure.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|