Real Time Information Director User Documentation

RTID Management

Hewlett-Packard Company 11 529618 - 001

</STATISTICS>

SQL Operations

The following XML tags can be present in summary or detailed statistics and represent

SQL operations:

• SELECT

• UPDATE

• INSERT

• DELETE

Any of these tags can have one or more attributes, depending on the statistics gathering

options you’ve specified. An attribute name is followed by an equals sign (=) and a value

enclosed in quotation marks (“”). The following attributes can be returned for SQL

operations:

• STATEMENTS. The number of prepared SQL statements used for this

operation, usually one statement per database table, per SQL operation required

for that table.

• ROWS. The number of rows affected by the operation.

• MILLISECONDS. The amount of time the operation took. This value will be

present only if you requested that operations be timed.

Statistics by Table

If you’ve requested statistics gathering by table, the statistics will include a separate

STATISTICS segment for each table, in addition to the summary STATISTICS segment.

The STATISTICS segment for a table includes the TABLE attribute, providing the table

name, and elements reflecting SQL operations performed on that table. Observe that, in

the example above, the summary statistics indicate that there were 34 INSERT

statements; the detailed statistics show how many of these applied to each table.

Operations History

If you’ve requested the tracing of operations history, an OPERATIONS segment will

occur within the STATISTICS XML segment. The operations history includes SQL

operations. It also includes other operations performed by the Director.

The following is an example of operation statistics, including timing information, for an

upsert document: