Slow page loading on DigitalOcean

teh_g

@dread If you disable all of the additional plugins, does page load perform better? Is there a specific URL that is taking a long time?

dread

Nope - no improve performance. Specific - only facebook  and VK pixel code in <head> and google analytics and yandex metrics <scripts> in global footer. but by the firebug - they loads near half a second - but main page and categories load slow.

Adam Poniatowski

the ultimate questions are...

what instance are you running? 1 vcore 1GB VM? bigger? smaller?

Do you have swap? in case you don't have enough memory...

is the DB on the same server as nginx and nodebb? separate?

Which OS are you running?

If these questions were answered, please point me to it, and I will see if I can help

Duke

If you are using the $5 Digital Ocean server you will definitely need a swap partition.

dread

As I know DB on the same server with nodebb. and asking about swap. I'll try to increase power of server - mongodb eat to much) thanks - I write here after results.

dread

80$ hosting plan. Upgrade node to v6.11.1 and nodebb to v1.6.0. but MongoDb is still loading too long and waiting site in firebug decresed only by 1 sec(

Adam Poniatowski

which version of mongodb are you using?

julian

If you go to the /api routes... e.g. http://yoursite.tld/api/recent, is the rest still slow?

Definitely seems like some mongo indices are missing though it could really be anyone's guess at this point.

You can re-create the indices by running this in MongoDB after use-ing your NodeBB database:

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 });

dread

@julian said in Slow page loading on DigitalOcean:

If you go to the /api routes... e.g. http://yoursite.tld/api/recent, is the rest still slow?

Definitely seems like some mongo indices are missing though it could really be anyone's guess at this point.

You can re-create the indices by running this in MongoDB after use-ing your NodeBB database:
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 });

Thanks a lot! Now it works like a car on f1!)

yariplus

@dread said in Slow page loading on DigitalOcean:

https://github.com/Serhey/nodebb-plugin-featured-topics-extended-with-title

Oh.

That is a very ... unorthodox ... way of forking my plugin.

dread

@yariplus said in Slow page loading on DigitalOcean:

@dread said in Slow page loading on DigitalOcean:

https://github.com/Serhey/nodebb-plugin-featured-topics-extended-with-title

Oh.

That is a very ... unorthodox ... way of forking my plugin.

Sorry - I just start to using github. I foget to write fork. Fixed.

yariplus

@dread Oh, it's no problem at all! I was just joking, but thanks for adding the mention!