Can you check if my page is as fast as it can be?

Sergeant Joined: Jun 06, 2004 Posts: 100

I just want to know if it has any more potential speed. Sorry, because I don't know much about how quick with phpnuke is.

the URL is http://dsfilms.com

if you notice anything i could do to speed it up, please post! Thanks!

Corporal Joined: Aug 16, 2003 Posts: 52

Well it seems to be pretty fast. Have you applied the speedups in http://www.nukecops.com/postt22767.html - they work pretty well.

Posted: Mon Jun 14, 2004 7:22 pm

Page Generation: 0.216 Seconds

That's like 1/5 of a second dude....

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

It'd be nice to have that at computercops. Very Happy

Support Mod Joined: Aug 21, 2003 Posts: 335

Optimize some of that code. Start with your Forum block..

Code:

$result = $db->sql_query("SELECT
t.topic_id, t.topic_last_post_id, t.topic_title,
f.forum_name, f.forum_id,
u.username, u.user_id,
p.poster_id, FROM_UNIXTIME(p.post_time,'%b %d, %Y at %T') as post_time
FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f
LEFT JOIN ".$prefix."_bbposts p ON (p.post_id = t.topic_last_post_id)
LEFT JOIN ".$prefix."_users u ON (u.user_id = p.poster_id)
WHERE t.forum_id=f.forum_id AND f.auth_view=0
ORDER BY t.topic_last_post_id DESC
LIMIT 20");

while(list($topic_id, $topic_last_post_id, $topic_title, $forum_name, $forum_id, $username, $user_id, $poster_id, $post_time) = $db->sql_fetchrow($result)) {

That should drop a second or two. Then cache the other blocks.

Posted: Thu Sep 16, 2004 11:34 am

Can you please check the same for my site too?

And please tell me how to see page gen time?

http://www.pottersrealm.co.org.ru

Lieutenant Joined: Dec 30, 2003 Posts: 283

telli wrote:

Optimize some of that code. Start with your Forum block..

Code:

$result = $db->sql_query("SELECT
t.topic_id, t.topic_last_post_id, t.topic_title,
f.forum_name, f.forum_id,
u.username, u.user_id,
p.poster_id, FROM_UNIXTIME(p.post_time,'%b %d, %Y at %T') as post_time
FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f
LEFT JOIN ".$prefix."_bbposts p ON (p.post_id = t.topic_last_post_id)
LEFT JOIN ".$prefix."_users u ON (u.user_id = p.poster_id)
WHERE t.forum_id=f.forum_id AND f.auth_view=0
ORDER BY t.topic_last_post_id DESC
LIMIT 20");

while(list($topic_id, $topic_last_post_id, $topic_title, $forum_name, $forum_id, $username, $user_id, $poster_id, $post_time) = $db->sql_fetchrow($result)) {

That should drop a second or two. Then cache the other blocks.

telli, thanks. How would you optimize the above code, and what script is it in?