How does sparse files used by sqlite3?
(1) By 6kEs4Majrd on 2020-09-21 22:44:37 [link] [source]
Many file systems support sparse files. Could anybody let me know whether sqlite3 uses such a feature? If so, how is it used? Thanks.
http://blogs.tulsalabs.com/?p=166
(2) By Keith Medcalf (kmedcalf) on 2020-09-21 23:43:57 in reply to 1 [source]
The same way sparse files are used by anything. Allocation units which have not been written are not allocated. That said, SQLIte3 does not "allocate" space that it does not write to. Nor does it "overwrite" allocation units with "deallocation markers" so that they may be sparsely released.