Home > Class Reference > ENSLIB namespace > %CSP.Util.Performance
Private   Storage    

%CSP.Util.Performance

persistent class %CSP.Util.Performance extends %Persistent

This class is designed to map an existing global named ^["%SYS"]ISCcspPerformance which contains data about the CSP/ZEN Performance as long as the PAGETIMING parameter is set to 1 in the page. It contais data about each time a CSP/ZEN page is executed: Day, Time Slot, Hits, Global References, Lines Executed, and Maximum, Minimum and Total Execution Time. This class will allow SQL access to the data. Some sample queries are provided. One step further will be DeepSee enable it, to be able to use DeepSee against this data.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
12 2 1

Summary

Properties
Day Event Globals GlobalsPerHit Hits
Lines LinesPerHit MaxTime MinTime Page
Slot TotalTime
Methods
%AddToSaveSet %AddToSyncSet %CheckConstraints %CheckConstraintsForExtent
%ClassIsLatestVersion %ClassName %ComposeOid %ConstructClone
%Delete %DeleteExtent %DeleteId %DispatchClassMethod
%DispatchGetModified %DispatchGetProperty %DispatchMethod %DispatchSetModified
%DispatchSetMultidimProperty %DispatchSetProperty %Exists %ExistsId
%Extends %GUID %GUIDSet %GetLock
%GetParameter %GetSwizzleObject %Id %IsA
%IsModified %IsNull %KillExtent %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PurgeIndices %Reload %RemoveFromSaveSet %ResolveConcurrencyConflict
%RollBack %Save %SaveDirect %SerializeObject
%SetModified %SortBegin %SortEnd %SyncObjectIn
%SyncTransport %UnlockExtent %UnlockId %ValidateIndices
%ValidateObject

Properties

property Day as %String(TRUNCATE=1);
Date in YYYY-MM-DD format
property Event as %String(TRUNCATE=1);
Indicates the type of the event (currently there is only one event named 'Page')
property Globals as %Numeric(SCALE=0);
Number of global references (read/write)
property GlobalsPerHit as %Integer [ Calculated ];
property Hits as %Numeric(SCALE=0);
Number of times the page was executed
property Lines as %Numeric(SCALE=0);
Number of lines of COS code executed
property LinesPerHit as %Integer [ Calculated ];
property MaxTime as %Numeric(SCALE=6);
Maximum Page execution time
property MinTime as %Numeric(SCALE=6);
Minimum Page execution time
property Page as %String(MAXLEN=256,TRUNCATE=1);
The full CSP page name, includes the application name
property Slot as %Integer;
The particular Slot within the Day the hit occured The total number of Time Slots in a day is defined in the page with the TIMINGSLOTS parameter
property TotalTime as %Numeric(SCALE=6);
Total acumulated Page execution time

Queries

query PageAndDay(Page As %String, Day As %String = ""_$zdate($h, 3))
SQL Query :
SELECT Hits,Globals,GlobalsPerHit,Lines,LinesPerHit,MaxTime,MinTime,TotalTime,Page,Day,Slot

FROM %CSP_Util.Performance

WHERE (Page = :Page AND Day = :Day)

ORDER BY Slot
query Top10Pages(from As %String, until As %String)
SQL Query :
SELECT TOP 10 Page, Hits

FROM %CSP_Util.Performance

WHERE Day BETWEEN :from AND :until

GROUP BY Page

ORDER BY Hits DESC
top pages in number of Hits in a period of time

Indices

•index (IdKeyIdx on Event,Page,Day,Slot) [IdKey,Unique];