From 6ca832c02b2fa87720005f277b3fcb21dcf5ae6f Mon Sep 17 00:00:00 2001
From: Alexis LACROIX <alexis.lacroix@orange.com>
Date: Wed, 22 Feb 2017 15:03:33 +0100
Subject: Improve wekan performance (checklist collection scan)

---
 models/boards.js     | 4 +---
 models/checklists.js | 4 ++++
 2 files changed, 5 insertions(+), 3 deletions(-)

diff --git a/models/boards.js b/models/boards.js
index 0f66e9d6..9323d690 100644
--- a/models/boards.js
+++ b/models/boards.js
@@ -414,9 +414,7 @@ if (Meteor.isServer) {
       _id: 1,
       'members.userId': 1,
     }, { unique: true });
-    Boards._collection._ensureIndex({
-      'members.userId': 1,
-    }, { unique: true });
+    Boards._collection._ensureIndex({'members.userId': 1});
   });
 
   // Genesis: the first activity of the newly created board
diff --git a/models/checklists.js b/models/checklists.js
index 35be4dcc..3425f230 100644
--- a/models/checklists.js
+++ b/models/checklists.js
@@ -133,6 +133,10 @@ Checklists.mutations({
 });
 
 if (Meteor.isServer) {
+  Meteor.startup(() => {
+    Checklists._collection._ensureIndex({ cardId: 1, createdAt: 1 });
+  });
+
   Checklists.after.insert((userId, doc) => {
     Activities.insert({
       userId,
-- 
cgit v1.2.3-1-g7c22