Difference between revisions of "PROFILE"

Revision as of 10:33, 17 November 2009

Purpose

Enable profiling for a command or program

Syntax

PROFILE <command>

See Also

CLEAR PROFILE, DEBUG, DISPLAY PROFILE, DO, LIST PROFILE, SET CLUSTERING, SET COMPILE, SET DCACHE, SET DEVELOPMENT, SET ICACHE, SET IOLOGGING, SET IOSTATS, SET LOCKTYPE, SET PROFILE, SET REPLICATION, SET SYSLOGGING

Description

The PROFILE command is used to invoke Recital's profiling functionality. Profiling produces input/output, locking and procedure call statistics for a particular application or part of an application. This information can be used for analysis to enable application optimization and general performance tuning. The profiling information can be output to the screen, a file or a printer using the LIST PROFILE and DISPLAY PROFILE commands.

<command>

The <command> can be a call to a User Defined Function (UDF) or a DO <program-name> to profile the entire UDF or program, or it can be used for any other single command or function.

The PROFILE command automatically lists the statistics to the screen. The SET PROFILE command can also be used to enable, disable and control profiling but requires the DISPLAY PROFILE or LIST PROFILE commands to output the logged statistics. Please see the LIST PROFILE command for details of the statistics included in the log. CLEAR PROFILE is used to reset the log.

Example

profile do myapp
 
// Another example
profile replace expiry with start_date + 30

Products

Recital, Recital Server