|
|
|
There are situations where a record fetch, a record insert or a record delete operation has to be applied to a group of related records. For example, if an invoice record is being displayed, it may be necessary to retrieve all invoice items for that invoice as well. FairCom DB has a batch feature which allows for the high performance transfer of large number of records at once. This greatly improves application performance. c-treeDB has been enhanced with this batch support.
The following types of batch operations may be performed:
Retrieve records by partial key
All records with keys matching a partial target key are loaded into an internally maintained buffer region. If there are more records than fit in the buffer, those that fit are loaded, and subsequent calls will retrieve the remaining records.
Retrieve records by index range
Retrieve all records that match an index range expression. All matched records are loaded into an internally maintained buffer region. If there are more records than fit in the buffer, those that fit are loaded, and a subsequent call will retrieve the remaining records.
Retrieve records by physical order
All records of a table are loaded by physical order into an internally maintained buffer region. If the selected records do not fit in the buffer, those that fit are loaded, and subsequent calls will retrieve the remaining records.
Insert a group of records
A group of new records are loaded into an internally maintained buffer region and this group of records are inserted into a table.
Delete a group of records
All records with a key matching a partial target key are deleted.
Review the complete documentation in the c-treeDB C and C++ Developer Guides for complete information on this new c-treeDB feature.
