Berkeley DB

Database Statistics

The DB→stat function is the standard interface for obtaining database statistics. Generally, DB→stat returns a set of statistics about the underlying database (for example, the number of key/data pairs in the database, how the database was originally configured, and so on).

There are two flags that you can set to customize the returned statistics:

• DB_CACHED_COUNTS Request an approximate key and key/data pair count. Because obtaining an exact count can be very performance-intensive for large databases, it is possible to request a previously cached count. Obviously, the cached count is only an approximate count, and it may be out-of-date.

• DB_RECORDCOUNT If the database is a Queue or Recno database, or a Btree database that ...