slow index

My index page loads real slow. Is there something I can do to speed it up? I mean it cant be the server all the time, although they are alot of reason to it, all the other pages load faster. Thanks

To start, I'd recommend looking up and installing a page generation time hack to help find out where your slow down is coming from. Some hacks add a lot of SQL queries to the index page that can cause a lot of slowness. A good generation time hack will tell you how much time is being spent on the PHP processing and SQL queries and how many of queries are running.

ok I will start searching, do you have any suggestions?

ok got one and here are the results


Page generation time: 314113.4066s (PHP: 100% - SQL: 0%) - SQL queries: 76 - GZIP disabled - Debug on

76 queries is kind of high, but not too bad. What mods do you have installed that affect index.php, page_header.php, or page_tail.php? Chances are there is a badly written query in one of those files, and it is taking a long time to process.

I have done so many mods, I wouldn't know where to start. Let me get a list together and get back to you. You don't know anything asbout converting from PHPbb to vBulletin do you?

Nope, sorry. I think my total experience with vBulletin is limited to posting on one forum once and downloading it once.

birthday mod, paypal donation mod, subforums mod, small shoutbox, who is online, color mod, yellow card mod, admin logging, limit signature, admin add user (doesn't really work), custom title mod, delete post notification mod, EZ Portal, KArma, yesterday today mod, IP mod (doesn't work), merge posts mod, no admin edit, page generation time hack, RSS mod, and edit mod, there are numerous EZ portal mods but they dont really affect the index page.

Quote:

Which mod is this? If it's Color Groups, that could be the problem - it can run a lot of queries.

We can exclude all of these; none of them should cause problems like this:

Quote:

If you can, save a copy of your index.php file as a txt file, upload that somewhere, and post a link to it. I can look over the file and see if I notice anything in there that can be improved.

it's this one;

MOD Title: Extend rank color
## MOD Author: Gendo < gendo@denturax.com > (Matthieu V.) http://www.denturax.com
## MOD Author: BigZ < bigz@denturax.com > (Romain R.) http://www.denturax.com
## MOD Description:
## This mod gives the possibility to add colour ranks into "Who is online"
## page and into "Who is online" part in bottom of the index. You can
## create colour ranks via the ACP. You can also put in colour your various
## groups of users (phpBB Usergroups) on the index and the sight of
## viewonline.
##
## MOD Version: 2.0.0
## Compatibility: 2.0.6-2.0.13
##
## Installation Level: easy
## Installation Time: 30 Minutes
## Files To Edit: (10)
## viewonline.php
## admin/admin_users.php
## admin/admin_groups.php
## admin/admin_board.php
## includes/constants.php
## includes/page_header.php
## templates/subSilver/index_body.tpl
## templates/subSilver/admin/user_edit_body.tpl
## templates/subSilver/admin/group_edit_body.tpl
## templates/subSilver/admin/board_config_body.tpl
##
## Included Files: (4)
## admin/admin_ranks_whosonline.php
## templates/subSilver/admin/whosonline_ranks_edit_body.tpl
## templates/subSilver/admin/whosonline_ranks_list_body.tpl
## language/lang_english/lang_erc.php



and here is the link to my index zipped;

http://www.meogee.com/files/index.zip