diff options
| author | Robin Appelman <robin@icewind.nl> | 2025-05-26 18:08:36 +0200 |
|---|---|---|
| committer | Robin Appelman <robin@icewind.nl> | 2025-05-27 14:40:49 +0200 |
| commit | a6251f23334a2e04cd667b375591784d6c50a0e9 (patch) | |
| tree | ffafc83acfd0702193ede64674afb2867e918975 | |
| parent | d9fdd39181a257952c1e46a7f451527f98565c31 (diff) | |
| download | nextcloud-server-backport/53120/stable29.tar.gz nextcloud-server-backport/53120/stable29.zip | |
perf: improve query to determine which users need a background scanbackport/53120/stable29
Signed-off-by: Robin Appelman <robin@icewind.nl>
| -rw-r--r-- | apps/files/lib/BackgroundJob/ScanFiles.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/apps/files/lib/BackgroundJob/ScanFiles.php b/apps/files/lib/BackgroundJob/ScanFiles.php index 8dc9dcf37ff..80d71d8b8f6 100644 --- a/apps/files/lib/BackgroundJob/ScanFiles.php +++ b/apps/files/lib/BackgroundJob/ScanFiles.php @@ -90,7 +90,7 @@ class ScanFiles extends TimedJob { $query->select('user_id') ->from('filecache', 'f') ->innerJoin('f', 'mounts', 'm', $query->expr()->eq('storage_id', 'storage')) - ->where($query->expr()->lt('size', $query->createNamedParameter(0, IQueryBuilder::PARAM_INT))) + ->where($query->expr()->eq('size', $query->createNamedParameter(-1, IQueryBuilder::PARAM_INT))) ->andWhere($query->expr()->gt('parent', $query->createNamedParameter(-1, IQueryBuilder::PARAM_INT))) ->setMaxResults(1); |