Slow loading on private-message-topic-tracking-state.json

tgxworld · October 4, 2021, 1:39am

Note that we revert the all inboxes for now because of the performance concerns.

PERF: Revert all inboxes from messages route. (#14445)

committed 03:58AM - 28 Sep 21 UTC

The all inboxes was introduced in 016efeadf6f242e04daf5ef8e18c2ca708a1392d but …we decided to roll it back for performance reasons. The main performance challenge here is that PG has to basically loop through all the PMs that a user is allowed to view before being able to order by `Topic#bumped_at`. The all inboxes was not planned as part of the new/unread filter so we've decided not to tackle the performance issue for the upcoming release. Follow-up to 016efeadf6f242e04daf5ef8e18c2ca708a1392d

Topic		Replies	Views
Slow Profile Loads with 100GB+ database feature	43	2577	January 1, 2021
Slow Page Loads on User Profiles feature	15	2144	November 23, 2020
Very slow Sidekiq issue with large queue due to massive numbers of unread user notifications installation	69	6213	May 11, 2020
Long loading times for user summary page with slow database installation unsupported-install	19	1554	July 13, 2023
Real-time updating of topics freezes under high activity support	89	6512	February 26, 2022

Slow loading on private-message-topic-tracking-state.json

Related Topics