> 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). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users