Difference between revisions of "PROFILE"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Class== | ==Class== | ||
| − | + | Performance and Optimization | |
==Purpose== | ==Purpose== | ||
| − | + | Enable profiling for a command or program | |
| Line 18: | Line 16: | ||
==Description== | ==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. | ||
| Line 24: | Line 28: | ||
<code lang="recital"> | <code lang="recital"> | ||
profile do myapp | profile do myapp | ||
| + | |||
| + | // Another example | ||
| + | profile replace expiry with start_date + 30 | ||
</code> | </code> | ||
| + | |||
==Products== | ==Products== | ||
| + | Recital Database Server, Recital Mirage Server, Recital Terminal Developer | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| + | [[Category:Set_Commands|PROFILE]] | ||
| + | [[Category:Performance and Optimization]] | ||
| + | [[Category:Performance and Optimization Commands]] | ||
Revision as of 11:19, 25 June 2009
Class
Performance and Optimization
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 Database Server, Recital Mirage Server, Recital Terminal Developer
