-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jim Wilcoxson wrote: > Can anyone shed light on why building a database inside a single > transaction would be slower than periodically commiting?
If you look at the user and sys times then each approach is almost the same. The real times differing so much indicates other activity on the machine as well as I/O wait. Assuming you are using Linux, one gotcha with ext3 filesystems is that the fsync/fdatasync turns into a sync - ie they cause all outstanding data for the entire filesystem to be written not just the file in the fsync request. Consequently *any* other filesystem activity will slow your SQLite activity and give the kind of varying real times you see. I like to run "vmstat 1" to get a better picture of what is going on with disk activity. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkmKLFUACgkQmOOfHg372QSlqACfWr+iKHni+VD2BTx4Do8MU83j eN8AnRUTysAky05K6sj6f9DuR7S15fqH =3fnx -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users