diff options
| author | Marcel Klehr <mklehr@gmx.net> | 2025-03-24 15:39:29 +0100 |
|---|---|---|
| committer | Marcel Klehr <mklehr@gmx.net> | 2025-03-25 09:42:06 +0100 |
| commit | b464469bc1a93ff4c0034d5a180361826c178cfc (patch) | |
| tree | cd4ab7450f3232f844e47d6ccf9f3f3531b9ee5a /apps/files_sharing/lib/OrphanHelper.php | |
| parent | 7a05c0059318f5d799ea6c21fb85a5155cddbdec (diff) | |
| download | nextcloud-server-refactor/use-in-instead-of-or.tar.gz nextcloud-server-refactor/use-in-instead-of-or.zip | |
perf(sharing): Use oc_share.{item_type, share_type} IN instead of OR equalsrefactor/use-in-instead-of-or
to improve performance by using the db index
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
Diffstat (limited to 'apps/files_sharing/lib/OrphanHelper.php')
| -rw-r--r-- | apps/files_sharing/lib/OrphanHelper.php | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/apps/files_sharing/lib/OrphanHelper.php b/apps/files_sharing/lib/OrphanHelper.php index 4a52af0406c..6e070f1446b 100644 --- a/apps/files_sharing/lib/OrphanHelper.php +++ b/apps/files_sharing/lib/OrphanHelper.php @@ -58,8 +58,7 @@ class OrphanHelper { $query = $this->connection->getQueryBuilder(); $query->select('id', 'file_source', 'uid_owner', 'file_target') ->from('share') - ->where($query->expr()->eq('item_type', $query->createNamedParameter('file'))) - ->orWhere($query->expr()->eq('item_type', $query->createNamedParameter('folder'))); + ->where($query->expr()->in('item_type', $query->createNamedParameter(['file', 'folder'], IQueryBuilder::PARAM_STR_ARRAY))); $result = $query->executeQuery(); while ($row = $result->fetch()) { yield [ |