title: Efficient use of SQL Transactions
body: <p>My application currently needs to upload a large amount of data to a database server (SQL Server) and locally on a SQLite database (local cache). </p>
  
  <p>I have always used Transactions when inserting data to a database for speed purposes. But now that I am working with something like 20k rows or more per insert batch, I am worried that Transactions might cause issues. Basically, what I don't know is if Transactions have a limit on how much data you can insert under them. </p>
  
  <p>What is the correct way to use transactions with large amounts of rows to be inserted in a database? Do you for instance begin/commit every 1000 rows? </p>