Inheritance diagram for SQLBenchMarkQueries:

[legend]

Collaboration diagram for SQLBenchMarkQueries:

[legend]

Static Public Member Functions
_.Library.String	Parse (sql)
	<style type="text/css"> DEP { color: red; font-weight: bold; } BC { color: green; font-weight: bold; } PROP { display: block; white-space: pre; font-size: 16px; font-family: monospace; } STUB { color: DarkGoldenRod ; } IMP { color: red; font-style: italic; } .dep-head { color: red; white-space: pre; font-family: 'Courier New'; } .section-head { color: blue; white-space: pre; font-family: 'Courier New'; } .info-head { white-space: pre; font-family: 'Courier New'; } </style> More...

_.Library.Status	Purge (_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearErrs, _.Library.Integer returnType, _.Library.RawString ptInfo)
	This method is called to remove SQL Benchmark Stats data from the following. More...

_.Library.Status	Run (_.Library.String NameSpace, _.Library.Integer Display)

	TriggerOnDelete (timing)
	Perform the OnDelete Trigger operations for this class...

_.Library.Status	clearSQLBenchMarkQry (_.Library.String ns, _.Library.String rtn, _.Library.Integer ph3, _.Library.Integer clearErrs, _.Library.Integer returnType, _.Library.RawString ptInfo)

Public Attributes
	JobNumber
	More...

	NameSpace
	More...

	PValues
	More...

	QueryText
	More...

	RunTime
	More...

	SQLIndexHash
	Internal unique statement hash used as the ID for the SQL Statement Index (DPV4651): More...

Detailed Description

This Class gets populated from the <method>SYS.PTools.SQLStats.startSQLStats()</method> method when gathering stats is turned on. There is more info on how to run Stats in <class>SYS.PTools.SQLStats</class>.

The class contains the SQLText, the Job Number, the Time Stamp from when the query was run, the SQLIndexHash, which is a unique ID for the SQL Statement Index, and the Parameters that were used.

The Method <method>Run</method> will loop over all the saved queries and execute them one after the other.

Because ^SYS.PTools.BenchMarkResults stores data in the "IRISLOCALDATA" database you need to have All to execute the Run() method.

Member Function Documentation

◆ Parse()

_.Library.String Parse ( sql )

static

This Class gets populated from the <method>SYS.PTools.SQLStats.startSQLStats()</method> method when gathering stats is turned on. There is more info on how to run Stats in <class>SYS.PTools.SQLStats</class>.

The class contains the SQLText, the Job Number, the Time Stamp from when the query was run, the SQLIndexHash, which is a unique ID for the SQL Statement Index, and the Parameters that were used.

The Method <method>Run</method> will loop over all the saved queries and execute them one after the other.

Because ^SYS.PTools.BenchMarkResults stores data in the "IRISLOCALDATA" database you need to have All to execute the Run() method.

◆ Purge()

_.Library.Status Purge	(	_.Library.String	ns,
		_.Library.String	rtn,
		_.Library.Integer	ph3,
		_.Library.Integer	clearErrs,
		_.Library.Integer	returnType,
		_.Library.RawString	ptInfo
	)

static

This method is called to remove SQL Benchmark Stats data from the following.

two classes:

<class>SYS.PTools.SQLBenchMarkQueries</class>
<class>SYS.PTools.SQLBenchMarkResults</class>

Backward-compatible Entry Point: NOTE: For additional details, see the following methods in their respective aforementioned classes:

<method>clearSQLBenchMarkQry</method>
<method>clearSQLBenchMarkRslt</method>

◆ Run()

_.Library.Status Run	(	_.Library.String	NameSpace,
		_.Library.Integer	Display
	)

static

This is a simple example of what can be done with the data stored in this table.

This methods take 2 parameters:

NameSpace - the NameSpace where you want to run the Benchmark
Display - 1 or 0 to control output to the screen

This method will loop over the queries that are stored in this classes and execute them as Dynamic SQL statements SQLStats is turned off for this run and the state is returned when the code finishes The code will display and save data for fetching the first row and for fetching all the rows The data saved will be: Global Refs, Lines of Code, Rows Returned, and Total Time. All the results are stored in the <class>SYS.SQLBenchMarkResults</class> class.

◆ clearSQLBenchMarkQry()

