StatisticsUI provides the Query Statistics window, which contains statistics about the most recent fetch operation of the current query.
StatisticsUI provides the Query Statistics window, which contains statistics about the most recent fetch operation of the current query:
• the number of fetches performed
• the number of rows processed in the last fetch
• the number of columns in the returned data rows
• the number of rows allocated for the user buffer
• the number of rows used in the user buffer
• the number of bytes allocated for the user buffer
These values are obtained from the various fields of a output_statistics group in a DBquery module in the same application. DBquery, in turn, obtains the values for the output_statistics fields from the database-independent layer via the main communication area descriptor.
Note: This macro is intended as a template and, as a result, does not have input or output ports. The user is responsible for making the connections between this macro and the source of the data. To do this, the user must create the required input and output ports. See the Network Editor documentation in the AVS/Express User's Guide for details.
This window is used only by the Query macro.