Forum main page fast, forums inside load slow

[FockerFGAA]

my main page will upload fast for our website and if we click on forums the forum index page will load fast too. but every once and awhile if you try to click on the forums on that index page or any threads it will become unbearably slow with it taking minutes to load. i have repaired and optimized the tables but it just seems weird that it only affects that part of the site. is there any suggestions on how to find out what the issue that could be causing this is?

[Lynne]

Try disabling your modifications to see if it is a modification causing the problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[FockerFGAA]

i did as you said and it hasnt seemed to change the slow response time. i went into cpanel and i can manuever through everything smoothly until i try to look at the databases. could it be possible that mysql on my server is just lagging?

[Yogesh Sarkar]

Just checked your forum, threads do take a lot of time to open. You might want to post a server optimization request at vBulletin forums, that should help solve this issue.

[FockerFGAA]

ya i will definitely look into doing that. i talked to my provider and they said that this query was processor intensive

| 99863 | fvsports_Focker | localhost | fvsports_forum | Query | 0 | Sending data | SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1223512480 AND open <> 10, 1, 0)) AS newthread

but i have no clue what this query is doing and how to get rid of it.