How to improve the write speed then.
I've found that in most cases using "chained" insertion speeds up
things dramatically:
insert into mytable (x, y, z) values (1, 2, 3), (4, 5, 6), (7, 8, 9), ...
If you insert K rows at a time this way your total insert time can by
cut by a significant factor based on K. Always wrap bulk inserts in
transactions.
Also building index after insertion is beneficial.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
