I might be wrong, but to me this sounds like an application coding problem to do with your listview. You will need to code in such a way that the listview doesn't get updated when it doesn' t have to. Does the data come directly from the DB or is there an intermediate eg an array?
RBS On Wed, May 24, 2017 at 9:09 AM, Thomas Flemming <t...@qvgps.com> wrote: > Hi SQLite Users, > > > I have a SELECT query, which returns some 100000 records and is displayed > in a scrollable ListView. > > When the user scrolls down the list, each new row is loaded with > SQLite3.Step(). > > The problem is, when the user scrolls fast with the scroll-slider, lots of > rows are skipped, but SQLite still needs to load them all with SQLite3.Step > until it reaches the row which is actually needed. This is very slow. > > Is there a way to skip all these unnecessary rows? For example going > directly from row 1000 to row 100000 ? I tried SELECT ... OFFSET 100000 but > this is also very slow the more down we go. > > Thanks > Tom > > > -- > /**************************************** > ** Flemming Software Development CC > ** Thomas Flemming > ** PO Box 81244 > ** Windhoek, Namibia > ** http://www.quovadis-gps.com > ** mail t...@qvgps.com > ** +264 (0)81 3329923 > ** +49 (0)6182 8492599 > ***************************************/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users