title: compileStatement or db.insert in android
body: <p>I want to insert records into table multiple number of times, I have the choice to either use compileStatement or use db.insert as shown below.</p>
  
  <pre><code>String TABLENAME = "table"; //fields in table: id, name
  SQLiteStatement statement = db.compileStatement("INSERT INTO "+TABLENAME+" VALUES(?,?);");  
  statement.bindLong(1,666);  
  statement.bindString(2,"john");
  statement.executeInsert();
  </code></pre>
  
  <p>or </p>
  
  <pre><code>String TABLENAME = "table";
  ContentValues values = new ContentValues();
  values.put("id", 666);
  values.put("name", "john");
  db.insert(TABLENAME, null, values);
  </code></pre>
  
  <p>Which one should be optimal?</p>
  
  <p>EDIT:-
  The application which I am running is single threaded.</p>