]> Sergey Matveev's repositories - public-inbox.git/commit
projects / public-inbox.git / commit
summary | shortlog | log | commit | commitdiff | tree
(parent: 3348ad4) | patch
msgmap: speed up minmax with separate queries
authorEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Sat, 7 Apr 2018 03:41:54 +0000 (03:41 +0000)
committerEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Sat, 7 Apr 2018 03:42:30 +0000 (03:42 +0000)
commit74b92712fa7a21fe504b9908edebcf11bb9dc170
treecf4abdc1b8d8a64151fdcbacd095942fa227ff8etree
parent3348ad4b3b1a0865ee58a902953165ea0f4aa4bdcommit | diff
msgmap: speed up minmax with separate queries

This significantly improves the performance of the NNTP GROUP
command with 2.7 million messages from over 250ms to 700us.
SQLite is weird about this, but at least there's a way to
optimize it.
lib/PublicInbox/Msgmap.pm diff | blob | history
t/perf-nntpd.t diff | blob | history
My patches to https://public-inbox.org/public-inbox.git