diff options
| author | nsfisis <54318333+nsfisis@users.noreply.github.com> | 2026-03-20 12:12:49 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2026-03-20 12:12:49 +0900 |
| commit | b7e43db87b134b19707b70e94b13a72b430c9825 (patch) | |
| tree | afe3044f2d76e6f05e41eb2654b3011d7f7a028a | |
| parent | d8804372262167d248170aea30a4a9ffc2e4ace2 (diff) | |
| parent | 7f06648cf2f5cb63a52465f1b57a081a1ed7e0ea (diff) | |
| download | phperkaigi-2026-albatross-b7e43db87b134b19707b70e94b13a72b430c9825.tar.gz phperkaigi-2026-albatross-b7e43db87b134b19707b70e94b13a72b430c9825.tar.zst phperkaigi-2026-albatross-b7e43db87b134b19707b70e94b13a72b430c9825.zip | |
Merge pull request #13 from nsfisis/claude/limit-results-50-XphjV
Limit submissions query to 50 results for performance
| -rw-r--r-- | backend/db/query.sql.go | 1 | ||||
| -rw-r--r-- | backend/query.sql | 3 |
2 files changed, 3 insertions, 1 deletions
diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 80cbc16..0d1c018 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -709,6 +709,7 @@ const getSubmissionsByGameIDAndUserID = `-- name: GetSubmissionsByGameIDAndUserI SELECT submission_id, game_id, user_id, code, code_size, status, created_at FROM submissions WHERE game_id = $1 AND user_id = $2 ORDER BY created_at DESC +LIMIT 50 ` type GetSubmissionsByGameIDAndUserIDParams struct { diff --git a/backend/query.sql b/backend/query.sql index c791c27..1c0a8fd 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -262,7 +262,8 @@ WHERE testcase_id = $1; -- name: GetSubmissionsByGameIDAndUserID :many SELECT * FROM submissions WHERE game_id = $1 AND user_id = $2 -ORDER BY created_at DESC; +ORDER BY created_at DESC +LIMIT 50; -- name: GetSubmissionsByGameID :many SELECT * |