Class Hierarchy Previous Next Index
java.lang.Object | +----COM.cloudscape.vti.VTITemplate | +----COM.cloudscape.vti.StatementDuration
StatementDuration is a virtual table which, with limitations, can be used to analyze the execution duration of the statements of "interest" in cloudscape.log or the specified file when cloudscape.language.logStatementText=true.
The limitation is that, for each transaction id, a row will not be returned for the last statement with that transaction id. (Transaction ids change within a connection after a commit or rollback if the transaction that just ended modified data.)
The execution duration is really the time between the beginning of execution of 2 successive statements. There are a number of reasons why this time may not be accurate. The duration could include time spent in the application waiting for user input, doing other work, etc. It may also only include a portion of the actual execution time if the application executes a new statement before draining the previous open ResultSet. StatementDuration can be used to get a rough sense of where the bottlenecks in an application's jdbc code are.
The StatementDuration virtual table has the following columns:
public StatementDuration()
public StatementDuration(java.lang.String inputFileName)
public java.sql.ResultSetMetaData getMetaData()
public boolean next() throws java.sql.SQLException
public void close()
public java.lang.String getString(int columnNumber) throws java.sql.SQLException
public boolean wasNull()
Class Hierarchy Previous Next Index