We are actually using Windows XP for an OS.  (I know, lots of 
limitations, but that is what we have to use).

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

Reply via email to