Re:SQLite as an Application File Format (2014)
by devmunchies on Monday December 24, 2018 @11:09PM
(#18755845)
So does that mean serving static files from a SQLite file would be faster than something like NGINX?
[ Parent
| on HN ]
Re:SQLite as an Application File Format (2014)
by oscargrouch on Monday December 24, 2018 @11:47PM
(#18755960)
No, because of the sendfile syscall, where the kernel pass all the file data without switching back to userspace.
Even if you can in theory save some time with small files with sqlite, you would be back to read/write IO and userspace/kernel byte buffer switching.
And it probably wouldn't be faster than something like a mmaped file anyway (unless the SQLite Db is also mmaped).
Re:SQLite as an Application File Format (2014)
by fiddlerwoaroof on Tuesday December 25, 2018 @12:36AM
(#18756107)
The thing is SQLite handles a lot of hard problems that you might not realize you have: like “was my data actually written to the disk”