NodeBB slow after DB recovery

[phenomlab]

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/recent it was indeed slow - like a snail. So, at their suggestion, I opened up mongodb and added the missing indexes

db.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…