vb.org Archive - Thread view optimizations

Page 2 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Thread view optimizations (https://vborg.vbsupport.ru/showthread.php?t=55715)

Darkwaltz

07-30-2003 06:46 AM

Nice, easy to install and speeds up my pages a lot

*install*

MrNase

07-30-2003 06:59 AM

:bunny: wow! loads a lot faster, thx :)

clicking install....

pwr_sneak

07-30-2003 10:04 AM

Quote:

Today at 08:36 AM Dolby said this in Post #10
So far its working nice. Why didnt vBulletin do this? Is there some sort of draw back?

they didn't implement this because it would not work for forums which moderate new posts.
but you could use $forum['moderatenew'] to decide which version you wanted to use.

if ($forum['moderatenew']) {
//use old queries
}
else {
//use faster queries
}

ed2k_2

07-30-2003 02:19 PM

Installed without any problem. Threads load more faster!
Thanks Zzed!

Dean C

07-30-2003 03:21 PM

Same here :)!

corsacrazy

07-30-2003 03:37 PM

Quote:

Today at 05:21 PM Mist said this in Post #15
Same here :)!

where to ? :ermm:

Dean C

07-30-2003 04:19 PM

My forums are private :)

oldgamesnu

07-30-2003 07:48 PM

Before: in 0.24841595
After: 0.20439696

fury	08-03-2003 04:18 PM

Quote:

07-30-03 at 07:04 AM pwr_sneak said this in Post #13
they didn't implement this because it would not work for forums which moderate new posts.
but you could use $forum['moderatenew'] to decide which version you wanted to use.

if ($forum['moderatenew']) {
//use old queries
}
else {
//use faster queries
}

Why not just change this line...

Code:

$postids.= "post.threadid='$threadid'";

to this:

Code:

$postids.= "post.threadid='$threadid' AND post.visible='1'";

It might slow it down a tiny bit more but it works with moderated forums...

fury	08-03-2003 04:26 PM

BTW, this (after you've applied the mod)

Code:

$postscount=$DB_site->query_first("SELECT replycount AS posts FROM thread WHERE threadid='$threadid'");

$postscount[posts]++;

$totalposts=$postscount[posts];

can be replaced, to save yet another query, with this:

Code:

$totalposts = $thread['replycount'] + 1;

since the thread info is already fetched earlier in the file.

All times are GMT. The time now is 01:45 AM.

Page 2 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01231 seconds Memory Usage 1,734KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: