]> Sergey Matveev's repositories - public-inbox.git/commit
www: rework query responses to avoid COUNT in SQLite
authorEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Mon, 2 Apr 2018 00:04:55 +0000 (00:04 +0000)
committerEric Wong (Contractor, The Linux Foundation) <e@80x24.org>
Mon, 2 Apr 2018 00:05:42 +0000 (00:05 +0000)
commit87dca6d8d5988c5eb54019cca342450b0b7dd6b7
treea415a88759b88014d30544addbb69c5949ed76f0
parent3cc5ff405d9054fbf47ac44774fca4f9a72ff65a
www: rework query responses to avoid COUNT in SQLite

In many cases, we do not care about the total number of
messages.  It's a rather expensive operation in SQLite
(Xapian only provides an estimate).

For LKML, this brings top-level /$INBOX/ loading time from
~375ms to around 60ms on my system.  Days ago, this operation
was taking 800-900ms(!) for me before introducing the SQLite
overview DB.
14 files changed:
lib/PublicInbox/Feed.pm
lib/PublicInbox/Mbox.pm
lib/PublicInbox/Over.pm
lib/PublicInbox/Search.pm
lib/PublicInbox/View.pm
t/altid.t
t/convert-compact.t
t/over.t
t/search-thr-index.t
t/search.t
t/v2-add-remove-add.t
t/v2mda.t
t/v2writable.t
t/watch_maildir_v2.t