From c566f8e4dee128b4d4cdc5c8d6955be338c78f1a Mon Sep 17 00:00:00 2001 From: Stefan Koegl Date: Sun, 5 Sep 2010 17:21:12 +0200 Subject: [PATCH] create db indices for podcast directory --- install/update-37.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/install/update-37.sql b/install/update-37.sql index eda7695e..fdefbb22 100755 --- a/install/update-37.sql +++ b/install/update-37.sql @@ -15,3 +15,9 @@ insert into podcast_tags_tmp (select * from podcast_tags group by tag, podcast_i delete from podcast_tags; insert into podcast_tags (select * from podcast_tags_tmp); + +create index podcast_id on directory_entries (podcast_id); +create index podcast_group_id on directory_entries (podcast_group_id); +create index tag on directory_entries (tag); +create index ranking on directory_entries (ranking); + -- 2.11.4.GIT