diff options
| author | Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com> | 2025-02-12 15:29:26 +0100 |
|---|---|---|
| committer | Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com> | 2025-02-13 10:11:02 +0100 |
| commit | 9bdee76535af2e0fbc0e4c9de6ffc932a3a311c1 (patch) | |
| tree | 379c2840a7b679d2d4e16cd3951501f7fefd15b3 /lib/private/Files/ObjectStore | |
| parent | 4905255936ecd0bf1511b326e5de47f91d589b18 (diff) | |
| download | nextcloud-server-perf/improve-incomplete-scan.tar.gz nextcloud-server-perf/improve-incomplete-scan.zip | |
perf(files): faster query to fetch incomplete directoriesperf/improve-incomplete-scan
Signed-off-by: Benjamin Gaussorgues <benjamin.gaussorgues@nextcloud.com>
Diffstat (limited to 'lib/private/Files/ObjectStore')
| -rw-r--r-- | lib/private/Files/ObjectStore/ObjectStoreScanner.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/private/Files/ObjectStore/ObjectStoreScanner.php b/lib/private/Files/ObjectStore/ObjectStoreScanner.php index 05929a49aab..5c3992b8458 100644 --- a/lib/private/Files/ObjectStore/ObjectStoreScanner.php +++ b/lib/private/Files/ObjectStore/ObjectStoreScanner.php @@ -61,7 +61,7 @@ class ObjectStoreScanner extends Scanner { $query->select('path') ->from('filecache') ->where($query->expr()->eq('storage', $query->createNamedParameter($this->cache->getNumericStorageId(), IQueryBuilder::PARAM_INT))) - ->andWhere($query->expr()->lt('size', $query->createNamedParameter(0, IQueryBuilder::PARAM_INT))) + ->andWhere($query->expr()->eq('size', $query->createNamedParameter(-1, IQueryBuilder::PARAM_INT))) ->orderBy('path', 'DESC') ->setMaxResults(1); |