PDA

View Full Version : vb 4, very slow in query global.php / forum.php


gx123
11-16-2012, 10:54 AM
Hello,
the vbulletin forum at http://www.gamexeon.com/forum

is very slow for some user logged in from some location. It will take long time to finish 17 queries, about 5 to 10 secs.

the slowness is on global.php (shown by debug mode) or forum.php (shown by chrome)

here the screenshot:

http://www.gamexeon.com/wp-content/uploads/2012/11/weirdvbulldebug.png
http://www.gamexeon.com/wp-content/uploads/2012/11/vbulletin-weird-performance.jpg

surprisingly, if i open the forum in Incognito Window, the query will finish in just under 1 sec. awesomely fast.

some user surprisingly also able to open surprisingly fast even while logged in.

more surprisingly, the frontpage (http://www.gamexeon.com/forum) will randomly goes so fast. Page generation under 1 sec. But the showthred (example http://www.gamexeon.com/forum/gamexeon-site-info/91989-gamexeon-urgent-maintenance-30-oct-2012-12-30-wib.html) will always slow.

any info how to fix this issue?

thanks

Lynne
11-16-2012, 04:29 PM
Try disabling your modifications/plugins and see if you still have this problem and see how much the page generation goes down.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

gx123
11-21-2012, 05:47 AM
the problem its that... thats weird things happend if i disable things.

if i disable all using the config.php method, the forum back to fast.

the same when i disable then re-enable product on admin panel, the forum is run fast. then the next day, the same thing will happend again.

i need to disable and enable whatever plugin. Its a weird solution.
if i did not do that, the forum crawl like a snail :D

Lynne
11-21-2012, 04:12 PM
Disable them all and leave the forum like that for a day. See if things stay fast. Then enable ONE product (a non-query intensive one). Leave the forum like that for a day. Keep adding one product a day and start with the non-query intensive ones. Then at the end, add the biggies like Experience, or Galleries, or Chatboxes, or Arcades.