On 27.03.2013 22:55, Jeff Archer wrote:
On Wed, Mar 27, 2013 at 5:46 PM, David King <dk...@ketralnis.com> wrote:
I am populating a database with 5764 records using the exact same data set
each time into a newly created file.
When I use no explicit transactions (default atomic commit) it takes 17.7
seconds.
When I set journal_mode = off, same operation takes 5.5 seconds.
If I do all 5764 inserts within a single transaction only 2.5 seconds.
That sounds about right, yeah. With journalling, most disk writes have to be
done twice (once to the journal and once to the data file).
Which is why I expected journal_mode = off to make it faster. But it
is 3 seconds faster when I leave journaling enabled and do all writes
within a single transaction.
Seems like you have defined some sort of index. You will get faster bulk
inserts when you create your indexes afterwards.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
