Hm, I test I find index on PK field: CREATE TABLE test (key blob, value blob, PRIMARY KEY(key)) CREATE INDEX keyindex ON test (key)
Epic fail, I think :D Default test on Intel(R) Atom(TM) CPU N450 @ 1.66GHz fillseq : 442.937 micros/op; 0.2 MB/s fillseqsync : 1678.168 micros/op; 0.1 MB/s (10000 ops) fillseqbatch : 73.016 micros/op; 1.5 MB/s ... And with enabled WAL and synchronous=NORMAL and wal_autocheckpoint=4096 (LevelDB log size is 4Mb by default) and without index on PK field (!): fillseq : 139.190 micros/op; 0.8 MB/s fillseqsync : 228.869 micros/op; 0.5 MB/s (10000 ops) fillseqbatch : 56.131 micros/op; 2.0 MB/s ... -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users