大佬教程收集整理的这篇文章主要介绍了sqlite插入速度优化方案 申请加精,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
本帖最后由 yxmshaka 于 2013-4-10 17:52 编辑 我们创建测试的表是user,它有四个字段id,name,age,height,REMARK,测试用的小米2,默认条数为100行。
1。使用COntentValues插入。完成时间:4805493666(纳秒)
23
|
/**
* ContentValues方式
*
* @param sum
* @return
*/
// 得到数据库对象
sqliteDatabase db = dbHelper.getWritableDatabase();
ContentValues cv =
ContentValues();
"height"
1.78
);
db.insert(
"user"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,cv);
}
db.close();
return
after - before;
}
|
sqliteDatabase db = dbHelper.getWritableDatabase();
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,REMARK) values(?,?,?)"
;
; i < sum; i++) {
stmt.clearBindings();
4
);
stmt.execute();
}
db.close();
after - before;
}
; i < sum /
10
; i++) {
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,'无'),"
"('zhangsan',"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,"
:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; wIDth:auto!important; Font-family:Consolas,"
;
db.execsql(sql);
}
db.close();
after - before;
}
; i < sum; i++) {
;
db.execsql(sql);
}
db.close();
after - before;
}
yxmshaka查看楼层
以上是大佬教程为你收集整理的sqlite插入速度优化方案 申请加精全部内容,希望文章能够帮你解决sqlite插入速度优化方案 申请加精所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。