Alex Vandiver 325ff11ecf soft_deactivation: Stop computing "new messages" in Python. ...

Rather than fetch all UserMessage rows for all streams, and subtract
those out in Python-space from the list of all Message rows the user
may have received -- do this via a "NOT EXISTS" subquery.  This is
much better indexed (performing in fractions of milliseconds rather
than hundreds), and also consumes much less memory.

2023-09-29 10:26:04 -07:00

18 KiB

Raw Permalink Blame History

View Raw