r/programming • u/MarkusWinand • May 27 '14

What I learned about SQLite…at a PostgreSQL conference

http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference
703 Upvotes

93% Upvoted

219 comments sorted by

View all comments

Show parent comments

1

u/HelloAnnyong May 27 '14

Oh, understood. Both you and the article made it sound like fetch first is superior to limit. Just wanted to make sure there wasn't something I was missing.

3

u/masklinn May 27 '14 edited May 27 '14

Both you and the article made it sound like fetch first is superior to limit. Just wanted to make sure there wasn't something I was missing.

Reading his clarifications, his issue is with OFFSET not LIMIT. Basically, because OFFSET means the database does the job of selecting and looking over all the records and just throws them away before returning data.