Re: [sqlite] SQLite3.Step fast forward / skipping rows

Like this it works. OK, building the temporary table takes some seconds with a table of 10 mio records, but the queries are really fast then, 10 to 30 ms!! Thanks so much guys for helping me with this :) Tom Am 24.05.2017 um 18:42 schrieb Keith Medcalf: On Wednesday, 24 May, 2017 07:21

Re: [sqlite] SQLite3.Step fast forward / skipping rows

On Wednesday, 24 May, 2017 07:21 > > there is no system in existence that will do > I was working a lot with Valentina-DB and they have a cursor class: > > var cursor=database.SqlSelect( "SELECT... WHERE... ORDER..."); > > then you can just get any the ListView wants, forward and backwards,

Re: [sqlite] SQLite3.Step fast forward / skipping rows

nal Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory, then th

Re: [sqlite] SQLite3.Step fast forward / skipping rows

On 5/24/17, Thomas Flemming wrote: > Hi Ron, > > > there is no system in existence that will do > I was working a lot with Valentina-DB and they have a cursor class: > > var cursor=database.SqlSelect( "SELECT... WHERE... ORDER..."); > > then you can just get any the ListView

Re: [sqlite] SQLite3.Step fast forward / skipping rows

f Of Thomas Flemming Sent: Wed 24 May 2017 14:21 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Hi Ron, > there is no system in existence that will do I was working a lot with Valentina-DB and they have a cursor class: var cursor=data

Re: [sqlite] SQLite3.Step fast forward / skipping rows

ge- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory, then the use cas

Re: [sqlite] SQLite3.Step fast forward / skipping rows

4 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory, then the use case of fast scrolling down in a listbox would be going directly to page 800 and not going to "Smit

Re: [sqlite] SQLite3.Step fast forward / skipping rows

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,

Re: [sqlite] SQLite3.Step fast forward / skipping rows

te-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory, then the use case of fast scrolling down in a

Re: [sqlite] SQLite3.Step fast forward / skipping rows

t page of results. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Thomas Flemming Gesendet: Mittwoch, 24. Mai 2017 10:09 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] SQLite3.Step fast forward / skipping rows Hi

Re: [sqlite] SQLite3.Step fast forward / skipping rows

age- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Thomas Flemming Sent: Wed 24 May 2017 10:37 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows Almost, but when you compare to a telephone directory, then

Re: [sqlite] SQLite3.Step fast forward / skipping rows

:09 To:sqlite-users@mailinglists.sqlite.org Subject: [sqlite] SQLite3.Step fast forward / skipping rows Hi SQLite Users, I have a SELECT query, which returns some 10 records and is displayed in a scrollable ListView. When the user scrolls down the list, each new row is loaded with SQLite3.Step(). The probl

Re: [sqlite] SQLite3.Step fast forward / skipping rows

te.org > Subject: [sqlite] SQLite3.Step fast forward / skipping rows > > Hi SQLite Users, > > > I have a SELECT query, which returns some 10 records and is displayed > in a > scrollable ListView. > > When the user scrolls down the list, each new row is loaded wi

[sqlite] SQLite3.Step fast forward / skipping rows

Hi SQLite Users, I have a SELECT query, which returns some 10 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,