Is there a limit to the number of operations I can have in a transaction?
I'm loading in about 1.5 million rows from a file into a table with insert statements in a transaction. Gets about half way and then System.Data.SQLite throws an Access Violation in the native code.
Any ideas?