android SQLite 优化（一）insert优化 1

最新推荐文章于 2024-10-04 10:05:19 发布

柳木木_kylin

最新推荐文章于 2024-10-04 10:05:19 发布

阅读量623

点赞数

文章标签： sqlite android 优化

本文链接：https://blog.csdn.net/u010136741/article/details/41009093

版权

当你执行SQLite 时， SQLite 内部是编译执行的。

当循环插入多条数据时，可以使用complieStatement 让语句在循环外只编译一次

<span style="white-space:pre">		</span>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);
        	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();
        	}

这样，只执行了一次编译，并且绑定值是比编译更轻量级的操作