diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-20 13:54:59 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-20 13:54:59 +0900 |
| commit | f27e4033a6599203ba37efe01edbd988699b4068 (patch) | |
| tree | 39249a742055a53c9690f89fdbef8980e48fe01b /src/server/api/endpoints/notes/local-timeline.ts | |
| parent | perf(server): Reduce database query (diff) | |
| download | misskey-f27e4033a6599203ba37efe01edbd988699b4068.tar.gz misskey-f27e4033a6599203ba37efe01edbd988699b4068.tar.bz2 misskey-f27e4033a6599203ba37efe01edbd988699b4068.zip | |
perf(server): Reduce database query
Related: #6813
Diffstat (limited to 'src/server/api/endpoints/notes/local-timeline.ts')
| -rw-r--r-- | src/server/api/endpoints/notes/local-timeline.ts | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/server/api/endpoints/notes/local-timeline.ts b/src/server/api/endpoints/notes/local-timeline.ts index 51e35e6241..31abb26882 100644 --- a/src/server/api/endpoints/notes/local-timeline.ts +++ b/src/server/api/endpoints/notes/local-timeline.ts @@ -98,7 +98,11 @@ export default define(meta, async (ps, user) => { const query = makePaginationQuery(Notes.createQueryBuilder('note'), ps.sinceId, ps.untilId, ps.sinceDate, ps.untilDate) .andWhere('(note.visibility = \'public\') AND (note.userHost IS NULL)') - .leftJoinAndSelect('note.user', 'user'); + .leftJoinAndSelect('note.user', 'user') + .leftJoinAndSelect('note.reply', 'reply') + .leftJoinAndSelect('note.renote', 'renote') + .leftJoinAndSelect('reply.user', 'replyUser') + .leftJoinAndSelect('renote.user', 'renoteUser'); generateChannelQuery(query, user); generateRepliesQuery(query, user); |