Load Data on listview-scroll

Load Data on listview-scroll

relating (or lets say due to) to the following topic i am able to handle
the scrolling-event in my ListView: how to make scroll event for listview
In my case i will need this to display about 60k rows on a single page
without using pagination to reduce performance impacts.
My question now is: What would be the best way to handle this / to load my
data dynamically once the scroll event triggers...?
At the moment i am loading about 100 rows on programm-start and add one
row on each scroll-trigger. In the background i am using a simple
LIMIT-SQL stagement.
To be honest this doesn't look very well (you actual can see something is
beeing loaded so it's not smooth) and sometimes it seems to cause some
access validation errors.
So what would be the generel idea to do such things? I might need some
shove in the right direction :-)
Thanks for your assistance.
Best regards Teyhouse