SQLite Forum

partial file load?
> because apparently the entire \[database\] file is loaded before any table can be accessed.

What leads you to believe that? I think once you discover the actual cause of the delay you seek to avoid, you will not feel a need to induce "partial file load" (which happens without much effort.)