diff options
| author | blizzz <blizzz@arthur-schiwon.de> | 2018-08-20 15:24:39 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-08-20 15:24:39 +0200 |
| commit | d0f8a431c871c4bd2f037b7a2b47de0a552afbc9 (patch) | |
| tree | 59ccf995c9059d5ccb3cda48b831383b3807ed1e | |
| parent | 74618d101182736e0c7bbeaf2fa6aacbcf0b327e (diff) | |
| parent | 391e693adf91430668781a92a6df2e5fafab2b03 (diff) | |
| download | nextcloud-server-d0f8a431c871c4bd2f037b7a2b47de0a552afbc9.tar.gz nextcloud-server-d0f8a431c871c4bd2f037b7a2b47de0a552afbc9.zip | |
Merge pull request #10762 from nextcloud/backport/10260/improved-sql-for-fetching-quota
[stable13] Use the path_hash instead of the path to query the filecache
| -rw-r--r-- | lib/private/Files/Config/UserMountCache.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/private/Files/Config/UserMountCache.php b/lib/private/Files/Config/UserMountCache.php index 384e6e5e457..255314c4e83 100644 --- a/lib/private/Files/Config/UserMountCache.php +++ b/lib/private/Files/Config/UserMountCache.php @@ -376,7 +376,7 @@ class UserMountCache implements IUserMountCache { ->innerJoin('m', 'filecache', 'f', $builder->expr()->andX( $builder->expr()->eq('m.storage_id', 'f.storage'), - $builder->expr()->eq('f.path', $builder->createNamedParameter('files')) + $builder->expr()->eq('f.path_hash', $builder->createNamedParameter(md5('files'))) )) ->where($builder->expr()->eq('m.mount_point', $mountPoint)) ->andWhere($builder->expr()->in('m.user_id', $builder->createNamedParameter($userIds, IQueryBuilder::PARAM_STR_ARRAY))); |