Hi guys,
I have an application that perform a lot of insert operations to a table
(each raw contains one ~20 character string and 10 integers)
I have read a bit about insert performance and use transactions for my
insert operations
my question is: is there a rule of thumb regarding the optimal number of
inserts in a transaction ?
i.e. suppose that all in all I have 1000000 inserts operations, what will
be faster, to bundle 20 transactions of 50000 inserts or 10 transactions of
100000 inserts ?
cheers
Tal
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
