displayRuntime
You are looking at an older version of the documentation. The latest version is found here.
This procedure provides debug logging and estimated duration for a particular block of code. It accepts two mandatory timestamp parameters: the start of the whole execution and the start of the particular block. This allows to estimate how much time has passed since both timestamps. Additionally, the procedure returns the current timestamp for use in subsequent calls.
Parameters
Parameter | Description |
---|---|
startTime | Start timestamp of the whole process execution; mandatory |
blockStartTime | Start timestamp of the block; mandatory |
context | Logging context to be appended to com.datavirtuality.connectors |
procedureName | Procedure name to identify the full procedure (default: the code) |
text | Text to identify the small data block (default: the block) |
Attributes
Attribute | Type | Description |
---|---|---|
| timestamp | Current timestamp (moment the procedure started) |
Example
DECLARE timestamp currentTime = ...
...
currentTime = SELECT currentTime FROM UTILS.displayRuntime (
startTime => startTime,
blockStartTime => currentTime,
context => 'api.section.particularItems',
procedureName => 'getApiSectionParticularItems',
text => 'Starting data parsing...'
);