diff options
| author | Ezekiel Lee <80657402+zekexy@users.noreply.github.com> | 2023-09-08 07:44:46 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-09-08 08:44:46 +0900 |
| commit | af7e129b1eeecd196cdb14b9221c94959eacca85 (patch) | |
| tree | 1bdc3a56311cfb16f37f01fcbd7334f63c143de1 /packages/backend/src/server/api/endpoints/notes | |
| parent | 2023.9.0-beta.4 (diff) | |
| download | sharkey-af7e129b1eeecd196cdb14b9221c94959eacca85.tar.gz sharkey-af7e129b1eeecd196cdb14b9221c94959eacca85.tar.bz2 sharkey-af7e129b1eeecd196cdb14b9221c94959eacca85.zip | |
fix(backend): timeout when querying mentions (#11799)
Diffstat (limited to 'packages/backend/src/server/api/endpoints/notes')
| -rw-r--r-- | packages/backend/src/server/api/endpoints/notes/mentions.ts | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/packages/backend/src/server/api/endpoints/notes/mentions.ts b/packages/backend/src/server/api/endpoints/notes/mentions.ts index 0d5cb1130a..6afe13be6f 100644 --- a/packages/backend/src/server/api/endpoints/notes/mentions.ts +++ b/packages/backend/src/server/api/endpoints/notes/mentions.ts @@ -63,6 +63,8 @@ export default class extends Endpoint<typeof meta, typeof paramDef> { // eslint- .where(`'{"${me.id}"}' <@ note.mentions`) .orWhere(`'{"${me.id}"}' <@ note.visibleUserIds`); })) + // Avoid scanning primary key index + .orderBy('CONCAT(note.id)', 'DESC') .innerJoinAndSelect('note.user', 'user') .leftJoinAndSelect('note.reply', 'reply') .leftJoinAndSelect('note.renote', 'renote') |