rapidly constructing table with primary key

This question already has an answer here:

Improve INSERT-per-second performance of SQLite? 10 answers

---

Make sure that your insert statements are executed within a transaction, else an implicit transaction will be opened for every statement which is rather time-consuming. Execution of many consecutive statements should be much faster then.

链接地址: http://www.djcxy.com/p/19778.html

上一篇: Sqlite插入花费很多时间

下一篇: 用主键快速构建表格