On 1 Dec 2016, at 7:24am, Stephan Stauber <stephan.stau...@simplan.de> wrote:
> SQLite 3.8.5: to INSERT 380.000 records into a in > inMemory Database it takes 10 seconds > SQLite 3.10.0 to INSERT 380.000 records into a in > inMemory Database it takes 35 seconds Are you doing those INSERTs in transactions (either one big one or perhaps batches of 1000) or separately ? Can you get use a timing facility to find out whether your process is using more CPU time as well as more wall time ? If you can write the commands to a text file you can use the ".timer" command to do it. I know this doesn’t solve the problem but it adds useful data. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users