title: How get SQLITE to buffer inserts?
body: <p>I'm creating a transaction explicitly using SQLITE, i.e.:</p>
  
  <p>sqlite3_exec(db, "BEGIN", NULL, NULL, NULL);</p>
  
  <p>do a bunch of inserts</p>
  
  <p>sqlite3_exec(db, "END", NULL, NULL, NULL);</p>
  
  <p>I expect the database to buffer the inserts between this pair until the END is hit, then flush it all to disk.</p>
  
  <p>It doesn't seem to do this, instead flushing to disk at regular intervals.</p>
  
  <p>I'm also noticing that I sometimes can't successfully execute a select statement on the same database from a different process, and I suspect it might be related to my transaction usage strategy. In these cases the select fails because of a LOCK or BUSY state on the db.</p>
  
  <p>Does anyone know how to man-handle SQLITE so it buffers the inserts for better performance?</p>
  
  <p>Many Thanks!</p>