Android SQLite BULK INSERT data slow solution

Android is using SQLite database, SQLite is a relatively lightweight database,sqlite by default when inserting data by default a statement is a transaction, how many data there are disk operations. Inserting 10,000 records at a time is about 10,000 read and write disk operations, resulting in slow speed.

Workaround:

Add a transaction, insert 5,000 as a transaction

Database.begintransaction (); Set up a start transaction manually

Data insertion Operation cycle

Database.settransactionsuccessful (); Set transaction success, do not set automatically rollback does not commit

Database.endtransaction (); Processing complete

Android SQLite BULK INSERT data slow solution