Performance on "big" data compared to native Android

[mtotschnig]

Planning to use sqlite-android with a Content-Provider App using SupportSQLiteOpenHelper.Factory, I have been comparing its performance on a fairly big table (35624 entries) and complex query: In two contexts, I have observed native Sqlite being considerably faster.
On an Android 10 Xiaomi Mi A2, my app's main query takes 6 seconds with sqlite-android and 400 ms with native Sqlite
On an Android 11 Emulator, 550 ms with sqlite-android and 150 ms with native Sqlite

Is there some configuration I am missing, that is needed to make sqlite-android run with performance on par with native?

[mtotschnig]

The problem seems specific to version 3.39.2 (and 3.39.0-1). If I use the previous version available from Jitpack (3.36.0), performance of sqlite-android and native sqlite are on par.

[mtotschnig]

In order to understand if the observed difference is due to the way sqlite-android is build or to a change in sqlite3 itself, I compiled versions 3.36.0 and 3.39.2 of sqlite3 on my Linux workstation, and compared performance of the same query on the same data. They perform the same.

[npurushe]

Thanks for reporting might be related to the jitpack build updates