diff options
| author | Morris Jobke <hey@morrisjobke.de> | 2015-07-08 18:04:10 +0200 |
|---|---|---|
| committer | Morris Jobke <hey@morrisjobke.de> | 2015-07-08 18:04:10 +0200 |
| commit | 4a37d565bd2b3c5972c329cbb3e1d5f07206ff09 (patch) | |
| tree | fe647c6e0644e535b60e8850fc6dfc2b81455f07 | |
| parent | 0fe81d2f214c59dbe223e949232475fb8a6f24b9 (diff) | |
| download | nextcloud-server-4a37d565bd2b3c5972c329cbb3e1d5f07206ff09.tar.gz nextcloud-server-4a37d565bd2b3c5972c329cbb3e1d5f07206ff09.zip | |
Add indexes to speedup DB queries
* file_target is often used in the sharing code in JOIN statements for retrieval of shares
| -rw-r--r-- | db_structure.xml | 15 | ||||
| -rw-r--r-- | version.php | 2 |
2 files changed, 16 insertions, 1 deletions
diff --git a/db_structure.xml b/db_structure.xml index 05d8dfb132b..7769c64d87c 100644 --- a/db_structure.xml +++ b/db_structure.xml @@ -471,6 +471,14 @@ </field> </index> + <index> + <name>gu_uid_index</name> + <field> + <name>uid</name> + <sorting>ascending</sorting> + </field> + </index> + </declaration> </table> @@ -859,6 +867,13 @@ <sorting>ascending</sorting> </field> </index> + <index> + <name>share_file_target</name> + <field> + <name>file_target</name> + <sorting>ascending</sorting> + </field> + </index> </declaration> </table> diff --git a/version.php b/version.php index 341e82671ea..1e112ca86db 100644 --- a/version.php +++ b/version.php @@ -22,7 +22,7 @@ // We only can count up. The 4. digit is only for the internal patchlevel to trigger DB upgrades // between betas, final and RCs. This is _not_ the public version number. Reset minor/patchlevel // when updating major/minor version number. -$OC_Version=array(8, 2, 0, 0); +$OC_Version=array(8, 2, 0, 1); // The human readable string $OC_VersionString='8.2 pre alpha'; |