On Mon, 2011-09-05 at 12:23 +0800, 徐 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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
