title: Sqlite3: Inserting multiple rows is still slow
body: <p>I need to perform about 250 million inserts using sqlite3 and python.</p>
  
  <p>I've wrapped every 500 inserts using SELECT UNION, and also done CREATE INDEX.</p>
  
  <p>But even so, it later becomes slow, performing less than 1 million inserts per hour (about 300 inserts per second)</p>
  
  <p>Is there any way to make it any significantly faster?</p>