This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %SYS.PTools.SQLBenchMarkResults

%SYS.PTools.SQLBenchMarkResults

persistent class %SYS.PTools.SQLBenchMarkResults extends %Library.Persistent

SQL Table Name: %SYS_PTools.SQLBenchMarkResults

Property Inventory (Including Private)

Properties (Including Private)

property FRGlobalRefs as %Integer;
Number of Global References to fetch the first row
Property methods: FRGlobalRefsDisplayToLogical(), FRGlobalRefsGet(), FRGlobalRefsGetStored(), FRGlobalRefsIsValid(), FRGlobalRefsLogicalToDisplay(), FRGlobalRefsNormalize(), FRGlobalRefsSet()
property FRLines as %Integer;
Number of lines executed to fetch the first row
Property methods: FRLinesDisplayToLogical(), FRLinesGet(), FRLinesGetStored(), FRLinesIsValid(), FRLinesLogicalToDisplay(), FRLinesNormalize(), FRLinesSet()
property FRRunTime as %Time;
Time to fetch the first row
Property methods: FRRunTimeDisplayToLogical(), FRRunTimeGet(), FRRunTimeGetStored(), FRRunTimeIsValid(), FRRunTimeLogicalToDisplay(), FRRunTimeLogicalToOdbc(), FRRunTimeNormalize(), FRRunTimeOdbcToLogical(), FRRunTimeSet()
property GlobalRefs as %Integer;
Number of Global References for all rows
Property methods: GlobalRefsDisplayToLogical(), GlobalRefsGet(), GlobalRefsGetStored(), GlobalRefsIsValid(), GlobalRefsLogicalToDisplay(), GlobalRefsNormalize(), GlobalRefsSet()
property Lines as %Integer;
Number of lines executed for all rows
Property methods: LinesDisplayToLogical(), LinesGet(), LinesGetStored(), LinesIsValid(), LinesLogicalToDisplay(), LinesNormalize(), LinesSet()
property QueryId as %SYS.PTools.SQLBenchMarkQueries;
Property methods: QueryIdGet(), QueryIdGetObject(), QueryIdGetObjectId(), QueryIdGetStored(), QueryIdGetSwizzled(), QueryIdIsValid(), QueryIdNewObject(), QueryIdSet(), QueryIdSetObject(), QueryIdSetObjectId(), QueryIdUnSwizzle()
property Rowcount as %Integer;
Number of rows returned by the query
Property methods: RowcountDisplayToLogical(), RowcountGet(), RowcountGetStored(), RowcountIsValid(), RowcountLogicalToDisplay(), RowcountNormalize(), RowcountSet()
property Run as %Integer;
Property methods: RunDisplayToLogical(), RunGet(), RunGetStored(), RunIsValid(), RunLogicalToDisplay(), RunNormalize(), RunSet(), RunTimeDisplayToLogical(), RunTimeGet(), RunTimeGetStored(), RunTimeIsValid(), RunTimeLogicalToDisplay(), RunTimeLogicalToOdbc(), RunTimeNormalize(), RunTimeOdbcToLogical(), RunTimeSet()
property RunTime as %Time;
Time to fetch all rows
Property methods: RunTimeDisplayToLogical(), RunTimeGet(), RunTimeGetStored(), RunTimeIsValid(), RunTimeLogicalToDisplay(), RunTimeLogicalToOdbc(), RunTimeNormalize(), RunTimeOdbcToLogical(), RunTimeSet()
property StartTS as %TimeStamp;
Property methods: StartTSDisplayToLogical(), StartTSGet(), StartTSGetStored(), StartTSIsValid(), StartTSLogicalToDisplay(), StartTSNormalize(), StartTSOdbcToLogical(), StartTSSet()

Inherited Members

Inherited Methods (Including Private)

Storage

Storage Model: CacheStorage (%SYS.PTools.SQLBenchMarkResults)

^%sqlcq($NAMESPACE,"PTools","Bench","Results","D")(ID)
=
%%CLASSNAME
Run
StartTS
GlobalRefs
Lines
Rowcount
RunTime
QueryId
FRGlobalRefs
FRLines
FRRunTime