3 ms·
Nice to see sqlite3 as the file format of choice. It is known to be quite a bit faster than the file system for large number of small files .. though I'm not su
by sriku 6y ago
Nice to see sqlite3 as the file format of choice. It is known to be quite a bit faster than the file system for large number of small files .. though I'm not sure Audacity's case aligns with that. The file system is expected to be slightly faster for larger blobs, but sqlite3 can be like 10x faster than the file system in windows10 for blobs in the 100s of kB range.
Overall, it looks like it might be a great performance boost when working with highly edited fragments and at worst a slight performance degradation for large unedited tracks.
https://www.sqlite.org/fasterthanfs.html https://www.sqlite.org/fasterthanfs.html