NodeBB slow after DB recovery
-
One thing I noticed was that after recovering the assets and database onto a test server: (see below)
https://sudonix.com/topic/239/testing-out-webdock-io
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
https://community.nodebb.org/topic/11299/slow-page-loading-on-digitalocean/12?_=1646060175987
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
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 (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login
