Re:SQLite: 35% Faster Than the Filesystem
by OttoCoddo on Saturday July 27, 2024 @10:37AM
(#41086881)
SQLite can be faster than FileSystem for small files. For big files, it can do more than 1 GB/s.
On Pack [1], I benchmarked these speeds, and you can go very fast. It can be even 2X faster than tar [2].
In my opinion, SQLite can be faster in big reads and writes too, but the team didn't optimise it as much (like loading the whole content into memory) as maybe it was not the main use of the project. My hope is that we will see even faster speeds in the future.
In my opinion, SQLite can be faster in big reads and writes too, but the team didn't optimise it as much (like loading the whole content into memory) as maybe it was not the main use of the project. My hope is that we will see even faster speeds in the future.
[1] https://pack.ac [2] https://forum.lazarus.freepascal.org/index.php/topic,66281.m...