From ebe3c9130d101fb5c5ec4007eef3ed78716d840b Mon Sep 17 00:00:00 2001 From: Frank Karlitschek Date: Sat, 24 Nov 2012 20:58:51 +0100 Subject: add a few more indexes. This is just a first step. More work is needed here but this should improve perfomance already for big installations. --- db_structure.xml | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) diff --git a/db_structure.xml b/db_structure.xml index 851c8aa998d..e1080cd2358 100644 --- a/db_structure.xml +++ b/db_structure.xml @@ -46,6 +46,13 @@ ascending + + appconfig_config_key_index + + configkey + ascending + + @@ -257,6 +264,13 @@ true 64 + + group_admin_uid + + uid + ascending + + @@ -580,6 +594,21 @@ false + + share_file_target_index + + file_target + ascending + + + uid_owner + ascending + + + share_type + ascending + + -- cgit v1.2.3 From f712ca61dfdec7ed80d405115d6eb48e405fe894 Mon Sep 17 00:00:00 2001 From: Frank Karlitschek Date: Sun, 25 Nov 2012 15:09:07 +0100 Subject: remove the index on the share table because of problems with the index size. Thanks to icewind for spotting this. --- db_structure.xml | 15 --------------- 1 file changed, 15 deletions(-) diff --git a/db_structure.xml b/db_structure.xml index e1080cd2358..e1da6448c8f 100644 --- a/db_structure.xml +++ b/db_structure.xml @@ -594,21 +594,6 @@ false - - share_file_target_index - - file_target - ascending - - - uid_owner - ascending - - - share_type - ascending - - -- cgit v1.2.3