Yes this can work, however you are mostly relying on the operating system's file system cache for speed. Other databases will try harder to keep their own cache

Yes this can work, however you are mostly relying on the operating system's file system cache for speed. Other databases will try harder to keep their own cache. But true, there is lots of room where SQLite works nicely.