Solution to the slow sqlite3 speed

Solution to the slow sqlite3 speed

The speed of sqlite3 insert into and other operations is relatively slow.

The reason is that the file already exists in the disk, and the file must be opened every time you access it,

If you perform a lot of operations on the database tutorial, It is very slow.

Solution: commit in the form of transactions: because after the transaction starts, a large number of statements for operations are saved in

In memory, all data is written to the database only when submitted. In this case, the database file is opened only once.

Use the following statement before performing a large number of operations:

Rc = sqlite3_exec (db, "begin;", 0, & szerrmsg );

For (...)

{

// Insert into operate

}

Rc = sqlite3_exec (db, "commit;", 0, 0, & szerrmsg );

This speed has increased by nearly a thousand times.