Especially when using a modern storage medium, which most servers nowadays use, I doubt that filesystem I/O will be a bottleneck for the vast majority of use cases.
I/O is extremely fast and will be negligible compared to other stuff going on to serve those requests, even running queries themselves.
The CPU work done by SQLite will vastly outshine the time it takes to read/write to disk.
It might be a bottleneck to reading if you have a very large database file, though.
Comments
Especially when using a modern storage medium, which most servers nowadays use, I doubt that filesystem I/O will be a bottleneck for the vast majority of use cases.
I/O is extremely fast and will be negligible compared to other stuff going on to serve those requests, even running queries themselves.
The CPU work done by SQLite will vastly outshine the time it takes to read/write to disk.
It might be a bottleneck to reading if you have a very large database file, though.