I need some help optimizing the load time

[vau7]

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:


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

:rolleyes:

[Andreas]

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


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]

Yeah the randomquote isnt cached, so what to do?

[Andreas]

Cache it ;)
Add it to array $globaltemplates.

[vau7]

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]

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


SELECT id_empfaenger
FROM sms
WHERE id_empfaenger = 2


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


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


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..


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.


select count(*) as all_posts from post

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


select count(*) as all_topics from thread

Same here for threads => $totalthreads


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

Guess that's your random quote hack ...


SELECT template
FROM template
WHERE templateid = 5017

Uncached template, already solved.


SELECT * FROM `irc_channel`

Some "users in chat" hack?


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

Top 5 posters display?


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.


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

Totel thread views

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

[vau7]

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]

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

[vau7]

++edited away++


This is my FORUMHOME

[Andreas]

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.

[vau7]

Okay, thank you. I didnt know...*p?h*

I meant the PHP code
I know i am standig on long line, but from which file? The index.php or others?

[Andreas]

index.php most likely, maybe also functions_forumlist.php or functions_forumdisplay.php.

But then again, you are definitly not allowed to post these here.

[vau7]

However, many thanks for your help.