cursor.moveToNext() taking long time?

Question

When fatching large no. of records in android sqlite using Cursor.movetoNext() taking more time in Android compare to IOS platform. Is there any way to reduce the time of Cursor.movetoNext() or use something else

I used Cursor resultSet = super.executeSqlAndGetResultSet(sql);

 public Cursor executeSqlAndGetResultSet(String sql) throws Exception{
       DatabaseOps db = DatabaseOps.defaultDatabase();
       Cursor resultSet = db.executeQuery(sql, null); 
       return resultSet;
}

Using cursor.movetoNext() taking long time as compare to IOS in Android

while(cursor.movetoNext()){  
//block to iterate column value of database table.
}

If you are seeing white screen, then you are obviously running the query on the main thread. That is a No-No. You should be using a `CursorLoader` or a `AsyncQueryHandler`, to load. It will be quicker and give your app more responsiveness. — lionscribe, Nov 09 '17 at 06:30
we have 5000+ rows in table and one more thing we used multiple table joins. — Manjeet Singh Goyal, Nov 09 '17 at 06:40
we are not iterating 5000 rows in while loop this 5000 rows in database and query will iterate on the basis of primary id of table but when i execute that query in sqlite it will taking 40ms and on android cursor.movetonext taking 2000ms(2sec) — Manjeet Singh Goyal, Nov 09 '17 at 06:46
but once my cursor object filled with Database record i wanna iterate one by one to get record until my cursor don't have any record. — Manjeet Singh Goyal, Nov 09 '17 at 06:48
with the help of that iteration i made my custom class object list which is used in showing list element. — Manjeet Singh Goyal, Nov 09 '17 at 06:55
Try **indexing** your WHERE and your JOIN fields. It can speed up things up to 400 times faster (empyrically tested). — Phantômaxx, Nov 09 '17 at 07:24
– Bernoulli Gate, we already applied indexing on join columns. But thanks for suggestion — Manjeet Singh Goyal, Nov 09 '17 at 07:26
You mean to say that every call to `movetonext` is taking 2 seconds? You mist have something really wrong in your DB or code! You will have to post your database setup and your SQL. — lionscribe, Nov 09 '17 at 14:04
So, it seems like it takes its time to rebuild the cache every time. — Phantômaxx, Nov 09 '17 at 15:25
Maybe, keeping the journal in memory will speed up things a bit. https://stackoverflow.com/questions/10046596/how-to-disable-android-sqlite-journal-file — Phantômaxx, Nov 10 '17 at 07:32

score 1 · Answer 1 · answered Nov 10 '17 at 08:58

1

I think you have to display data with fast database execution so you can go with custom SimpleCursorAdapter. I hope this approach will help.

Please refer Using custom simpleCursorAdapter

answered Nov 10 '17 at 08:58

hharry_tech

952
1
8
24

no need for a custom `SimpleCursorAdapter` - you can just use it without overriding anything – pskink Nov 10 '17 at 09:29
@pskink, actually i need custom cusor Adapter because i wanna perform lots of operation in my chat module with this i.e. showing date (today, tommorow) etc. – Manjeet Singh Goyal Nov 13 '17 at 07:27
@ManjeetSinghGoyal no, you can use `ViewBinder` for that – pskink Nov 13 '17 at 07:35

cursor.moveToNext() taking long time?

1 Answers1