sqlite插入速度优化方案
先贴上SQLiteOpenHelper的代码,我们创建测试的表是user,它有四个字段id,name,age,height,remark,测试用的小米2,默认条数为100行。
public long insert5(int sum) {long before = System.nanoTime();MySQLiteOpenHelper dbHelper = new MySQLiteOpenHelper(MainActivity.this);// 得到数据库对象SQLiteDatabase db = dbHelper.getWritableDatabase();db.beginTransaction();for (int i = 0; i < sum; i++) {String sql = "insert into user(name,age,height,remark) values('zhangsan',23,1.78,'无')";db.execSQL(sql);}db.setTransactionSuccessful();db.endTransaction();db.close();long after = System.nanoTime();return after - before;}