01.08.2019 16:45, Leyne, Sean wrote:

   Sean,

How can those stats be related to the *tables* on which the activity is 
performed against?

  Below is excerpt from APU Guide, if your question was about something else - 
please, clarify:

---
  Database operation counts

  Several information items are provided for determining the number of various 
database
operations performed by the currently attached calling program. These values are
calculated on a per-table basis.

  When any of these information items is requested, InterBase returns to the 
result buffer:
- 1 byte specifying the item type (for example, isc_info_insert_count).
- 2 bytes telling how many bytes compose the subsequent value pairs.
- A pair of values for each table in the database on which the requested type 
of operation
  has occurred since the database was last attached.

  Each pair consists of:
- 2 bytes specifying the table ID.
- 4 bytes listing the number of operations (for example, inserts) done on that 
table.

Tip
  To determine an actual table name from a table ID, query the system table, 
RDB$RELATION.
---

Regards,
Vlad

PS RDB$RELATIONS of course, IB6 docs contains a lot of errors :(


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to