App Works Fine, So Can I Ignore "cursorwindow: Window Is Full: Requested Allocation 12 Bytes, Free Space 4 Bytes, Window Size 2,097,152 Bytes"?

I have a 176,000 word SQLite database and an app that searches it (via an IntentService) and works great, never crashing. Even if thousands of 'hits' are returned, the user can scr

Solution 1:

The application may run fine on your specific device or any current device but you cannot guarantee it will run on older devices. You should definitely not ignore this. The warning you're seeing is requesting more memory, on weaker devices this can cause garbage collection to run and subsequently cause unexpected results in your app.

According to your post a query can be without a pattern thus resulting in all records to be loaded. A ListView can only show an x amount of records (dependent on the device height) Let's say this number is 5 you will only ever see 5 records at a time on screen on a list of 176k. You will never see all these records at once though, so why do you load them all at once? My advice is to LIMIT your query coupled with an endless list implementation.

Change your query to LIMIT 50 meaning you will only get 50 records at a time then add this to your ListView paired with the endless list. Now every time your user scrolls and gets near the end of your current list you run the query to get the next set of 50 records and append it to your list.