diff options
| author | Hazelnoot <acomputerdog@gmail.com> | 2025-06-02 17:28:48 -0400 |
|---|---|---|
| committer | Hazelnoot <acomputerdog@gmail.com> | 2025-06-02 17:28:48 -0400 |
| commit | 022c49f45f1e00a2b7b04040be28420247ebb6ea (patch) | |
| tree | 983cb39ecd86e01c76de2ff7bd66a26584bcf355 /packages/backend/src/server/api/endpoints/notes | |
| parent | remove unnecessary call to generateVisibilityQuery in bubble-timeline.ts (diff) | |
| download | sharkey-022c49f45f1e00a2b7b04040be28420247ebb6ea.tar.gz sharkey-022c49f45f1e00a2b7b04040be28420247ebb6ea.tar.bz2 sharkey-022c49f45f1e00a2b7b04040be28420247ebb6ea.zip | |
fix query slowdown caused by unnecessary userHost IS NOT NULL condition in bubble-timeline.ts
Diffstat (limited to 'packages/backend/src/server/api/endpoints/notes')
| -rw-r--r-- | packages/backend/src/server/api/endpoints/notes/bubble-timeline.ts | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/packages/backend/src/server/api/endpoints/notes/bubble-timeline.ts b/packages/backend/src/server/api/endpoints/notes/bubble-timeline.ts index 1ef57a14a2..ef3502de77 100644 --- a/packages/backend/src/server/api/endpoints/notes/bubble-timeline.ts +++ b/packages/backend/src/server/api/endpoints/notes/bubble-timeline.ts @@ -83,7 +83,6 @@ export default class extends Endpoint<typeof meta, typeof paramDef> { // eslint- ps.sinceId, ps.untilId, ps.sinceDate, ps.untilDate) .andWhere('note.visibility = \'public\'') .andWhere('note.channelId IS NULL') - .andWhere('note.userHost IS NOT NULL') .andWhere('userInstance.isBubbled = true') // This comes from generateBlockedHostQueryForNote below .innerJoinAndSelect('note.user', 'user') .leftJoinAndSelect('note.reply', 'reply') |