diff options
author | Frank Karlitschek <frank@owncloud.org> | 2012-11-24 23:58:51 +0400 |
---|---|---|
committer | Frank Karlitschek <frank@owncloud.org> | 2012-11-24 23:58:51 +0400 |
commit | ebe3c9130d101fb5c5ec4007eef3ed78716d840b (patch) | |
tree | 999cb409c15163c14b50cd88dac27c5f146c1743 | |
parent | 9b630f57d069d518b5d3343738169140a14d3269 (diff) |
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.
-rw-r--r-- | db_structure.xml | 29 |
1 files changed, 29 insertions, 0 deletions
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 @@ <sorting>ascending</sorting> </field> </index> + <index> + <name>appconfig_config_key_index</name> + <field> + <name>configkey</name> + <sorting>ascending</sorting> + </field> + </index> </declaration> @@ -257,6 +264,13 @@ <notnull>true</notnull> <length>64</length> </field> + <index> + <name>group_admin_uid</name> + <field> + <name>uid</name> + <sorting>ascending</sorting> + </field> + </index> </declaration> @@ -580,6 +594,21 @@ <default></default> <notnull>false</notnull> </field> + <index> + <name>share_file_target_index</name> + <field> + <name>file_target</name> + <sorting>ascending</sorting> + </field> + <field> + <name>uid_owner</name> + <sorting>ascending</sorting> + </field> + <field> + <name>share_type</name> + <sorting>ascending</sorting> + </field> + </index> </declaration> |