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. 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