Re: [sqlite] Sqlite Query Optimization (using Limit and Offset)

sattu wrote: > select * from myTable LIMIT 100 OFFSET 0 //Execution Time is less than > 1sec > select * from myTable LIMIT 100 OFFSET 95000 //Execution Time is almost > 15secs http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor -- Igor Tandetnik

Re: [sqlite] Sqlite Query Optimization (using Limit and Offset)

On 4 Sep 2012, at 3:56pm, sattu wrote: > What I observed is, if the offset is very high like say 9, then it takes > more time for the query to execute. Following is the time difference between > 2 queries with different offsets: > > > select * from myTable LIMIT

[sqlite] Sqlite Query Optimization (using Limit and Offset)

should be same and fast for any number of records I wish to retrieve from any OFFSET. -Thanks in advance -- View this message in context: http://sqlite.1065341.n5.nabble.com/Sqlite-Query-Optimization-using-Limit-and-Offset-tp64000.html Sent from the SQLite mailing list archive at Nabble.com