Page generation time occasionally very high - help please?

[kall]

Page generated in 25.80994892 seconds (99.88% PHP - 0.12% MySQL) with 25 queries

This seems to be related to showthread.php mainly..and usually it is when I am clicking for the last post.

Why might it be doing so much php stuff?

[Andreas]

Do you have any hackes installed?
Looks like a timeout or smth. to me.

[kall]

Originally Posted by KirbyDE

Quick reply to this message

Hey, now that's weird..look at what was stuck into the Quick Reply..

Anyway! Yeah. Many.

What would help to diagnose this?

[Andreas]

Well, replace showthread.php with the original (of course create a backup first) and check if it does still happen.

[neocorteqz]

well the 25 queries would be a start. Cut down the queries, and page generation times should go down with it.

adding $debug = 1 in config.php will help you asses what queries are being ran.

If you find you can get the query count down without removing hacks,then I suggest you ask in the threads of the hacks that you installed,how to cut down the queries without having to remove the hack.

Also some hacks just might not work well together.

[Brad]

Originally Posted by neocorteqz

well the 25 queries would be a start. Cut down the queries, and page generation times should go down with it.

adding $debug = 1 in config.php will help you asses what queries are being ran.

If you find you can get the query count down without removing hacks,then I suggest you ask in the threads of the hacks that you installed,how to cut down the queries without having to remove the hack.

Also some hacks just might not work well together.

That dos'nt seem to be the problem here altho I agree it is a high number. Something in php is casuing the long execution time. Dose this happen only on showthread.php or dose it happen other places aswell?

What hacks have you made to showthread.php, the global scape, and are there any cron scripts running at certain times? What else is on this server?

[kall]

Originally Posted by Brad.loo

That dos'nt seem to be the problem here altho I agree it is a high number. Something in php is casuing the long execution time. Dose this happen only on showthread.php or dose it happen other places aswell?

What hacks have you made to showthread.php, the global scape, and are there any cron scripts running at certain times? What else is on this server?

I have had a look at the 'explain' under debug mode...there seems to be a common thing in the part about parseing posts. That number is usually high...none of the queires being executed are above 0.7 usually, most are way way under it.

From memory - ibproarcade (crowns in postbit), AWS warning system, Activity, Private Threads...those ones affect showthread.php directly (or through functions_showthread.php).

Globally: Statistics, Hidden Posts notification in navbar, maybe one or 2 others.

As for what else is on the server, it's shared hosting, so it could well be anything.

[neocorteqz]

Could be the shared hosting, someone else is taking up an unsual amount of server resources somewhere. maybe even PHP.

if you have shell access in linux you should be able to check this out.I think the Top command would give you info on what processes arerunning. Windows I'm not sure how to check.

[Brad]

Have you added any custom bbcodes? Is posting cache on or off?

[neocorteqz]

Originally Posted by Brad.loo

Have you added any custom bbcodes? Is posting cache onor off?

just curious, what custom bbcode could cause problems?

I know I use the spoiler hack that was posted somewhere on the vBull sites.

Just want to make sure i don't install something that may cause problems down the road.