[sqlite] select speed is too slow

[徐]

Hello All, I found it is too slow when i do a query first time after i restart 
my pc, can anyone give some advice for this problem?
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.
 
Thanks in advance,
okdodo
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users