现在做的App使用SQLite保存本地数据,通过OrmLite框架进行数据库的操作。由于本地保存的数据量较大,需要优化SQLite插入数据的性能。查阅了OrmLite官方文档,发现OrmLite自带批任务处理的方法,下面先比较一下批处理任务和单任务的效率差别。下面是需要插入数据库的Article表,包含6列数据,测试插入1万条Article的耗时。
package OrmLite.Bean;
import com.j256.ormlite.field.DatabaseField;
import com.j256.ormlite.table.DatabaseTable;
@DatabaseTable(tableName = "tb_article")
public class Article {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField
private String title;
@DatabaseField
private String content;
@DatabaseField
private String author;
@DatabaseField
private int year;
@DatabaseField
private int count;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String