Page MenuHomePhabricator

Increase Conpherence notification panel transaction fetch
ClosedPublic

Authored by chad on Oct 12 2016, 4:09 PM.
Tags
None
Referenced Files
Unknown Object (File)
Fri, May 3, 7:04 AM
Unknown Object (File)
Thu, Apr 25, 1:25 AM
Unknown Object (File)
Sat, Apr 13, 3:59 AM
Unknown Object (File)
Sat, Apr 13, 3:59 AM
Unknown Object (File)
Sat, Apr 13, 3:54 AM
Unknown Object (File)
Sat, Apr 13, 2:38 AM
Unknown Object (File)
Apr 12 2024, 12:32 AM
Unknown Object (File)
Apr 6 2024, 8:36 PM
Subscribers

Details

Summary

We currently fetch 15 transactions for 5 rooms, which leads to some room subtitles in the notification panel to being blank since nothing was fetched. I don't think this is a great fix, but moves the bar much further. Maybe there is a more accurate fix that isn't 5 SQL queries?

Test Plan

Review notification panel in sandbox, ensure all threads have some additional information.

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

chad retitled this revision from to Increase Conpherence notification panel transaction fetch.
chad updated this object.
chad edited the test plan for this revision. (Show Details)
chad added a reviewer: epriestley.
epriestley edited edge metadata.

Yeah, this is garbage but fixing it isn't trivial. Best would probably be something like this:

  • Put a nullable lastInterestingTransactionPHID (or whatever, that name is kind of wordy) on ConpherenceThread.
  • When writing a transaction, update that field if it's an "interesting" transaction (I personally think only chat is interesting, but there's room for product debate on that).
  • Get rid of needTransactions(), replace it with needLastInterestingTransactions().
  • Do one query to load + attach those specific transactions by PHID.
This revision is now accepted and ready to land.Oct 12 2016, 4:13 PM
This revision was automatically updated to reflect the committed changes.