SQLite data processing efficiency

1. by default, SQLite starts a transaction for each operation. If 1000 operations are performed, 1000 transactions must be started. "transaction enabling + SQL Execution + transaction disabling" naturally takes a lot of time.SQLite databases are essentially files on a disk. Therefore, all database operations are actually converted to file operations, and frequent file operations will be a very good process, it will greatly affect the speed of database access. Use transactionsAll SQL statements to be executed will be first cached in the memory, and then written to the database at one time when the commit is executed. In this way, the database file is only opened and closed once, which naturally improves the efficiency.