]> Sergey Matveev's repositories - public-inbox.git/commit
projects / public-inbox.git / commit
summary | shortlog | log | commit | commitdiff | tree
(parent: 24e103d) | patch
nntp: speed up mid_lookup() using ->ALL extindex
authorEric Wong <e@80x24.org>
Sat, 28 Nov 2020 05:09:13 +0000 (05:09 +0000)
committerEric Wong <e@80x24.org>
Sun, 29 Nov 2020 02:25:49 +0000 (02:25 +0000)
commit96aa41ea2abe5ee03404b043d428d9bfee3def50
treefa84ad1a509252dc1ccda701ca19712994b9b66atree
parent24e103d37b423c1c718e7f0f6285419005a98be5commit | diff
nntp: speed up mid_lookup() using ->ALL extindex

We can reuse "xref3" information in extindex to quickly match
messages matching a given Message-ID across hundreds or
thousands of newsgroups with a few SQL statements.

"XHDR Xref $MESSAGE_ID" is around 40% faster, on top of
previous speedups.
lib/PublicInbox/NNTP.pm diff | blob | history
My patches to https://public-inbox.org/public-inbox.git