Class Hierarchy    Previous  Next  Index

Class COM.cloudscape.vti.StatementDuration

java.lang.Object
    |
    +----COM.cloudscape.vti.VTITemplate
            |
            +----COM.cloudscape.vti.StatementDuration

public class StatementDuration
extends VTITemplate
Copyright © 1998-2000, Informix Software, Inc. All rights reserved.

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:


Constructor Index

 o StatementDuration()
StatementDuration() will access the cloudscape.LOG in cloudscape.system.home, if set, else in the current directory.
 o StatementDuration(String)
 

Method Index

 o close()
 
 o getMetaData()
 
 o getString(int)
All columns in StatementDuration VTI are of String type.
 o next()
 
 o wasNull()
 

Constructor Detail

 o StatementDuration
public StatementDuration()
          StatementDuration() will access the cloudscape.LOG in cloudscape.system.home, if set, else in the current directory. StatementDuration('filename') will access the specified file name.
 o StatementDuration
public StatementDuration(java.lang.String inputFileName)

Method Detail

 o getMetaData
public java.sql.ResultSetMetaData getMetaData()
See Also:
getMetaData
 o next
public boolean next() throws java.sql.SQLException
Throws:
java.sql.SQLException - Thrown on error.
See Also:
next
 o close
public void close()
See Also:
close
 o getString
public java.lang.String getString(int columnNumber) throws java.sql.SQLException
          All columns in StatementDuration VTI are of String type.
Throws:
java.sql.SQLException - Thrown on error.
Overrides:
getString in class VTITemplate
See Also:
getString
 o wasNull
public boolean wasNull()
Overrides:
wasNull in class VTITemplate
See Also:
wasNull

  Class Hierarchy    Previous  Next  Index