How frequently does the bug occur?

All the time

Description

We recently upgraded realm in our project from 5.15.1 to 10.8.0 and found out that our app performance decreases drastically : some actions that was almost immediate take now several seconds. Note that we are using realm intensively in our app, which would explain the amount of query done in the attached sample.

Stacktrace & log output

v5.15.1
------
For 25 queries: 73ms (average)
For 50 queries: 136ms (average)
For 100 queries: 241ms (average)
For 200 queries: 506ms (average)
For 400 queries: 1009ms (average)
For 600 queries: 1677ms (average)
For 800 queries: 1813ms (average)
For 1000 queries: 2227ms (average)

v10.8.0
-------
For 25 queries: 271ms (average)
For 50 queries: 529ms (average)
For 100 queries: 1057ms (average)
For 200 queries: 2085ms (average)
For 400 queries: 4329ms (average)
For 600 queries: 6193ms (average)
For 800 queries: 8185ms (average)
For 1000 queries: 10492ms (average)

Can you reproduce the bug?

Yes, always

Reproduction Steps

We managed to reproduce that in a sample project, that log some durations: (https://github.com/mederic/RealmPerformanceIssue)

Version

10.8.0

What SDK flavour are you using?

Local Database only

Are you using encryption?

No, not using encryption

Platform OS and version(s)

Android 24

Build environment

Android Studio version: 4.0.1
Android Build Tools version: 4.0.1
Gradle version: 6.1.1