On Jan 19, 2014, at 3:00 PM, Mario M. Westphal <m...@mwlabs.de> wrote:
> Also FTS4 is used, which also creates large tables. (Unrelated to your question, but, take a look at "external content" FTS4 tableā¦ they dramatically cut down the amount of duplicated data [1]) > During an ingest phase, my application pumps in hundreds of thousands of > records into multiple tables. For initial, bulk loading, I tend to use the following pragma combo: pragma journal_mode = off pragma locking_mode = exclusive pragma synchronous = off [1] http://www.sqlite.org/fts3.html#section_6_2_2 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users