On Mon, 5 Sep 2011 16:12:39 +0800 (CST), ?? <okd...@126.com> wrote: >> For eg, the query like this: "select count(id) from tab1" ,and the >> record number is above 100,000. If i can't restart my pc, the >> speed is quicker when i do the second query. > >>> This must be because the OS cached your database file into memory. > > thanks forS??bastien Escudier's reply. but I am comfused that: First time > i used sqlite database A for query, and second time database B, and then the > second query speed of another database (B) is still faster. :(
Just after starting your PC it may still be busy with housekeeping, preloading applications etcetera, even if login is already possible. Does the difference still show up when you let the PC settle for 5 minutes after reboot and login? -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users