]> Sergey Matveev's repositories - public-inbox.git/commit
projects / public-inbox.git / commit
summary | shortlog | log | commit | commitdiff | tree
(parent: f91753f) | patch
view: avoid offset during pagination
authorEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Tue, 3 Apr 2018 11:09:09 +0000 (11:09 +0000)
committerEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Tue, 3 Apr 2018 12:06:13 +0000 (12:06 +0000)
commitb9534449ecce2c59bb4aebad6051f91c3116b187
treeb355db7453fb8916a8b480d35b2ea8fccee78844tree
parentf91753f00b760c0e06eb0384792e5b18bd99bb0fcommit | diff
view: avoid offset during pagination

OFFSET in SQLite gets painful to deal with.  Instead,
rely on timestamps (from Received:) for pagination.
This also sets us up for more precise Date searching
in case we want it.
lib/PublicInbox/Feed.pm diff | blob | history
lib/PublicInbox/Inbox.pm diff | blob | history
lib/PublicInbox/Over.pm diff | blob | history
lib/PublicInbox/View.pm diff | blob | history
My patches to https://public-inbox.org/public-inbox.git