From 4e12bcc378d96c7227fbd3f40233502b0739347d Mon Sep 17 00:00:00 2001 From: Lauri Ojansivu Date: Tue, 28 Aug 2018 21:01:55 +0300 Subject: - Add Missing Index on cards.parentId since Swimlane integration to speedup Wekan. Thanks to Clement87 ! Closes #1863 --- models/cards.js | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'models') diff --git a/models/cards.js b/models/cards.js index 302beddc..4a73bbbc 100644 --- a/models/cards.js +++ b/models/cards.js @@ -1017,6 +1017,12 @@ if (Meteor.isServer) { // queries more efficient. Meteor.startup(() => { Cards._collection._ensureIndex({boardId: 1, createdAt: -1}); + // https://github.com/wekan/wekan/issues/1863 + // Swimlane added a new field in the cards collection of mongodb named parentId. + // When loading a board, mongodb is searching for every cards, the id of the parent (in the swinglanes collection). + // With a huge database, this result in a very slow app and high CPU on the mongodb side. + // To correct it, add Index to parentId: + Cards._collection._ensureIndex({"parentId": 1}); }); Cards.after.insert((userId, doc) => { -- cgit v1.2.3-1-g7c22