| Date | Commit message (Collapse) | ||
|---|---|---|---|
| 2018-04-07 | 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. | |||
| 2018-04-03 | nntp: make XOVER, XHDR, OVER, HDR and NEWNEWS faster | ||
| While SQLite is faster than Xapian for some queries we use, it sucks at handling OFFSET. Fortunately, we do not need offsets when retrieving sorted results and can bake it into the query. For inbox.comp.version-control.git (v1 Xapian), XOVER and XHDR are over 20x faster. | |||