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
