What is all this talk about performance issues?
WJ is one of the most under modded forums ever. A few modifications could easily be implemented without noticeable affecting performance.
I like these kinds of requests. It's the future.
The point being made here is the fact that as it is you have to load the topic and user information which is read all at once plus being loaded multiple times a minutes by over a hundred users causes a heavy sql query.
Now imagine that and a mod which reads from the db every 2-3 seconds for over 100 users. Now that would cause the db to stress as vbulletin has a shitty sql format and causes high loads without the queries being cached by a external cache server.
______________________________________________________
What JmZ said is true, but if wjunction wants to be a real webmaster forum why not start being one?
Being webmasters you learn how to offload the heavy stuff and load balance servers. Now im pretty sure wjunction is on a server with multiple other sites, but you can easily load balance this site and not ever need the use of cloudflare again even if there is a ddos.
Plan A:
- Use either 2 VPS/Dedicated servers
- Place wjunction forum and http server (nginx or lighttpd) on a single vps/dedi
- Place MySQL (Mariadb, Percona) on the other vps/dedi, Also add in sphinx for ultra fast low resource searches
- Both vps/dedi would have to be on the same network to take advantage of the local highspeed transfers to keep both servers talking to eachother at a good speed.
The reason Plan A would work well is because MySQL can be heavy duty, but if fully optimized to be used as a dedicated server then you will not see a load over 2-5% from a forum like wjunction.
Also this would protect wjunction from slow downs and possible ddos's if correctly configured.
The cost of this would most likely not be over 50$ a month so to say if this forum wants to grow and add great features then its time to think like a webmaster and grow....