diff options
| author | Frank Karlitschek <frank@owncloud.org> | 2014-05-31 16:55:50 +0200 |
|---|---|---|
| committer | Frank Karlitschek <frank@owncloud.org> | 2014-05-31 16:55:50 +0200 |
| commit | a339855b4c85812e0c7e35ff3f83a8534fc24289 (patch) | |
| tree | 4aebd2419b31f227286ff8973b5ece0f2e2fe315 | |
| parent | cff9440a37a64a43403b7dd57a99a203410e426a (diff) | |
| download | nextcloud-server-a339855b4c85812e0c7e35ff3f83a8534fc24289.tar.gz nextcloud-server-a339855b4c85812e0c7e35ff3f83a8534fc24289.zip | |
add another index to the filecache to reduce the number of queries without a matching index
| -rw-r--r-- | db_structure.xml | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/db_structure.xml b/db_structure.xml index 21ac47a781b..95db8d1f9fb 100644 --- a/db_structure.xml +++ b/db_structure.xml @@ -400,6 +400,21 @@ </field> </index> + <index> + <name>fs_storage_size</name> + <field> + <name>storage</name> + <sorting>ascending</sorting> + </field> + <field> + <name>size</name> + <sorting>ascending</sorting> + </field> + <field> + <name>fileid</name> + </field> + </index> + </declaration> </table> |