]> Sergey Matveev's repositories - public-inbox.git/commit
searchview: speed up search summary by ~10%
authorEric Wong <e@yhbt.net>
Thu, 20 Aug 2020 20:24:50 +0000 (20:24 +0000)
committerEric Wong <e@yhbt.net>
Thu, 20 Aug 2020 21:11:18 +0000 (21:11 +0000)
commit5a69dffc4155c8810dd8f2f3474f7a8a5c6d16a2
tree4f2bea8a7bd03dd46a663f5e04cccebf19977d90
parentc703745bcd09af545ef1bd320c895778081488d2
searchview: speed up search summary by ~10%

Instead of loading one article at-a-time from over.sqlite3, we
can use SQL to mass-load IN (?,?, ...) all results with a single
SQLite query.  Despite SQLite being in-process and having no
network latency, the reduction in SQL query executions from
loading multiple rows at once speeds things up significantly.

We'll keep the over->get_art optimizations from the previous
commit, since it still speeds up long-lived responses, slightly.
lib/PublicInbox/Over.pm
lib/PublicInbox/SearchView.pm