The Arcive of vBulletin Modifications Site.

vau7 · #1 01-21-2005, 04:28 AM

Hi,

I want to optimize the loading time of my forums by uninstalling some hacks.
I have 27 queries (1 queries for uncached templates (-for randomroute by the quotes on forumhome-hack).

How can i go further?
What is to do with the uncached template?

Here are my debug-infos:

Code:

27 queries (1 queries for uncached templates

FORUMHOME (1)
footer (1)
forumhome_forumbit_level1_nopost (6)
forumhome_forumbit_level2_post (15)
forumhome_lastpostby (21)
forumhome_loggedinuser (2)
forumhome_stats_member (5)
forumhome_stats_poster (5)
forumhome_stats_thread (5)
forumhome_todayloggedinuser (5)
forumhome_todayloggedinusers (1)
gobutton (1)
header (1)
headinclude (1)
irc_loggedin (1)
navbar (1)
phpinclude_start (1)
randomquote (1)
spacer_close (1)
spacer_open (1)
timezone (1)
username_loggedin (1)

Page generated in 0,22238 Seconds

My explained Stats are in the textfiles.

I really thank you for helping me.
Unfortunatly learning through making failures is one of my prefered ways

Andreas · #2 01-21-2005, 04:39 AM

27 queries on forum home?
That seems to be quite a lot - I got only 13-14.

Code:

irc_loggedin (1)
randomquote (1)

These are non-standard templates, so one of them most likely isn't cached.

Roughly looking at your queries:
You got some statistics hack installed?

That seems to cause a lot of queries.
Btw: It would be a lot easier to read if it was HTML instead of TXT ...

vau7 · #3 01-21-2005, 04:41 AM

Yeah the randomquote isnt cached, so what to do?

Andreas · #4 01-21-2005, 04:44 AM

Cache it

Add it to array $globaltemplates.

vau7 · #5 01-21-2005, 04:59 AM

Hey thanks, now i know how to cache the templates. So i've done this.
Saved 1 Query on Forumhome. How can i go further? Saving more queries?

Thank you very much KirbyDE

edit:

I#ve seen for the normal load of an Topic i have 19 Queries.

Andreas · #6 01-21-2005, 05:23 AM

OK, so let's take a further look at your queries

Code:

SELECT id_empfaenger
FROM sms
WHERE id_empfaenger  = 2

Dunno what this is, probably some instant messaging hack?
IMHO useless.

Code:

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 2

Used to fetch your avatar (and display it).
It's up to you to decide if this is necessary

Code:

select count(*) as new_posts from post where dateline > '1106285277'
select count(*) as new_topics from thread where lastpost > '1106285277'

New posts and Threads since last visit..

Code:

select count(*) as all_users from user

Total number of users.
Now tihis is a total waste, as the number of users is in the datastore and could be aquired without a query.

Code:

select count(*) as all_posts from post

Total number of posts. Alos a waste as this figure is available in index.php as $totalposts

Code:

select count(*) as all_topics from thread

Same here for threads => $totalthreads

Code:

SELECT * FROM quotes WHERE approved = 1 ORDER BY rand(877250764)

Guess that's your random quote hack ...

Code:

SELECT template
FROM template
WHERE templateid = 5017

Uncached template, already solved.

Quote:

SELECT * FROM `irc_channel`

Some "users in chat" hack?

Code:

SELECT userid, username, posts FROM user ORDER BY posts DESC LIMIT 0, 5

Top 5 posters display?

Code:

SELECT userid, username, posts, joindate FROM user ORDER BY joindate DESC LIMIT 0, 5

The last 5 newest members.
If you want this, I think it would be better to put this info in datastore when a new member registers.
As the last newest member is already being stored I think this could be done without additional queries, it just needs code adjustments.

Code:

SELECT COUNT(*) ,
SUM(views) AS hits
FROM  thread

Totel thread views

=> There are a few things that can be optimized without loosing features.

vau7 · #7 01-21-2005, 12:24 PM

Big Thanks!

That is really helpful.

But if i look into my FORUMHOME the total amount of Threads and Posts are called by $totalthreads and $totalposts (for the statistics at the bottom). Strange.

Andreas · #8 01-21-2005, 12:30 PM

Well, without knowing you actual code I can't tell more.

vau7 · #9 01-21-2005, 05:08 PM

Code:

++edited away++

This is my FORUMHOME

Andreas · #10 01-21-2005, 05:10 PM

I meant the PHP code

And I am not sure if you didn't just violate the license agreement.
Therefore it might be better to remove the template-code you posted.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05959 seconds Memory Usage 4,751KB Queries Executed 12 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (14)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (1)postbit_attachment (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: