Forums index page is very slow - phpBB working ok though

Nuke Soldier Joined: May 28, 2004 Posts: 27

I'm running phpnuke 7.0 - heavily hacked and with various bits upgraded.

PhpBB 2.0.19 is running fine in all regards, except the index page takes between 20-40 seconds to load.

http://www.4clubbers.net - in the forums area.

I've done a good search on this topic and while there's various hacks I've applied to speed up the forums generally, nothing has fixed this. I've also got the arcade installed. Any help appreciated.

Nuke Soldier Joined: May 28, 2004 Posts: 27

Is there perhaps any way of improving this query?

Code:

$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, u.user_displayname
FROM (( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order";