擅长:python、mysql、java
<p>使用生成器表达式动态地将数据分成块,在事务中进行插入。这是<a href="http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html" rel="nofollow noreferrer">sqlite optimization FAQ</a>的一句话:</p>
<blockquote>
<p>Unless already in a transaction, each SQL statement has a new
transaction started for it. This is very expensive, since it requires
reopening, writing to, and closing the journal file for each
statement. This can be avoided by wrapping sequences of SQL statements
with BEGIN TRANSACTION; and END TRANSACTION; statements. This speedup
is also obtained for statements which don't alter the database.</p>
</blockquote>
<p><a href="https://stackoverflow.com/a/7137270/771848">Here's</a>代码的外观。</p>
<p>此外,sqlite还可以<a href="http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles" rel="nofollow noreferrer">import CSV files</a>。</p>