> 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. :( _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users