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?
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?