_.Library.Status clearSQLBenchMarkQry	(	_.Library.String	ns,
		_.Library.String	rtn,
		_.Library.Integer	ph3,
		_.Library.Integer	clearErrs,
		_.Library.Integer	returnType,
		_.Library.RawString	ptInfo
	)

static

<DEP> – DEPRECATED — DEPRECATED — DEPRECATED — DEPRECATED — DEPRECATED – </DEP>

Method: clearSQLBenchMarkQry [SQL: PT_clearSQLBenchMarkQry] Replaced BY: N/A Status: New Functionality Purpose: Delete all of the data stored in the 'SYS.PTools.SQLBenchMarkQueries' class, based on the specified parameters...

Invocation: This method can be invoked in the following ways: ObjectScript: ##class(SYS.PTools.SQLBenchMarkQueries).clearSQLBenchMarkQry(...) SQL: CALL SYS_PTools.PT_clearSQLBenchMarkQry(...) SELECT SYS_PTools.PT_clearSQLBenchMarkQry(...)

NOTE: This 'SqlProc' method can be invoked with either the CALL-interface or the SELECT-interface. Both interfaces execute the method: the CALL-interface does not return any resulting value, while the SELECT-interface does.

Examples: The following examples shows the use of this method:

#1 Delete all of the data stored in the 'SYS.PTools.SQLBenchMarkQueries' class in the 'SAMPLES' namespace:

set stats=##class(SYS.PTools.SQLBenchMarkQueries).clearSQLBenchMarkQry("SAMPLES")

Data Storage: ^sqlcq($NAMESPACE,"PTools","Bench","Queries","{D|I|C|S}")

Parameters: ns - The namespace in which to clear SQL Statistics If none provided, use the current namespaces where SQL Stats collected [DEFAULT: Current Namespace] rtn - The routine for which to clear SQL Statistics If none provided, clear all routines in the given 'ns' [OPTIONAL] ph3 - Placeholder Parameter for future extensibility clearAll - 0 = Perform a normal clear, but leave the 'INFO' rows 1 = Clear everything including the 'INFO' rows [DEFAULT: 0] clearErrs - 0 = Don't delete the 'PTools' Application Errors 1 = Delete all of the 'PTools' Application Errors [DEFAULT: 0] returnType - 0 = Return a Status code of either $$$OK or $$$ERROR() 1 = Return the number of Stats rows deleted from the following class: SYS.PTools.SQLBenchMarkQueries [DEFAULT: 0] ptInfo - A Pass By Reference information array that returns detailed information to the user in the following format: ptInfo(category,variable)=value OR $LB(val1,...,valn) Where category = { "cnt" | "curr" | "term" | ... } variable = A var corresponding to the given 'category'

Example: ptInfo("cnt","clearSQLBenchMarkQry")=The number of rows deleted via this method [Routine Method]

RETURN Value: Based on the value of the 'returnType' parameter, return one of the following: 0: Return a Status code of either $$$OK or $$$ERROR()

1: Return the number of Stats rows deleted from the following class; Otherwise, return an error message if an error occurred: SYS.PTools.SQLBenchMarkQueries

Member Data Documentation

◆ JobNumber

JobNumber

◆ NameSpace

NameSpace

◆ PValues

PValues

◆ QueryText

QueryText

◆ RunTime

RunTime

◆ SQLIndexHash

SQLIndexHash

Internal unique statement hash used as the ID for the SQL Statement Index (DPV4651):

^rINDEXSQL("sqlidx",1,{SQLIndexHash},...) ^rINDEXSQL("sqlidx",2,{rtn},{SQLIndexHash}) ^rINDEXSQL("sqlidx",3,{table},{SQLIndexHash}) For additional details, refer to the following: http://twiki.iscinternal.com/twiki/bin/view/ISC/SQL20Statement20Indexing Also, refer to the following methods in the <rtn>SYS.SQLSRVR.MAC<rtn> routine:

SaveSQLIndex(...) - UnfreezePlan(...) - FreezePlanSchema(...) - CleanSQLIndex(...)
SaveSQLIndexImport(...) - FreezePlan(...) - FreezePlanRelation(...) - ...
UpdateSQLIndex(...) - FreezePlanAll(...) - DeleteSQLIndex(...)

Static Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

◆ Parse()

◆ Purge()

◆ Run()

◆ clearSQLBenchMarkQry()

Member Data Documentation

◆ JobNumber

◆ NameSpace

◆ PValues

◆ QueryText

◆ RunTime

◆ SQLIndexHash