Abstract: In some applications with intensive writing, Flash becomes invalid earlier than expected if SQLite writes database file too frequently. In order to solve the problem, by analyzing the transaction processing procedure and auto-commit mode of SQLite, this paper uses the method of delay commit to reduce the frequency of erasing and writing Flash. It divides data into the key or un-reproducible data and reproducible data, and treats them with appropriate methods, which ensures the security of data.

Key words: transaction processing, auto-commit, lay commit, ata classification

摘要： SQLite的事务处理机制在写操作密集的应用中会引起频繁擦写Flash，导致Flash过早失效。针对上述问题，通过分析SQLite的事务处理流程及自动提交模式，采用延时提交的方法降低Flash的擦写频率，并将数据分为关键或不可重现数据以及可重现数据，分别进行处理，以保证数据的安全性。

关键词: 事务处理, 动提交, 提交, 据分级

CLC Number: 

• TP302.1