title: SQLite Inserts get slower even with transactions
body: <p>I'm having troubles with sqlite inserts performance even with transactions.
  My android app receives approximately 23.000 rows from a web service and I have to insert them into a single table.</p>
  
  <p>The web service is partitioned so that I receive about 2000 rows in every request to the WS and I wrap the 2000 inserts within a transaction. After those inserts are done I send the new request to the WS and again use a new transaction for the new 2000 rows.</p>
  
  <p>At the beginning it works fine. It does a lot of inserts per second. but with the time it gets slower and finally ends up with 4 or 3 inserts per second until it completes the 23000 rows.</p>
  
  <p>Is there a problem with the size of the table? When it gets bigger the inserts get slower?
  Is there any way to improve the performance for that large amount of data?</p>
  
  <p>Thanks for your help.</p>