summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorVincent Petry <pvince81@owncloud.com>2014-06-02 11:11:04 +0200
committerVincent Petry <pvince81@owncloud.com>2014-06-02 11:11:04 +0200
commit09ab642d2b6b98e4188bdefa004a27c19577ec90 (patch)
treea7cdabc589017470d2921d5a85afcb5492e0f810
parent27c8c87e94ed0b4c2d7e77030b85f6f18b1bd0ad (diff)
parenta339855b4c85812e0c7e35ff3f83a8534fc24289 (diff)
downloadnextcloud-server-09ab642d2b6b98e4188bdefa004a27c19577ec90.tar.gz
nextcloud-server-09ab642d2b6b98e4188bdefa004a27c19577ec90.zip
Merge pull request #8807 from owncloud/add_filecache_index
add another index to the filecache to reduce the number of queries witho...
-rw-r--r--db_structure.xml15
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>