3 ms·
I'm maintaining an application that uses a similar (OPC) file format. It has served us well and it beats the legacy way of having just a directory of files (e.g
by alkonaut 9y ago
I'm maintaining an application that uses a similar (OPC) file format. It has served us well and it beats the legacy way of having just a directory of files (e.g. when you want to send a file to someone else it's ONE file) but it doesn't scale very well when adding lots of data, and incremental update is painful compared to just using a directory.
How does sqlite handle incremental update? Does it use separate file storage for large table blobs? If the blobs are in line, how does it handle changing one blob from 1Mb to 2Mb say? Presumably it just appends the new blob, updates the pointer, and marks the original 1Mb area as unused and possible to clean up? That leaves a 3Mb file, which can be vacuumed to 2Mb then?