From e66bba3317c51b1c9d89bcef706d05b82c7148ec Mon Sep 17 00:00:00 2001 From: nsfisis Date: Fri, 21 Mar 2025 09:52:26 +0900 Subject: feat(backend): limit ranking entries --- backend/query.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'backend') diff --git a/backend/query.sql b/backend/query.sql index c052718..32f9273 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -130,7 +130,8 @@ FROM game_states JOIN users ON game_states.user_id = users.user_id JOIN submissions ON game_states.best_score_submission_id = submissions.submission_id WHERE game_states.game_id = $1 -ORDER BY submissions.code_size ASC, submissions.created_at ASC; +ORDER BY submissions.code_size ASC, submissions.created_at ASC +LIMIT 30; -- name: GetQualifyingRanking :many SELECT -- cgit v1.2.3-70-g09d2