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

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