Namespace: Consultingwerk.OERA.TempTableStatistics
Class 
TempTableStats Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.OERA.TempTableStatistics.TempTableStats

Inherits: Progress.Lang.Object

File:TempTableStats
Purpose:Aggregates Temp-Table Statistics
Author(s):Mike Fechner / Consultingwerk Ltd.
Created:Tue Mar 05 21:53:14 CEST 2022

Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
# GetArchivedTTList (TempTableSummary) Builds the list of archived temp-tables
+ Consultingwerk.OERA.TempTableStatistics.TempTableSummary GetStatistics (logical, table) Returns the temp-table statistics
+ Consultingwerk.OERA.TempTableStatistics.TempTableSummary GetStatistics (logical, table) Returns the temp-table statistics
# GetTtIdxCRUD () Computes the CRUD statistics of the temp-table's indexes
# GetTtIdxList (TempTableSummary) Builds the list of indexes of active temp-tables
# GetTtInfo (TempTableSummary) Computes the temp-table summary data
# GetTtTblCRUD (TempTableSummary, logical) Computes the CRUD statistics of the temp-tables
# GetTtTblList (TempTableSummary) Builds the list of active temp-tables
# TtAnalys (integer) Calculates the number of records and size in every temp-table


Method Detail
Top

PROTECTED GetArchivedTTList (TempTableSummary)
Purpose: Builds the list of archived temp-tables
Notes:

Parameters:
poTempTableSummary Consultingwerk.OERA.TempTableStatistics.TempTableSummary
The TempTableSummary instance with the summary data
Top

PUBLIC Consultingwerk.OERA.TempTableStatistics.TempTableSummary GetStatistics (logical, table)
Purpose: Returns the temp-table statistics
Notes: The variant computes the delta activity of the temp-tables since
the last call into GetStatistics

Parameters:
plCountRecords LOGICAL
Logical value indicating if records should be counted
ttTtInfo TEMP-TABLE ttTtInfo
INPUT-OUTPUT The temp-table with the per temp-table statistics
Returns Consultingwerk.OERA.TempTableStatistics.TempTableSummary
The temp-table statistics summary
Top

PUBLIC Consultingwerk.OERA.TempTableStatistics.TempTableSummary GetStatistics (logical, table)
Purpose: Returns the temp-table statistics
Notes:

Parameters:
plCountRecords LOGICAL
Logical value indicating if records should be counted
ttTtInfo TEMP-TABLE ttTtInfo
INPUT-OUTPUT The temp-table with the per temp-table statistics
Returns Consultingwerk.OERA.TempTableStatistics.TempTableSummary
The temp-table statistics summary
Top

PROTECTED GetTtIdxCRUD ()
Purpose: Computes the CRUD statistics of the temp-table's indexes
Notes:

Top

PROTECTED GetTtIdxList (TempTableSummary)
Purpose: Builds the list of indexes of active temp-tables
Notes:

Parameters:
poTempTableSummary Consultingwerk.OERA.TempTableStatistics.TempTableSummary
The TempTableSummary instance with the summary data
Top

PROTECTED GetTtInfo (TempTableSummary)
Purpose: Computes the temp-table summary data
Notes:

Parameters:
poTempTableSummary Consultingwerk.OERA.TempTableStatistics.TempTableSummary
The TempTableSummary instance with the summary data
Top

PROTECTED GetTtTblCRUD (TempTableSummary, logical)
Purpose: Computes the CRUD statistics of the temp-tables
Notes:

Parameters:
poTempTableSummary Consultingwerk.OERA.TempTableStatistics.TempTableSummary
The TempTableSummary instance with the summary data
plCountRecords LOGICAL
Logical value indicating if records should be counted
Top

PROTECTED GetTtTblList (TempTableSummary)
Purpose: Builds the list of active temp-tables
Notes:

Parameters:
poTempTableSummary Consultingwerk.OERA.TempTableStatistics.TempTableSummary
The TempTableSummary instance with the summary data
Top

PROTECTED TtAnalys (integer)
Purpose: Calculates the number of records and size in every temp-table
Notes:

Parameters:
X INTEGER
The temp-table's statistics ID


Temp-Table Detail

Temp-Table ttTtInfo

Defined in:


©2006-2023 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       09.11.2024 18:38:54