Performance Statistics Interaction with Command Terminator Values

isql provides a performance statistics option (-p).

For example, this syntax returns the following statistics:

isql -p
1> select * from sysobjects
2> go

Execution Time (ms.): 1000   Clock Time (ms.): 1000
1 xact:

This means that a single transaction took 100 milliseconds. The clock time value reflects the entire transaction, which starts when Client-Library™ builds the query and ends when Client-Library returns the information from the SAP ASE server.

You can gather performance statistics based on the execution of one or more transactions. To gather statistics on more than one transaction, specify a number after the command terminator.

For example, the following command instructs the SAP ASE server to execute three select * transactions and report the performance statistics:

isql -p
1> select * from sysobjects
2> go 3

Execution Time (ms.): 1000   Clock Time (ms.): 1000
Execution Time (ms.): 1000   Clock Time (ms.): 2000
Execution Time (ms.): 1000   Clock Time (ms.): 1000

Execution Time (ms.): 1000   Clock Time (ms.): 4000
3xact: