]> Sergey Matveev's repositories - public-inbox.git/commit
over: recent: remove expensive COUNT query
authorEric Wong <e@yhbt.net>
Wed, 26 Aug 2020 08:17:40 +0000 (08:17 +0000)
committerEric Wong <e@yhbt.net>
Thu, 27 Aug 2020 10:57:26 +0000 (10:57 +0000)
commitb61b55643c617403f8d141cfe9bff22ad47913f7
treeb8e311bce7a3558a4354a107d51bb09929a41a7b
parent22e7956e56f3a63479b894af0ee4812ff7ae025a
over: recent: remove expensive COUNT query

As noted in commit 87dca6d8d5988c5eb54019cca342450b0b7dd6b7
("www: rework query responses to avoid COUNT in SQLite"),
COUNT on many rows is expensive on big SQLite DBs.

We've already stopped using that code path long ago in WWW
while -imapd and -nntpd never used it.  So we'll adjust our
remaining test cases to not need it, either.
lib/PublicInbox/Over.pm
t/indexlevels-mirror.t
t/v2writable.t
t/watch_maildir_v2.t