custom query take so long even with paging in room android
I am fetching data from three tables in an Android app. The query works fine to return what is needed but it takes around 5 seconds to fetch data every time the user refreshes it.
Tables are indexed as well, but it still takes too much time.