Insert in SQLite faster using single Android Room transaction rather than multi transactions

Question

By default, each method annotated with @Insert, @Update, or @Delete in DAO class will be executed within its own transaction and additional transactions are queued and executed on a first come, first serve order. If it is desired to run multi methods using a single transaction runInTransaction() method can be used. Correct me if I'm wrong about this.

I expected using single transaction rather than multi transactions performs better while inserting data in DB. But nothing has changed in terms of performance even after I call 2 different DAO methods in the single transaction.

I used two different methods to measure performance. First of them insert the data without using runInTransaction()

    private void insert() {
        Log.d(DEBUG_TAG, "Is it running in transaction?: " + resourceRoomDatabase.inTransaction());
        startTime = Instant.now();
        disposable.add(dao.insertLanguageResourceList(languageResourceList)
                .subscribeOn(Schedulers.io())
                .subscribe(() -> {
                            endTime = Instant.now();
                            Log.d(DEBUG_TAG, "insertLanguageResourceList completed. Duration is " + (Duration.between(startTime, endTime).toMillis()) + " milliseconds!");
                            startTime = endTime;
                        },
                        (error) -> Log.d(DEBUG_TAG, "insertLanguageResourceList error: " + error)));

        disposable.add(dao.insertProducts(productList)
                .subscribeOn(Schedulers.io())
                .subscribe(() -> {
                            endTime = Instant.now();
                            Log.d(DEBUG_TAG, "insertProducts completed. Duration is " + (Duration.between(startTime, endTime).toMillis()) + " milliseconds!");
                            startTime = endTime;
                        },
                        (error) -> Log.d(DEBUG_TAG, "insertProducts error: " + error)));
    }

Here is the logcat after I call this method

14:49:55.860  D  Is it running in transaction?: false
14:50:00.480  D  insertLanguageResourceList completed. Duration is 4619 milliseconds!
14:50:05.299  D  insertProducts completed. Duration is 4820 milliseconds!

And other way I tried is running this method inside runInTransaction()

   private void insertWithSingleTransaction() {
        new Thread(() -> resourceRoomDatabase.runInTransaction(this::insert)).start();
    }

Here is the logcat after I call insertWithSingleTransaction()

14:54:07.495  D  Is it running in transaction?: true
14:54:12.483  D  insertProducts completed. Duration is 4988 milliseconds!
14:54:16.573  D  insertLanguageResourceList completed. Duration is 4090 milliseconds!

My DAO class

@Dao
public abstract class LanguageResourceDao {
    @Insert
    public abstract Completable insertLanguageResourceList(List languageResourceList);

    @Insert
    public abstract Completable insertProducts(List productList);
}

In conclusion without using runInTransaction() it takes 9349 milliseconds and with runInTransaction() it takes 9078 milliseconds to insert data in DB.

If these two different ways acts the same in performance what's the point of executing two different methods in the same transaction? Is it wrong to be expecting single transaction performs better than the default behavior? How can I increase the speed of inserting data in DB?

Insert in SQLite faster using single Android Room transaction rather than multi transactions

Answers (1)

Related Questions