It depends on what else you want to do with database and how important for you to be safe against power outages and OS crashes. If it's not important and you're working with database from the single process and single connection you may never commit a transaction opened at the beginning of the application.
Pavel On Thu, Nov 12, 2009 at 12:08 AM, Jon <barfo...@yahoo.com> wrote: > For performance reasons, I want to batch my SQLite insert/replace > operations in a single SQL transaction that I send to my local SQLite > database running on Windows XP. I am also using the ADO.Net assembly > to interact with my SQLite database. > > Does anyone have any insight into how large my transaction batches > should be? For example, have up to 300 insert/replace operations in a > single transaction? up to 1000 insert/replace operations in a single > transaction? etc. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
