Android SQLite Transaction Processing

Application initialization requires a lot of data to be inserted into SQLite, and the use of the For+insert method alone causes the application to respond slowly, because when SQLite inserts the data, the default statement is a transaction, and the number of times the disk operation is there. My application initial 5,000 records that is to read and write disk operations 5,000 times.
And there is no guarantee that all data can be inserted simultaneously. (It is possible that part of the insert succeeds, another part fails, and subsequent deletions are made.) Too troublesome)

Workaround:

Add a transaction, insert 5,000 as a transaction

we use SQLite's transactions to control:
db.begintransaction (); Set up a start transaction manually
try{
//Bulk processing operations
For (Collection c:colls) {
Insert (DB, c);
            }
db.settransactionsuccessful ();//Set transaction success, do not set automatically rollback does not commit
}catch (Exception e) {
mylog.printstacktracestring (e);
}finally{
db.endtransaction ();//Processing complete
           }

Turn:

1. use Sqlitedatabase's BeginTransaction () method to open a transaction, the program executes to endtransaction () The Endtransaction method checks whether the flag for the transaction is successful, if the program executes to the settransactionsuccessful ( ) method before the call to set the transaction flag as successful commits the transaction, If the Settransactionsuccessful () method is not called, the transaction is rolled back.

2. examples of use are as follows: The following two SQL statements are executed in the same transaction.

Java Code

2. Bank account Transaction Testing
4. public void Payment ()
6. {
8. Sqlitedatabase db = Dbopenhelper.getwritabledatabase ();
10. Open transaction
12. Db.begintransaction ();
14. Try
16. {
18. Db.execsql ("Update person set amount=amount-10 where personid=?", New Object[]{1});
20. Db.execsql ("Update person set amount=amount+10 where personid=?", New object[]{2});
22. The transaction flag is set to be successful, and the transaction is committed when the transaction is ended
24. Db.settransactionsuccessful ();
26. }
28. Finally
30. {
32. End transaction
34. Db.endtransaction ();
36. }
38. }

Android SQLite Transaction Processing