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;
......
阅读全文