In programming it is good to work wisely.
I think loading all the data at the same time is a bad idea since as you can see it clutters the device running it.
Imagine if that is with your PC that has good features vs a not so good computer.
You should create pagination and load a delimited number of data at a time.
This is just a piece of advice, I created an app where I had the same problem until I started working in a segmented way.
You can also try with B4X PreOptimizedCLV:
https://www.b4x.com/android/forum/t...loading-extension-for-xcustomlistview.115289/