SQLite Forum

partial file load?
Login
SQLite reads the minimal amount of the file that it can get away with
in order to answer your query precisely.  What makes you think that
it reads the entire file into memory?