The item list and feed list wait on queries one at a time that could run together #346
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
entry_page (web.rs) runs the page's query and then its count: about 40 ms and 24 ms on /api/entries, the busiest route (7128 calls in 7 days, p95 404 ms). feed_list (db.rs) runs five independent queries in turn: entries 13 ms, downloaded 2, unread 32, blocked 0, feeds 12, 59 ms of a 67 ms /api/feeds. The pool has 20 connections, all idle. Run them with try_join: the count beside the list, and feed_list's five at once, about 32 ms.
Fixed in
21fa0ae: entry_page runs the list and its count with try_join, and feed_list its five queries at once. Deployed; /api/feeds 98 ms, /api/entries 37-52 ms on production.