Icon Enabling Large File Support

Introduction
Be default DBISAM only supports the following maximum capacities:

Operating SystemCapacity
WindowsA maximum file size of 4,000,000,000 bytes for any physical file (data, indexes, or BLOBs) that is part of a logical table and a maximum of 200 million records within a given logical table.
LinuxA maximum file size of 2,000,000,000 bytes for any physical file (data, indexes, or BLOBs) that is part of a logical table and a maximum of 100 million records within a given logical table

By setting the TDBISAMEngine LargeFileSupport property to True you can enable large file support, which bumps up the maximum capacities in DBISAM to:

Operating SystemCapacity with Large File Support
WindowsA maximum file size of 128,000,000,000 bytes for any physical file (data, indexes, or BLOBs) that is part of a logical table and a maximum of 1 billion records within a given logical table.
LinuxNo change, DBISAM does not support large file sizes under Linux at this time.

Information Do not mix applications or DBISAM database servers that have large file support enabled with applications or DBISAM database servers that do not have large file support enabled. Doing so will cause database corruption because one application or database server will not see or respect the locks of the other application or database server.

The following example shows how you would enable large file support using the default global Engine function in the dbisamtb unit (Delphi and Kylix) or dbisamtb header file (C++Builder):

Engine.LargeFileSupport:=True;

Information The LargeFileSupport property must be set before the engine is started or an exception will be raised.
Image