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]

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]

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]

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]

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.

[kall]

Have you added any custom bbcodes? Is posting cache on or off?
There's nothing in the bbcode manager...heres hoping it's not buried in the db somewhere from an older install invisibly screwing it over.

Cached Posts Lifespan is 14 .. that means Post Caching is on?

[Paul M]

Forget the DB - according to your first post the SQL part of that 26 seconds was 0.12%, which is about 3/100 ths of a second. This is not your problem. The delay is related to the PHP element. If you have all the changes to showthread documented, take each one out for a while and see if the problem goes away.

[Colin F]

There's nothing in the bbcode manager...heres hoping it's not buried in the db somewhere from an older install invisibly screwing it over.

Cached Posts Lifespan is 14 .. that means Post Caching is on?
Yes, that means post caching is on. To turn it off, set this to 0.

[kall]

Forget the DB - according to your first post the SQL part of that 26 seconds was 0.12%, which is about 3/100 ths of a second. This is not your problem. The delay is related to the PHP element. If you have all the changes to showthread documented, take each one out for a while and see if the problem goes away.
Uploading a fresh showthread.php made no change to the situation whatsoever...still the same number of queries.

Assumption: it could be in functions_showthread.php...

@Colin: I thought as much. Reckon I should try turning caching off? The concept of turning off caching usually goes against 'making pages load faster' tho, doesn't it?

[Princeton]

I don't know which hacks you have added to your forums but...

I noticed that you are using PHP 4.3.10 ... the unserialize() function bug is probably one of the reasons why your "time" is high.

The solution--upgrade to 4.3.11.

[Marco van Herwaarden]

Lol a shame 4.3.11 don't exist in a stabil yet.

[kall]

I don't know which hacks you have added to your forums but...

I noticed that you are using PHP 4.3.10 ... the unserialize() function bug is probably one of the reasons why your "time" is high.

The solution--upgrade to 4.3.11.
I had just sent an email to my tech support person about that same thing. ;)

Page generated in 16.24680 seconds with 26 queries,
spending 0.030720233917236 doing MySQL queries and 16.216079766083 doing PHP things.


Is there a way to look at what those 'PHP things' are? Like you can with the queries?