Re: [sqlite] SQLite - SELECT query slowing down while fetching from higher offset.

2017-02-01 Thread Keith Medcalf
> When I have 1 records in the table, it takes 20 ms to fetch 10 items > from offset 0, and it increases to 220 ms to fetch 10 items from offset > 9900. > While I have 2 records in the table, it takes 20 ms to fetch 10 items > from offset 0, 440 ms for 10 items from offset 9600 and 720

Re: [sqlite] SQLite - SELECT query slowing down while fetching from higher offset.

2017-02-01 Thread Jens Alfke
> On Feb 1, 2017, at 7:18 AM, Richard Hipp wrote: > > See also https://www.sqlite.org/rowvalue.html#scrolling_window_queries > This approach comes with a major caveat that’s not mentioned in the text: the data

Re: [sqlite] SQLite - SELECT query slowing down while fetching from higher offset.

2017-02-01 Thread Richard Hipp
On 2/1/17, Igor Tandetnik wrote: > On 2/1/2017 9:50 AM, Anthrathodiyil, Sabeel (S.) wrote: >> I am facing issue with SQLite performance when having more records in the >> table and fetching from higher offsets > > https://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor See also

Re: [sqlite] SQLite - SELECT query slowing down while fetching from higher offset.

2017-02-01 Thread Igor Tandetnik
On 2/1/2017 9:50 AM, Anthrathodiyil, Sabeel (S.) wrote: I am facing issue with SQLite performance when having more records in the table and fetching from higher offsets https://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor Performance of a query with OFFSET N is roughly equivalent to that

Re: [sqlite] SQLite - SELECT query slowing down while fetching from higher offset.

2017-02-01 Thread Simon Slavin
On 1 Feb 2017, at 2:50pm, Anthrathodiyil, Sabeel (S.) wrote: > When I have 1 records in the table, it takes 20 ms to fetch 10 items > from offset 0, and it increases to 220 ms to fetch 10 items from offset 9900. > While I have 2 records in the table, it takes 20

[sqlite] SQLite - SELECT query slowing down while fetching from higher offset.

2017-02-01 Thread Anthrathodiyil, Sabeel (S.)
Hi, I am facing issue with SQLite performance when having more records in the table and fetching from higher offsets, though I have proper index in place. Using SQLite version 3.7.10 running on ARM Cortex A5 processor. Here is my schema (relevant table and index) and query CREATE TABLE