title: Combine inserts into one transaction Python SQLite3
body: <p>I am trying to input 1000's of rows on SQLite3 with insert however the time it takes to insert is way too long. I've heard speed is greatly increased if the inserts are combined into one transactions. However, i cannot seem to get SQlite3 to skip checking that the file is written on the hard disk.</p>
  
  <p>this is a sample:</p>
  
  <pre><code>if repeat != 'y':
      c.execute('INSERT INTO Hand (number, word) VALUES (null, ?)', [wordin[wordnum]])
      print wordin[wordnum]
  
  data.commit()
  </code></pre>
  
  <p>This is what i have at the begining.</p>
  
  <pre><code>data = connect('databasenew')
  data.isolation_level = None
  c = data.cursor()  
  c.execute('begin')
  </code></pre>
  
  <p>However, it does not seem to make a difference. A way to increase the insert speed would be much appreciated.</p>