Article: Pagination and OFFSET

An interesting post on why OFFSET is bad: http://use-the-index-luke.com/no-offset

Also it provides a smarter way to paginate. In short, keep a last_seen_id and simply select "where id < last_seen_id".