IPB-Nuke high page gen time

Nuke Soldier Joined: Aug 03, 2004 Posts: 12

Running a IPB Nuke setup... page loads were as high as 15 seconds on a fully dedicated 1.7 Ghz Celeron / 512 MB RAM / (wouldn't you like to know?) Linux

Gets about 25K or more page views a day just in this one area.

I made the changes to mainfile.php, and also cut off survey just for time being to make it bearable for users. The time is cut down to 1.7 seconds roughly, but that's at low tide. During more stressed times, it can shoot back up as high as 8... 9... 10 sec page gen time.

Any of you l33t Wink

cpg folks... I'd greatly appreciate if you could tell me any code optimizations. It is ASSUREDLY not the server, as other areas load up with some serious quickness. It's 100% code optimization.

Remember... IPBNuke... so all the many phpbb speed-ups I see do not apply. Invision still has a rather low gen time of it's own within IPB Nuke (as low as 0.09 seconds).

Gzip enabled.... mysql cache feature not available (because Ensim blows).

Nuke Soldier Joined: Aug 03, 2004 Posts: 12

Deactivating Forum Stats, Survey, and Page Views has gen time as low as 0.2 seconds... I'd say I've found the culpits.

Help optimizing? djmaze? anyone? bueller?

Posted: Tue Aug 03, 2004 12:09 am

So IPB generates fast pages, but the rest of your system doesn't ?

Nuke Soldier Joined: Aug 03, 2004 Posts: 12

The rest of my system (IPB within IPB Nuke, and other IPB areas) generate with serious speed. However, with the Survey, Page View, and Forum Stats blocks on, the page gen time for IPB Nuke climbs as high as a dozen seconds. With them off, it rarely tops 1.25 seconds on heavy traffic loads.

Posted: Tue Aug 03, 2004 8:05 am

I think my CPG survey block v1.4 will boost your system a bit: http://cvs.sourceforge.net/viewcvs.py/phpnuke65-cpg/html/blocks/block-Survey.php?rev=1.4&view=markup

Check your "page view" and "forum" blocks, maybe the guy who made them did very, very bad sql queries in them.

Post a download link and we will see what we can do.

Nuke Soldier Joined: Aug 03, 2004 Posts: 12

I sent you a link via PM... feel free to distribute to dev team members.

Posted: Tue Aug 03, 2004 10:34 pm

The forum stats block does this:

Code:

$lastpost_sql = mysql_query("select forum_id,topic_id,author_id,author_name from ".$INFO['sql_tbl_prefix']."posts order by pid desc");

This means all posts are selected and put in memory.

Code:

$lastpost_sql = mysql_query("select forum_id,topic_id,author_id,author_name from ".$INFO['sql_tbl_prefix']."posts order by pid desc limit 0,1");

voila here we go

Nuke Soldier Joined: Aug 03, 2004 Posts: 12

awesome.. keep 'em coming ubermysql man. :bow:

Nuke Cadet Joined: Jul 15, 2004 Posts: 7

wow, I just disabled block-sommaire and my IPBnuke loading times went from around 2 seconds or more to:

Page Generation: 0.048 Seconds

Neutral

Captain Joined: Feb 21, 2004 Posts: 421

Funny, Sommaire causes no slowdown on my site. o_O

Posted: Mon Aug 09, 2004 1:57 pm

if you use v2.0 you can experience some slowdown.

v2.1 (and latest v2.1.1) should resolve your problem.

see this online FAQ item to optimize a little bit the load time in v2.1 (and 2.1.1)

Nuke Soldier Joined: Aug 03, 2004 Posts: 12

I have managed to get it around 1 second under high load... certainly it can do better, and I NEED it to do better if I am going to roll out multiple high traffic IPBNuke areas.

If I post related block source.. anybody give 'er a look and recommend better queries etc?