<< Click to Display Table of Contents >> Navigation:  »No topics above this level« dbBATCHCOUNT

The database property, dbBATCHCOUNT, lets you control the number of records to include in a batch before an auto-commit occurs. In this way you can adjust the size of a batch to accommodate server transaction logs that are not big enough to handle the whole batch.

dbBATCHCOUNT //rw UINT16, batch mod count (records) before auto-commit

The value of the batch count property is obtained from the BDE DB OPEN section of the Windows Registry:

BATCH COUNT  // UINT16, batch mod count (records) before auto-commit

If this option is not present or is zero then the default is the number of records that will fit in 32k bytes. You can override this value by setting dbBATCHCOUNT and the new value will take effect for all subsequent DbiBatchMove calls. When DbiBatchMove is called in an explicit client transaction (inside a DbiBeginTran/DbiEndTran block), the value of batch count is ignored.