From 6f2e93c6a17a0aca30da6590e66e3b60f67efe4e Mon Sep 17 00:00:00 2001 From: syuilo Date: Mon, 21 Mar 2022 05:21:37 +0900 Subject: perf(server): reduce db query --- packages/backend/src/server/activitypub/outbox.ts | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'packages/backend/src/server/activitypub/outbox.ts') diff --git a/packages/backend/src/server/activitypub/outbox.ts b/packages/backend/src/server/activitypub/outbox.ts index 57c126752a..db2a18efcd 100644 --- a/packages/backend/src/server/activitypub/outbox.ts +++ b/packages/backend/src/server/activitypub/outbox.ts @@ -15,6 +15,7 @@ import { Users, Notes } from '@/models/index.js'; import { makePaginationQuery } from '../api/common/make-pagination-query.js'; import { Brackets } from 'typeorm'; import { Note } from '@/models/entities/note.js'; +import { userCache } from './cache.js'; export default async (ctx: Router.RouterContext) => { const userId = ctx.params.user; @@ -35,11 +36,11 @@ export default async (ctx: Router.RouterContext) => { return; } - // Verify user - const user = await Users.findOne({ + // TODO: typeorm 3.0にしたら .then(x => x || null) は消せる + const user = await userCache.fetch(userId, () => Users.findOne({ id: userId, host: null, - }); + }).then(x => x || null)); if (user == null) { ctx.status = 404; -- cgit v1.2.3-freya