Currently, we are using ActiveAndroid ORM in our project. We have thousands of records in a single SQLite Table. When we run multiple queries (with conditions) and shows results on the views. Our app hangs, skip android windows frames, the android screen turns black and app does not respond. Following warning are shows
CursorWindow: Window is full: requested allocation 696 bytes, free space 346 bytes, window size 2097152 bytes
We want to run an Asynchronous query in the background and shows the results on the UI Thread.
Is ActiveAndroid provide Asynchronous query, if not can we use parallel ORM like Room/GreenDAO/etc. with ActiveAndroid library Or any other library to run query asynchronously?