[android-developers] Sqlite android

Hi all i am trying to execute the inner join query like *SELECT * from field where itemid in (select id from item where typeid = 100);* * * *i am using * * * *String [] sqlSelect = {0 _id, value}; * * * *Cursor c = queryBuilder.query(db, sqlSelect, null , null,null, null, null); * * *

[android-developers] SQLite Android Database Cursor window allocation of 2048 kb failed

I have a routine that runs different queries against an SQLite database many times per second. After a while I would get the error android.database.CursorWindowAllocationException: - Cursor window allocation of 2048 kb failed. # Open Cursors = appear in LogCat. I had the app log memory