From e66bba3317c51b1c9d89bcef706d05b82c7148ec Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
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/query.sql')

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.3.1

