NodeBB slow after DB recovery
Solved
Performance
-
One thing I noticed was that after recovering the assets and database onto a test server: (see below)
The performance of the replica NodeBB install was painfully slow. After much searching and hair pulling, I found that the indexes seemed to be missing - a point which is referenced by NodeBB themselves here
When I checked
/api/recentit was indeed slow - like a snail. So, at their suggestion, I opened upmongodband added the missing indexesdb.objects.createIndex({ _key: 1, score: -1 }, { background: true }); db.objects.createIndex({ _key: 1, value: -1 }, { background: true, unique: true, sparse: true }); db.objects.createIndex({ expireAt: 1 }, { expireAfterSeconds: 0, background: true }); The difference is quite astonishing. Now it runs like the Ferrari I’ve come to love and respect
Might be useful for someone else in the same boat…
-
undefined phenomlab has marked this topic as solved on 28 Feb 2022, 17:43
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (ether email, or push notification). You'll also be able to save bookmarks, use reactions, and upvote to show your appreciation to other community members.
With your input, this post could be even better 💗
RegisterLog in
