Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/nextcloud/server.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
path: root/apps
diff options
context:
space:
mode:
authorCarl Schwan <carl@carlschwan.eu>2022-03-10 17:10:08 +0300
committerCarl Schwan <carl@carlschwan.eu>2022-03-10 17:10:08 +0300
commit2cdaa28accbdca6f410421249055a79aba6fe8e5 (patch)
treeb2b1baa5da1686860866c6cdca3dd79796cc8d21 /apps
parentcb7485e7640497c29423e72fba5c47a26e84e811 (diff)
Don't recreate sql query each timefix/carddav-backend-1000-orache1
Signed-off-by: Carl Schwan <carl@carlschwan.eu>
Diffstat (limited to 'apps')
-rw-r--r--apps/dav/lib/CardDAV/CardDavBackend.php16
1 files changed, 8 insertions, 8 deletions
diff --git a/apps/dav/lib/CardDAV/CardDavBackend.php b/apps/dav/lib/CardDAV/CardDavBackend.php
index 98e85096b3b..1c1754ff752 100644
--- a/apps/dav/lib/CardDAV/CardDavBackend.php
+++ b/apps/dav/lib/CardDAV/CardDavBackend.php
@@ -139,7 +139,7 @@ class CardDavBackend implements BackendInterface, SyncSupport {
->from('addressbooks')
->where($query->expr()->eq('principaluri', $query->createNamedParameter($principalUri)));
- $result = $query->execute();
+ $result = $query->executeQuery();
$column = (int) $result->fetchOne();
$result->closeCursor();
return $column;
@@ -1131,18 +1131,18 @@ class CardDavBackend implements BackendInterface, SyncSupport {
}, $matches);
$cards = [];
- foreach (array_chunk($matches, 1000) as $matche) {
- $query = $this->db->getQueryBuilder();
- $query->select('c.addressbookid', 'c.carddata', 'c.uri')
- ->from($this->dbCardsTable, 'c')
- ->where($query->expr()->in('c.id', $query->createNamedParameter($matche, IQueryBuilder::PARAM_INT_ARRAY)));
+ $query = $this->db->getQueryBuilder();
+ $query->select('c.addressbookid', 'c.carddata', 'c.uri')
+ ->from($this->dbCardsTable, 'c')
+ ->where($query->expr()->in('c.id', $query->createParameter('matches')));
- $result = $query->execute();
+ foreach (array_chunk($matches, 1000) as $matchesChunk) {
+ $query->setParameter('matches', $matchesChunk, IQueryBuilder::PARAM_INT_ARRAY);
+ $result = $query->executeQuery();
$cards = array_merge($cards, $result->fetchAll());
$result->closeCursor();
}
-
return array_map(function ($array) {
$array['addressbookid'] = (int) $array['addressbookid'];
$modified = false;