Slow page loading on DigitalOcean

dread

Hi there. please help me to improve the speed of forum based on DigitalOcean hosting with nginx. For now it takes from 5 to 7 sec to loading any page - in firebug it shows that all scripts load fast, and onle main url of forum show wait status near 6 sec. we use MongoDb - its size for now only 52 mb - but its horrible slow - we add indexes - but we win only 1-2 sec. maybe it can be some caching system for this engine? or I need change some setting in admin dashboard, or increase hardware of server? thanks in advise.

PitaJ

There's got to be something else going on. This is not normal by any means. Have you tried starting over? What guide did you use?

BTW, because of how templates are done now, your first request to any page will be slow, but subsequent requests should be fast.

teh_g

@dread Anecdotally, I use DigitalOcean for my NodeBB instance and have zero issues. I'd agree with PitaJ and say that someone else is happening here. Is the URL being loaded something from your site? Did you add any plugins?

dread

Thanks for fast answer. Yeap, first loading I understood will be quite slow - but in my case it decrease only to 1 sec for loading other pages after loading main and I can't understand why( theme persona. nodebb version 1.5.3. plugins - standart - with https://github.com/Serhey/nodebb-plugin-featured-topics-extended-with-title https://github.com/Serhey/nodebb-plugin-ns-slugify-fixed-on-edit#readme https://github.com/Schamper/nodebb-plugin-poll#readme https://github.com/iiiyx/nodebb-plugin-share-vk https://github.com/boomzillawtf/nodebb-plugin-youtube-embed#readme

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:

GitHub - Serhey/nodebb-plugin-featured-topics-extended-with-title: Custom news with title - forked from https://github.com/yariplus/nodebb-plugin-featured-topics-extended

Custom news with title - forked from https://github.com/yariplus/nodebb-plugin-featured-topics-extended - Serhey/nodebb-plugin-featured-topics-extended-with-title

GitHub (github.com)

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:

GitHub - Serhey/nodebb-plugin-featured-topics-extended-with-title: Custom news with title - forked from https://github.com/yariplus/nodebb-plugin-featured-topics-extended

Custom news with title - forked from https://github.com/yariplus/nodebb-plugin-featured-topics-extended - Serhey/nodebb-plugin-featured-topics-extended-with-title

GitHub (github.com)

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!