![]() |
Put vBulletin in HTML Instead of PHP?
<i>(If they are needed, I don't have server specs at the moment, I'm waiting for the account holder to get me that information)</i>
Okay, we've been having some serious speed issues for over a year now and I apologize if I posted this in the wrong area. Our forum, is going God awful slow. We're on a dedicated hosting plan from the Planet but here for the last year or more, the forum itself has been slow, and the server was optimized about a week ago by the Planets technical staff and it literally appears to be even worse now. It's not like our forum is being overwhelmed though, about two years ago, and further back, we were a bustling quick loading forum, we had hundreds of users on the forum at one time, so I know we should be able to handle our current capacity relatively easily. We've optimized vBulletin too, limited the search engine bots, and I disabled all the modifications to see if they were causing the slow loading times, no dice there either. If anybody cares to check, you can go to pwmforums.com and see how slow it is, then go to pwmania.com (the main site) and see how relatively fast it is. We have about 5 sites hosted on the server, with the PWM site being by far the largest, but its been like that ever since we bought the server, probably 3-4 years ago. ---- Okay, I went through that long story to ask this question. I've seen other forums that have apparently turned their forum into .html format and doing away with the .php, which I feel may be why the forum, and not the sites, is slow. So...any advice on how I could turn our forum into the .html formats to see if it helps improve our loading times. |
You won't be able to use HTML, the PHP is used to render dynamic content.
Have you checked the vB error logs? Sometimes they can clue you into some problem that is occurring frequently which slows down the site. Also, have you optimized the database at all? The more activity on a board, the more overhead gets generated for the database tables - the more overhead, the longer it takes to query from a table. I try to optimize the tables at least once per week. Finally, large user databases can slow down a lot of the CRON jobs that run every hour. Run a user search in your AdminCP and delete all of the people who have 0 posts, and it should clear things up. :) |
Quote:
I'll look into those errors logs and see if anything can be found. Now when you say optimize the database, you mean optimizing the database through vBulletin with those Maintenance tools or actually optimizing it through the Server? |
that board probably has done one of two things; used mod_rewrite to change the path for the files OR setup apache to pass things with a html extension via php before outputting.
I see what you mean about it being slow; i'll take a browse around and see if there are any suggestions i have. Also, theres an ad at the bottom of your page that advertises part time job at $50-$100 an hour - its a scam. You may want to remove those particular ads. (They link to sites such as Kevin gets green etc) |
Quote:
As for the users, I'm just saying that they could be bogging down your CRON jobs. If they are, then you might need to see if there's something wrong with the CRON jobs themselves - some modifications will add new CRON jobs, or even alter existing ones, so you've got to be careful. Quote:
|
hrm, close your forum; put it in debug mode and have a look at where the time is being taken generating the pages. I suspect you may have a rogue sql query doing something bad...
|
I installed KX Debug and heres what I got...I hope this stuff is safe to post here. If any of yall can actually dissect what this stuff means, it would be a great help.
Code:
Template Usage: like 30 returning default icon messages at the end "php_sapi_name(): apache2handler Queries Executed: Code:
SQL Query |
One big red flag to me is the vbPlaza thing. That modification was removed from vbulletin.org for security exploits that the author refused to fix. He later on opened his own website for it and he claims that the exploits have been patched - but I'm still kinda hesitant.
Another thing, your guest views are taking the longest according to that read out. Do you have RSS enabled for your board? That's one way I can see guest views going up like that. But all of those guest views might also be a person running a botscript to check for exploits in your vbPlaza... |
Quote:
I'm tempted to install a 2nd copy of vbulletin on the server for testing purposes to see if it too runs slow...possibly indicating a server/mysql problem and not a vb problem. |
How many modifications have you installed? (And which?)
|
We have about 35 modifications, the most significant mods installed are ibproarcade, Casino, vBookie, vBPlaza, vBcredits, mods that link arcade/casino/bookie money system together, have about 4 mods from Cyb, Yet Another Award System, some miscellaneous mods such as Separate Sticky Threads and Normal Threads, Who's Read A Thread.
If you want the whole list, I can provide it. However, as I noted in my first post, I even disabled every single modification we had and there was no change in the status of the forum, everything continued to load at snails pace. |
Even if you disable your mods through the AdminCP, their plugin data remains in the cache which eat away at speed/resources. You need to disable your plugin system via the config.php and check the speed again.
|
Quote:
If it is truly running faster, makes me wonder which mod is the real resource hog. --- edit: Had some of my staff check their loading times. Disabled Mods: 1.53 seconds Enabled Mods: 3.199 Disabled Mods: 3.453 Refreshed: 3.358. With those times, it appears the Mods aren't the problem. I can imagine those loading times being much much higher, probably 10-15 seconds earlier in the day when it was at a dragging. |
When doing time comparisons you need to do fair comparisons. Allow the server enough time to clear the plugins from cache - and allow the browsers enough time to clear their cache. Turn off your mods for at least 24 hours and see if it's really a mod causing the issues or not.
Also, you might check your web server configuration. There might be some tricky .htaccess stuff going on in the background that's causing some issues. If you have a .htaccess, would you mind posting it? |
HTML Code:
|
How many IP Addresses are we talking here? Because every single time a page is loaded, Apache has to open, read, parse, and match everything in the .htaccess file. This happens on every single page load. Every last one of them. The longer the .htaccess file is, the longer it will take to load pages.
|
There was about 20 IP addresses in the .htaccess file. On top of that, our vBulletin User Banning Options has a ton more IP addresses banned, it probably has 50 or a little more.
Also, I just noticed this, but I put that define('DISABLE_HOOKS', true); script to disable the mods last night and well, it did disable some mods but it didn't disable the vBplaza or mods like that. |
What i noticed from your debug mode readout is that the page itself isn't taking very long to generate. Only 0.7 seconds for that one.
Can you load a number of pages both with and without mods enabled, time the loading clientside yourself, and compare it against how long vb took to generate it. Also, out of interest; what spec is the server and what load is it under? (you can get the load from the admin cp) i was going to ask for db size... but unless your members post hugely long posts or a mod has stored a stupid amount of data it shouldn't be that big... While you are at it; might as well post your apache, php and mysql conf files. |
All times are GMT. The time now is 03:37 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|