Android boosts SQLite's high-volume data storage efficiency

It is time-consuming to insert in SQLite because no transactions are used, and the default is to use each insert once

A transaction so that if you insert 1000 data, it is time consuming to open 1000 transactions, so we can use the code to control transactions by manually opening and closing.

?

1 2 3 4 5 6 7 8 9 10 11 12

public void insertAll(String databaseName,             ArrayList<ContentValues> valuesArr) {         SQLiteDatabase db = getWritableDatabase();         db.beginTransaction();         for (ContentValues val : valuesArr) {             db.insert(databaseName, null, val);         }          db.setTransactionSuccessful();         db.endTransaction();         db.close();     }

With this open transaction, the time to insert the data will be significantly improved.

But improving efficiency can also be considered in other ways, such as database correlation, which still needs to be studied