I am not sure that retrieving it is the correct word. In term of efficiency you have to take into account the overhead of multiple files, some in cache, some no

I am not sure that retrieving it is the correct word. In term of efficiency you have to take into account the overhead of multiple files, some in cache, some not vs 1 single probably already cached file Also https://www.sqlite.org/fasterthanfs.html https://www.sqlite.org/fasterthanfs.html