Skip to main content

%SYS.PTools.SQLBenchMarkResults

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

SQL Table Name: %SYS_PTools.SQLBenchMarkResults

Property Inventory

Properties

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()
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()

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

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
FeedbackOpens in a new tab