SQLite Forum

The article "35% Faster Than The Filesystem" needs filesystem specification
Login

The article "35% Faster Than The Filesystem" needs filesystem specification

(1) By anonymous on 2020-10-26 03:13:25 [link] [source]

The article oversensationalized. Like a miracle was observed that no one expected to see. It is not a miracle and people are well aware that file access require lots of operation. A file index needs to be found in a directory structure by its name and then located on the disk before read. In this context SQLite is not competing with direct filesystem access on an operational system. It competes with filesystem and its directory structure organization and search algorithms. This should be noted in the article and the used filesystems should be specified, ext4 for Linux etc.

(2) By Stephan Beal (stephan) on 2020-10-26 03:17:59 in reply to 1 [source]

The article oversensationalized...

For the others who are also scratching their heads, the OP is referring to:

https://www.sqlite.org/fasterthanfs.html