diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-21 10:41:21 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-21 10:41:21 +0900 |
| commit | e987a50e9fc7bee1b86840cee15a6c86d2d1525d (patch) | |
| tree | c496fe84a862387c60a5e36c012fbd325b63340d /src/server | |
| parent | fix(server): Use inner join (diff) | |
| download | sharkey-e987a50e9fc7bee1b86840cee15a6c86d2d1525d.tar.gz sharkey-e987a50e9fc7bee1b86840cee15a6c86d2d1525d.tar.bz2 sharkey-e987a50e9fc7bee1b86840cee15a6c86d2d1525d.zip | |
perf(server): Improve following/followers API performance
Related #6813
Diffstat (limited to 'src/server')
| -rw-r--r-- | src/server/api/endpoints/users/followers.ts | 3 | ||||
| -rw-r--r-- | src/server/api/endpoints/users/following.ts | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/src/server/api/endpoints/users/followers.ts b/src/server/api/endpoints/users/followers.ts index bd4a2739c6..fb83d7beb8 100644 --- a/src/server/api/endpoints/users/followers.ts +++ b/src/server/api/endpoints/users/followers.ts @@ -76,7 +76,8 @@ export default define(meta, async (ps, me) => { } const query = makePaginationQuery(Followings.createQueryBuilder('following'), ps.sinceId, ps.untilId) - .andWhere(`following.followeeId = :userId`, { userId: user.id }); + .andWhere(`following.followeeId = :userId`, { userId: user.id }) + .innerJoinAndSelect('following.follower', 'follower'); const followings = await query .take(ps.limit!) diff --git a/src/server/api/endpoints/users/following.ts b/src/server/api/endpoints/users/following.ts index 9efb8bfc93..d5e8dc1f92 100644 --- a/src/server/api/endpoints/users/following.ts +++ b/src/server/api/endpoints/users/following.ts @@ -76,7 +76,8 @@ export default define(meta, async (ps, me) => { } const query = makePaginationQuery(Followings.createQueryBuilder('following'), ps.sinceId, ps.untilId) - .andWhere(`following.followerId = :userId`, { userId: user.id }); + .andWhere(`following.followerId = :userId`, { userId: user.id }) + .innerJoinAndSelect('following.followee', 'followee'); const followings = await query .take(ps.limit!) |