Berkeley DB

Logical Record Numbers

The Berkeley DB Btree, Queue, and Recno access methods can operate on logical record numbers. Logical record numbers are 1-based, not 0-based; that is, the first record in the database is record number 1. In all cases for the Queue and Recno access methods (and when calling the Btree access method using the DB→get and DBcursor→c_get functions with the DB_SET_RECNO flag specified), the data field of the key must be a pointer to a memory location of type db_recno_t, as type-def ’d in the standard Berkeley DB include file. This type is a 32-bit unsigned type, which limits the number of logical records in a Queue or Recno database; and the maximum logical record, which may be directly retrieved from a Btree database, to 4,294,967,296. ...