vb.org Archive - Optimizing Forumhome

Page 2 of 26

Last »

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)

- - Optimizing Forumhome (https://vborg.vbsupport.ru/showthread.php?t=46848)

Boofo

12-20-2002 11:34 PM

I don't want it changed if it can be incorporate it into what you already have. It's just that i don't have any threadviews anymore. :)

I haven't changed anything there (that I can recall). Must be an extra space or something in my file. :)

Xenon

12-20-2002 11:40 PM

of course, because the threadviewpart was a hack wasn't it? :)

instead of this code:

PHP Code:


		
			
$counters=$DB_site->query_first('SELECT SUM(replycount) AS posts, SUM(threadcount) AS threads FROM forum WHERE parentid=-1');

$totalposts=number_format($counters['posts']);

$totalthreads=number_format($counters['threads']);

use this one:

PHP Code:


		
			
$counters=$DB_site->query_first('SELECT SUM(replycount) AS posts, COUNT(*) AS threads, SUM(views) AS views FROM thread');

$totalposts=number_format($counters['posts']+$counters['threads']);

$totalthreads=number_format($counters['threads']);

$totalviews=number_format($counters['views']);

so it should work and you have your views again :)

Boofo

12-20-2002 11:49 PM

Thank you, sir. And I'm still at 17 queries. You are the Man! :)

I need to ask, though, is it normal to have this hack add 2 queries until the refresh? I mean, it is supposed to do that, right?

By the way, the threadviews was more of a line of code I got from Chen than a hack. :)

Xenon

12-21-2002 12:00 AM

:)

yes it is normal :)
as said above the two extra queries are fast one's
but i can't exactly say the performance power, that's why it's here in beta :)

:)

Boofo

12-21-2002 12:04 AM

Ok, well, I have noticed the page loads a lot quicker and smoother. So, it must be doing something. But, then, my board doesn't have very many users either, so I can't tell on the server load part of it. Although my server load stats in Microstats are showing 0.09, 0.05, 0.09 right now, if that means anything at all. :)

NuclioN

12-21-2002 12:57 AM

Page loads indeed quicker and it reduced the index queries by ten..that's significant! I hope that you can do this for the showthread. ;) Well done Xenon.

Dolby

12-21-2002 02:11 AM

I went from 18queries to 13queries. Very nice.

Aaron1

12-21-2002 04:25 AM

Yes it works faster, but the downside is i just lost TECKS hack: Latest XX Threads on Forumhome Page. Is there a way to work arround it?

https://vborg.vbsupport.ru/showthrea...threadid=43310

Xenon

12-21-2002 07:44 AM

@Aaron1: i'll look into it when i finished the beta, i'm still working on optimizing :)

@Boofo: Queries which are inside the makeforumbit function will be reduced always, so if someone has installed the show subforums hack, this hack can save an enourmous ammount of queries.

it always depends on how strong your index.php is hacked :)

well it's just the field lastupdate which has been included into the new version, it prevents some bugs...
you don't have to upgrade immediatelly, because im sure i'll change the structure a bit soon ;)

Wahh, sortingorder here is completly.......
good it's just beta :)

Dean C

12-21-2002 07:58 AM

So installing the show sub-forums hack would now only add one query instead of all those queries in the query loop?

- miSt

All times are GMT. The time now is 02:37 PM.

Page 2 of 26

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02136 seconds Memory Usage 1,742KB 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 (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (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: