]> Sergey Matveev's repositories - public-inbox.git/commit
projects / public-inbox.git / commit
summary | shortlog | log | commit | commitdiff | tree
(parent: 87dca6d) | patch
over: speedup get_thread by avoiding JOIN
authorEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Mon, 2 Apr 2018 00:04:56 +0000 (00:04 +0000)
committerEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Mon, 2 Apr 2018 00:05:43 +0000 (00:05 +0000)
commit5a44b89fd9f4ef2688b91262736b0f61095ae99c
treef5b3937f387679d277f617cbfeb6c7dc75fac717tree
parent87dca6d8d5988c5eb54019cca342450b0b7dd6b7commit | diff
over: speedup get_thread by avoiding JOIN

JOIN operations on SQLite can be disasterously slow.
This reduces per-message pages with the thread overview
at the bottom of those pages from over 800ms to ~60ms.
In comparison, the v1 code took around 70-80ms using
Xapian on my machine.
lib/PublicInbox/Over.pm diff | blob | history
My patches to https://public-inbox.org/public-inbox.git