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

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

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

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

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

Top

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

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

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

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

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

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-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       13.04.2026 10:22:57