Android Question Connect recycleview to SQLite in b4a

[nazarixxxxx123]

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.

 

[DonManfred]

Forget Recyclerview.
No one ever want to scroll through a list of millions datasets.

You should filter the items based on usersearch or limit the results.

XCustomlistview will work though. You may redefine your wanted results

 

[Alexander Stolte]

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.

 

[nazarixxxxx123]

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.

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?

 

[Alexander Stolte]

What do you think I should do in the search?

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.