3 ms·
Thank you for the check. No index, as they take space, and I wrote the queries considering SQLite automatic indexes. They will be created on demand, at unpacki
by OttoCoddo 3y ago
Thank you for the check.
No index, as they take space, and I wrote the queries considering SQLite automatic indexes. They will be created on demand, at unpacking time. All the unpacking processes are made to read and decompress content just once, so there are no worries about slowdowns.
I suggest trying Pack for yourself and seeing the speed.
Or deeper, use `--activate-other-options --transform-to-sqlite3` to transform a Pack file to SQLite3, create your own indexes, and use `--activate-other-options --transform-to-pack` to convert it to Pack and then try unpacking. You will not see any worthy difference.
Yes, Contents are like packages of raw data from a chunk, a whole, or many of the items (files or data). They may be compressed if needed (With Zstandard). ItemContent table helps to find the needed Item parts.
The Content structure circumvents any BLOB limit, but it is also made to give better compression while keeping random access.
- Retr0id 3y agoFair point, I can see that indexes are not really necessary.