android SQLite 优化（三）使用事务优化 insert

SQLite 没插入一条数据默认创建一次事务

通过显示调用事务，可以提高SQLite操作的性能

        String[] sCheeseNames = {"a","b","a","b","a","b","a","b"};        String[] sCheeseOrigins = {"aa","bb","aa","bb","aa","bb","aa","bb"};        SQLiteDatabase db = SQLiteDatabase.create(null);        try {            db.beginTransaction();//开启事务                        SQLiteStatement stmt = db.compileStatement("INSERT INTO cheese VALUES(?,?)");                  int i = 0;                  for (String name:sCheeseNames){                      String origion = sCheeseOrigins[i++];                      stmt.clearBindings();                      stmt.bindString(1, name);                      stmt.bindString(2, origion);                      stmt.executeInsert();                  }              db.setTransactionSuccessful();//事务提交} catch (Exception e) {// TODO: handle exception}finally{db.endTransaction();//事务回滚}

当数据库做持久存储时，特别是存储在外部sd卡时，更应该采用一次性事务！

更多相关文章

随机推荐

android SQLite 优化（三）使用事务 优化 insert

更多相关文章

随机推荐

android SQLite 优化（三）使用事务优化 insert