Android Question Connect recycleview to SQLite in b4a

nazarixxxxx123

Member
Hello
In your opinion, how can I connect to SQLite with Recycler View? I tried a lot to find a solution for it, but it didn't work.

The problem was found because I have a table in SQLite that has nearly a million items and list view, custom list view... cannot display these values. That's why I need your help.

Please help
Thank you a lot.
 
Sort by date Sort by votes

Alexander Stolte

Expert
Licensed User
Longtime User
Load the first 400 data records and when the user has reached the 300th data record, simply load the next 400 data records in the background. However, I do not assume that any user scrolls more than 50 items at all.
 
Upvote 0

nazarixxxxx123

Member
Alexander Stolte said:
Load the first 400 data records and when the user has reached the 300th data record, simply load the next 400 data records in the background. However, I do not assume that any user scrolls more than 50 items at all.
Click to expand...
Thank you for your answer. What do you think I should do in the search? When the search is done, I think it should read information from the entire table, and this slows down the program. Do you have a solution?
 
Upvote 0

Alexander Stolte

Expert
Licensed User
Longtime User
nazarixxxxx123 said:
What do you think I should do in the search?
Click to expand...
Search your SQLite database for the things the user is looking for and add them to the list. Empty the list first.
But that's another question that should be asked in another thread.
 
Upvote 0
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…