diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2023-10-19 09:20:19 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2023-10-19 09:20:19 +0900 |
| commit | 1671575d5d3d081c83f172f3439884010aafeb59 (patch) | |
| tree | 662c64008c53d3290269ed5b69ceb8e773d60837 /packages/backend/src/models | |
| parent | perf(backend): improve my reaction population performance (diff) | |
| download | misskey-1671575d5d3d081c83f172f3439884010aafeb59.tar.gz misskey-1671575d5d3d081c83f172f3439884010aafeb59.tar.bz2 misskey-1671575d5d3d081c83f172f3439884010aafeb59.zip | |
perf(backend): ノートのリアクション情報をキャッシュすることでDBへのクエリを削減
Diffstat (limited to 'packages/backend/src/models')
| -rw-r--r-- | packages/backend/src/models/Note.ts | 5 | ||||
| -rw-r--r-- | packages/backend/src/models/json-schema/note.ts | 8 |
2 files changed, 13 insertions, 0 deletions
diff --git a/packages/backend/src/models/Note.ts b/packages/backend/src/models/Note.ts index ac7f57d5d6..a4358b9ba6 100644 --- a/packages/backend/src/models/Note.ts +++ b/packages/backend/src/models/Note.ts @@ -165,6 +165,11 @@ export class MiNote { public mentionedRemoteUsers: string; @Column('varchar', { + length: 1024, array: true, default: '{}', + }) + public reactionAndUserPairCache: string[]; + + @Column('varchar', { length: 128, array: true, default: '{}', }) public emojis: string[]; diff --git a/packages/backend/src/models/json-schema/note.ts b/packages/backend/src/models/json-schema/note.ts index 2caf0d0c3d..38c0054b55 100644 --- a/packages/backend/src/models/json-schema/note.ts +++ b/packages/backend/src/models/json-schema/note.ts @@ -174,6 +174,14 @@ export const packedNoteSchema = { type: 'string', optional: true, nullable: false, }, + reactionAndUserPairCache: { + type: 'array', + optional: true, nullable: false, + items: { + type: 'string', + optional: false, nullable: false, + }, + }, myReaction: { type: 'object', |