-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/01/12 11:28, Tal Tabakman wrote: > my question is: is there a rule of thumb regarding the optimal number > of inserts in a transaction ?
How many can you afford to lose should there be an unexpected power failure before performing a commit? Other than that you will be building up a journal/wal file of approximately the same size as the size of the data inserted. You are better off picking how large you are happy for that to grow to. Remember that you also need to include index sizes if you use them. In your circumstances I'd probably pick 128KB or 1MB of outstanding data unless inserting gigabytes, in which case I would disable all journalling so transactions wouldn't really matter. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk8LWokACgkQmOOfHg372QR7JwCgq+vF32zL3BlpJGOL+iSnLn7G L7EAn0ceBvrxJg819uwLZUKvHhlKfNsd =FHfq -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
