The file system prefix split: is used to split logical files into multiple physical files, for example so that a database can get larger
than the maximum file system size of the operating system. If the logical file is larger than the maximum file size, then the file
is split as follows:
• (first block, is always created)
• .1.part (second block)
More physical files (.2.part, .3.part) are automatically created / deleted if needed. The maximum physical file size of a block
is 2^30 bytes, which is also called 1 GiB or 1 GB. However this can be changed if required, by specifying the block size in the
file name. The file name format is: split:: where the file size per block is 2^x. For 1 MiB block sizes, use x = 20
(because 2^20 is 1 MiB). The following file name means the logical file is split into 1 MiB blocks: split:20:test.h2.db. An
example database URL for this case is jdbc:h2:split:20:~/test.
Copied from original issue: MichaelErichsen/HRE--History-Research-Environment#12
From @MichaelErichsen on September 13, 2017 13:18
The file system prefix split: is used to split logical files into multiple physical files, for example so that a database can get larger than the maximum file system size of the operating system. If the logical file is larger than the maximum file size, then the file is split as follows: • (first block, is always created)
• .1.part (second block)
More physical files (.2.part, .3.part) are automatically created / deleted if needed. The maximum physical file size of a block
is 2^30 bytes, which is also called 1 GiB or 1 GB. However this can be changed if required, by specifying the block size in the
file name. The file name format is: split:: where the file size per block is 2^x. For 1 MiB block sizes, use x = 20
(because 2^20 is 1 MiB). The following file name means the logical file is split into 1 MiB blocks: split:20:test.h2.db. An
example database URL for this case is jdbc:h2:split:20:~/test.
Copied from original issue: MichaelErichsen/HRE--History-Research-Environment#12