From eadaf52eac610bb5c90586ddad3c7074255268b6 Mon Sep 17 00:00:00 2001 From: Melvyn Harbour Date: Tue, 18 Jun 2024 15:35:37 +0100 Subject: [PATCH] Add index on timestamp_added (#1381) --- music_assistant/server/controllers/music.py | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/music_assistant/server/controllers/music.py b/music_assistant/server/controllers/music.py index 575fee31..07db9324 100644 --- a/music_assistant/server/controllers/music.py +++ b/music_assistant/server/controllers/music.py @@ -1108,6 +1108,11 @@ class MusicController(CoreController): await self.database.execute( f"CREATE INDEX IF NOT EXISTS {db_table}_external_ids_idx on {db_table}(external_ids);" # noqa: E501 ) + # index on timestamp_added + await self.database.execute( + f"CREATE INDEX IF NOT EXISTS {db_table}_timestamp_added_idx " + f"on {db_table}(timestamp_added);" + ) # indexes on provider_mappings table await self.database.execute( -- 2.34.1