Code Optimisation - Anyone got anything that can optimise your vB files?

[wajones]

Originally posted by Erwin
For example, with vBPortal, the templates are not added to the $templateused by default - and they have many custom templates - imagine the waste in querying the database when they could all be cached. (Actually, the vBPortal code tries to include them, but it is written wrongly, and are not included).

How about telling me what I'm doing wrong and how to do it right so I can fix it. I'm presently adding them before it calls global.php or Email me at waj@adelphia.net

[N9ne]

Originally posted by NTLDR
Only if you have applied it wrong, I've checked mine and I don't have 7 queries for it.

What code should I check? IIRC the hack only modifies a few files: sessions.php functions.php member.php

Which file could the problem be occuring from?

[NTLDR]

I'd have said if you made a mistake it would have been in sessions.php

[N9ne]

Hmm, this is weird though, showthread only has 27 queries for me, yet when viewing what the queries are, there's such a long list of those

[N9ne]

...Just checked the code in sessions.php and it's fine, and I still get only 27 queries on showthread...weird.

[NTLDR]

Do all the queries listed add up to 27 on showqueries? I've got 26 on my showthread.

[Scott MacVicar]

if your talking about those ones to update lastactive on the user, they are shutdown queries which run when the script is ending execution for things like setting lastactive time about one in 100 views it will update all the sessions that have ended because users have left in the cookietimeout.

look at the bottom of functions.php

[Dean C]

PHP Code:

$allpm=$DB_site->query_first("SELECT COUNT(*) AS messages,
                                SUM(IF(dateline>$bbuserinfo[lastvisit] AND folderid=0,1,0)) AS newpm,
                                SUM(IF(messageread=0 AND folderid=0,1,0)) AS unreadpm
                                FROM privatemessage WHERE userid=$bbuserinfo[userid] $ignoreusers");

  $newpm['messages']=$allpm['newpm'];
  $unreadpm['messages']=$allpm['unreadpm']; 


That new PM code doesn't work for me

My new pm's and unread pm's dont show up and the total count for my number of PM's is wrong

- miSt

[Xenon]

Mist look here, perhaps this could help ya:
https://vborg.vbsupport.ru/showthrea...hlight=Queries

[Dean C]

I'll give it a try Xenon

Thanks

- miSt