Using Transaction for large Data ~15k entries

[imangazalievm]

Using Transaction for large Data ~15k entries

[ImangazalievM]

I will check it out soon. Unfortunately, I have a lot of work to do now.

[bhapps]

Confirmed, It is due to the missing line code setTransactionSuccessful()
beginTransaction()
/* do sql work here */
ReActiveAndroid.getDatabase(ORMAppDatabase.class).getWritableDatabase().setTransactionSuccessful();
endTransaction()

[ImangazalievM]

@bennith Good job! I will add new API for working with transactions in the new version.

[bhapps]

Moved code to pass through AsyncTask to stop UI freezing (worked), however, the below,

begin/end transaction, even though the if(class.save() > 0){} passes true on each data item (in List<>), nothing gets actually added or updated (get count of 0)

still persists..

[ImangazalievM]

1. Can you create a test project, that reproduces your problem?
2. To avoid UI freezing you have to perform your operations with a database in the background thread.

[ImangazalievM]

@bennith can you create a simple project that reproduces your problem, and share it on GitHub?

[bhapps]

@ImangazalievM

Please see sample project which uses transaction to add data (which still fails), but turning off transactions data is added (getting counts of 15K rows)

Change public static boolean useTransactions = true; in MainApplication to enable/disable transaction

Please see ORMHelpers file and the method public static Boolean setRowData(List<String> getPassedData) which processes the passed data;

https://github.com/Bennith/ORMTransactionExample

[bhapps]

Maybe it is due to missing the setTransactionSuccessful() to do the actual commit.
I will test this on my side to confirm.

How you can use database transaction in Android

• If you want to start the transaction there is a method beginTransaction()
• If you want to commit the transaction there is a method setTransactionSuccessful() which will commit the values in the database
• If you had start the transaction you need to close the transaction so there is a method endTransaction() which will end your database transaction

If so, can we add this to the documentation transactions