title: how to bulk insert in sqlite in android
body: <p>I am using SQLiteOpenHelper  for data insertion. I need to insert 2500  id and 2500  names, So it takes too much time. Please any one help me how to reduce the insertion time.  can we insert multiple records at a time ? any one help me. thank you in advance.
  code:</p>
  
  <pre><code>public class DatabaseHandler extends SQLiteOpenHelper {
      SQLiteDatabase db;
      private static final int DATABASE_VERSION = 8;
      private static final String TABLE_CITY = "CITYDETAILS";
      public DatabaseHandler(Context context) {
          super(context, DATABASE_NAME, null, DATABASE_VERSION);
          this.mContext = context;
  }
  
  public void onCreate(SQLiteDatabase db) {
      db.execSQL("DROP TABLE IF EXISTS " + TABLE_CITY );
      String CREATE_CITY_TABLE = "CREATE TABLE " + TABLE_CITY + "("
                  + CityId + " INTEGER," + CityName + " TEXT " + ")";
      db.execSQL(CREATE_CITY_TABLE);
      db.execSQL(CREATE_RechargeTypes_TABLE);
      this.db=db;
   }
  
   @Override
   public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
       // Drop older table if existed
       // Create tables again
       onCreate(db);
   }
  
   public  void add_city(String cityid,String cityname){
       SQLiteDatabase db = this.getWritableDatabase();
       db.beginTransaction();
       ContentValues values = new ContentValues();
       values.put(CityId, cityid);
       values.put(CityName, cityname);
       db.insert(TABLE_CITY, null, values);
       db.insertWithOnConflict(TABLE_CITY, null, values, SQLiteDatabase.CONFLICT_IGNORE);
       db.setTransactionSuccessful();
       db.endTransaction();
       }
  }
  </code></pre>
  
  <p>activity calss:</p>
  
  <pre><code>try{
              String Status = result.get("Status").getAsString();
              if (TextUtils.equals(Status, "true")) {
                  Gson gson = new Gson();
  
                  JsonArray array = result.get("data")
                          .getAsJsonArray();
                  Type type = new TypeToken&lt;ArrayList&lt;Cities&gt;&gt;() {
                  }.getType();
                  setmCities((ArrayList&lt;Cities&gt;) gson.fromJson(array, type));
                  for(int i=0;i&lt; array.size();i++) {
  
                     db.add_city(mCities.get(i).getCityid(),mCities.get(i).getCityname());
  
                  }
              }
  </code></pre>