> I ran some tests using the command-line sqlite3.exe, and observed that > Windows Vista (SP1) is actually trying to cache the entire 5gb file > into > memory during the table scan! The system slows to a complete crawl and > becomes unresponsive. The sqlite3.exe's memory remains very minimal, > but > Vista itself eats every last scrap of physical memory, forcing all > other > apps to the paging file trying to cache the contents of the database.
[Sherief N. Farouk] Any chance you could make a small C program to reproduce this case (via procedurally creating a similarly-sized database)? Out of curiosity, was that on x86 or x64? - Sherief _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users