Sergey Matveev's repositories - public-inbox.git/commit

]> Sergey Matveev's repositories - public-inbox.git/commit

author	Eric Wong (Contractor, The Linux Foundation) <e@80x24.org>
	Tue, 3 Apr 2018 11:09:08 +0000 (11:09 +0000)
committer	Eric Wong (Contractor, The Linux Foundation) <e@80x24.org>
	Tue, 3 Apr 2018 12:06:11 +0000 (12:06 +0000)
commit	f91753f00b760c0e06eb0384792e5b18bd99bb0f
tree	2cc2f60b629b4947fcd4a02c39c7cfc688c2c243	tree
parent	e932bd748750234331d5664873272e0cb7ba6025	commit \| diff

nntp: make XOVER, XHDR, OVER, HDR and NEWNEWS faster

While SQLite is faster than Xapian for some queries we
use, it sucks at handling OFFSET. Fortunately, we do
not need offsets when retrieving sorted results and
can bake it into the query.

For inbox.comp.version-control.git (v1 Xapian),
XOVER and XHDR are over 20x faster.

MANIFEST		diff \| blob \| history
lib/PublicInbox/NNTP.pm		diff \| blob \| history
lib/PublicInbox/Over.pm		diff \| blob \| history
lib/PublicInbox/Search.pm		diff \| blob \| history
t/perf-nntpd.t	[new file with mode: 0644]	blob

My patches to https://public-inbox.org/public-inbox.git

RSS Atom