On 01/23/2013 11:04 PM, Heiles, Katrina wrote:
Hi Dan,
Yes, this resolves the problem. performance comes back up to 31K/sec.
What are the risks of using this as a workaround? Data integrity is very
important to us so I'm curious what effect
this pragma would have.
No effect on data integrity or durability.
SQLite uses temporary files for various reasons - statement journals,
temporary tables (those created with CREATE TEMP TABLE), to materialize
views and sub-queries when required, that sort of thing. If you set
"PRAGMA temp_store=memory", then it uses malloc'd memory instead of
temporary files for these things.
See also:
http://www.sqlite.org/tempfiles.html
Dan.
thanks, katrina
Out of interest, is performance improved any with 3.7.15.2 if you
execute "PRAGMA temp_store = memory" before calling _do_batch_insert()?
Thanks,
Dan.
_______________________________________________
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