Details
I started this task by testing various queries in the production environment to check performance.
After implementing the change, I used this patch to check performance on the JS side in my dev environment, and to output raw queries so I could test their performance in production: https://gist.github.com/Ashoat/220bb35da34ac7820867ac874d87beab
I found that for all users other than me, this change significantly sped up fetchThreadInfos.
I then deployed this to production to test performance more reliably. Hopefully so far no issues!
Diff Detail
- Repository
- rCOMM Comm
- Lint
Lint Not Applicable - Unit
Tests Not Applicable
We could probably go back to using isPinned property here. The thing we undid in D8097. This would make the code more readable, but it's up to you