I have an SQLite database that's 2.4MB. I suspect it's the cause of lots of crashes in my app.
Has anyone included a DB that was as big or bigger? Any issues?
Your code includes row.close(); – that the close for the ResultSet. This is correct; it's important to close the ResultSet when you're finished with it.
However, you should also close the database itself when you've completed all your database operations. In your code above, that would be db.close();
Not sure though if this is related to your problem.
Nope, I don't think it is too big.
Have you checked whether you have close your DB connections at a timely fashion after using?
I have had a very similar problem with a large database. In my specific case, I kept getting errors with rows.isValidRow() where it complained that rows was null. Were you ever able to find a solution for this?
I don't think it should be a problem per se. However I did see issues when testing on Android where some internal limit was being broken when it was trying to copy the db file to the simulator - I have to do it manually instead.