Hello! В сообщении от Saturday 14 February 2009 00:33:38 Nathan Biggs написал(а): > Is there a faster way to read an entire table other then: > > select * from table > > Not that is is slow, just curious.
On linux you can do dd if=database.db of=/dev/null bs=1M and after perform "select ..." This trick does put your db to OS file cache and all read operations will be extremely fast. Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users