Append rows while scrolling down

You must Login before you can answer or comment on any questions.

Hi all, I have 8000+ records in my SQLite database. The title of the rows are taken from database. I have this hierarchy : Tableview -- > -- > TablevviewRow -- > Label

So the text of the label is imported from the database. But the problem that when i launch my application, all records are set to my tableview data. Anyone can help me to load data while scrolling down? So when the app starts, not all records are imported, just when the user scroll down, the tableview rows will append consecutively. This may help me to have perfect performance. 10x

1 Answer

Accepted Answer

What you can do is, use limit when querying data from your database like 20-50 etc whatever you prefer best. Than you can maintain that numbers, start number of record in variable, so when user scroll down at the end of table view you can call that database function which will return next 20-50 rows and than you can just append than row to your tableview.

Your Answer

Think you can help? Login to answer this question!