title: Android SQLite database: slow insertion
body: <p>I need to parse a fairly large XML file (varying between about a hundred kilobytes and several hundred kilobytes), which I'm doing using <code>Xml#parse(String, ContentHandler)</code>. I'm currently testing this with a 152KB file.</p>
  
  <p>During parsing, I also insert the data in an SQLite database using calls similar to the following: <code>getWritableDatabase().insert(TABLE_NAME, "_id", values)</code>. All of this together takes about 80 seconds for the 152KB test file (which comes down to inserting roughly 200 rows).</p>
  
  <p>When I comment out all insert statements (but leave in everything else, such as creating <code>ContentValues</code> etc.) the same file takes only 23 seconds.</p>
  
  <p>Is it normal for the database operations to have such a big overhead? Can I do anything about that?</p>