Server limits

[queengoc]

Ever since I've upgraded from 3.8 my server has been exceeding it's limits and the majority of the usage is from my forum. What can I do to lighten the load on my server?

I'm not a technical person at all. Our web server suggested talking to our web designers but they aren't familiar with vbulletin so I thought I would come here first. Any suggestions would be appreciated.

Thanks!

[Lynne]

Do you have modifications? Try disabling them and see if that makes a difference.

[queengoc]

Lynne, according to my web host the majority of my usage is from the showthread.php. I guess that's normal but the difference between that script and the rest of my forum and website is astronomical. I have no idea where to look or what to do to try and fix the issue.

I disabled most of my mods but none of the ones I'm currently using search related. Here are the mods I currently have in use, I uninstalled everything else:

AddonChat 4.0.1
Disable Member Homepage URLs by BOP5 1.0
Forum Category Icons (Advanced) 1.2.4
Minimum number of posts to post links. 1
Move smilies below textarea 1.4
Separate Sticky and Normal Threads 1.1
SFS Integration 1.0.0
vBH - Add new tabs 1.2
VSa - Advanced Forum Statistics

Any ideas?

[Lynne]

Any sort of chat or stats mod is going to be server intensive if the users use them.

[Boofo]

Some of those mods he still has can add lots of extra queries, too. Especially the stats mods.

[queengoc]

Thank you, I will turn off the stats mod and see if that helps. Our chatroom isn't used too often so I'll keep that and see if turning off the stats helped.

Thanks again Lynne and Boofo!

[Boofo]

Just remember to keep the queries down as much as possible, with very many members on at one time. If you have 100 users on at once, and 2 extra queries, that is 200 queries right there. They can add up in a heartbeat.

[queengoc]

Boofo, how do I keep the queries down? Sorry, I'm a learn as I go person.

[Staxed]

Boofo, how do I keep the queries down? Sorry, I'm a learn as I go person.

You aren't really going to be able to keep the queries down unless you are a coder yourself and can edit mods that use a lot of queries. With each mod you add they may/maynot add queries.

[Boofo]

Boofo, how do I keep the queries down? Sorry, I'm a learn as I go person.

Install this mod and start keeping an eye on your queries.

https://vborg.vbsupport.ru/showthread.php?t=240905