Android RecyclerView with 1000s of data

Question

I have a Sqlite db file which have 1000's of records which I want to display with RecyclerView. If I fetch the data and store them in a List it takes 10s to loop through all the data. Then when I assign this List to RecyclerView data adapter, it takes almost 10 extra seconds to cache the data for displaying. So its spending about 20s in this entire process.

Is there any why to directly connect the SQLite db query cursor with RecyclerView, so it can display data one by one instead of retrieving all 1000s of data and cache it?

Please show your code because it easy for RecyclerView to handle just 1000 items. — Jing, Nov 19 '16 at 06:55
yes easy, but if you have to handle images inside the list, it´s a little bit more advanced task — Opiatefuchs, Nov 19 '16 at 07:15
@codelearner I took a test with 700,000 items on android Recyclerview sample, and found that it took nearly 0 second to fill the Recyclerview. Thus i'm sure it's not Recyclerview's problem. Perhaps, it was because of sqlite. — Jing, Nov 20 '16 at 15:13
@Jing thanks for your input and test... After revising my code the execution time has reduced from ~20s to only about ~500ms. — codelearner, Nov 21 '16 at 05:13

score 4 · Answer 1 · edited May 23 '17 at 10:32

4

You should use pagination for these cases.you can use queries like this :

SELECT * FROM YOUR_TABLE LIMIT 10 OFFSET 0 //for page #1
SELECT * FROM YOUR_TABLE LIMIT 10 OFFSET 10 // for page #2

and check this url to implementing pagination : How to implement endless list with RecyclerView?

edited May 23 '17 at 10:32

Community

1
1

answered Nov 19 '16 at 06:51

Reza.Abedini

2,227
2
16
18

score 0 · Answer 2 · answered Nov 19 '16 at 06:40

0

Try to show the view with load more, like when user scrolls down then load the data..

answered Nov 19 '16 at 06:40

Manoj Vayu

99
6

score 0 · Answer 3 · answered Nov 19 '16 at 06:53

0

I agree with Manoj.... Show some items and as the users keeps scrolling load and add next items to the list and use notifyDataSetChanged().this will help you

answered Nov 19 '16 at 06:53

Arpan Sharma

2,142
11
22

Android RecyclerView with 1000s of data

3 Answers3