From 8f44c81b52c8ef5999929c225b3f883d00c157ec Mon Sep 17 00:00:00 2001
From: Mohamed Bassem <me@mbassem.com>
Date: Fri, 8 Nov 2024 23:01:58 +0000
Subject: fix: Fix slow AllTags page because of misconfigured tagId index.
 Fixes #528

---
 packages/db/schema.ts | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'packages/db/schema.ts')

diff --git a/packages/db/schema.ts b/packages/db/schema.ts
index 12255cfb..b3b3759c 100644
--- a/packages/db/schema.ts
+++ b/packages/db/schema.ts
@@ -264,7 +264,7 @@ export const tagsOnBookmarks = sqliteTable(
   },
   (tb) => ({
     pk: primaryKey({ columns: [tb.bookmarkId, tb.tagId] }),
-    tagIdIdx: index("tagsOnBookmarks_tagId_idx").on(tb.bookmarkId),
+    tagIdIdx: index("tagsOnBookmarks_tagId_idx").on(tb.tagId),
     bookmarkIdIdx: index("tagsOnBookmarks_bookmarkId_idx").on(tb.bookmarkId),
   }),
 );
-- 
cgit v1.2.3-70-g09d2