My queries are currently 171.... lol kinda high, I have everything done right, I think... Ive just majorally customized it....
My question is, I am using a lot of board stuff on the vbhome, like the numbers of members, latest members, members birthdays..... so codes like that need to be listed somewhere special to cut down on the queries?
Also a good bit of my queries say this: Query: SELECT parentlist FROM forum WHERE forumid='50'
and the next query will be: Query: SELECT *,INSTR(',8,1,-1,', CONCAT(',', forumid, ',') ) AS ordercontrol FROM forumpermission WHERE usergroupid=6 AND (forumid='8' OR forumid='1' OR forumid='-1') ORDER BY ordercontrol LIMIT 1
It does this for each of the forums, and theres around 80. Is there anything I can do to fix this?
Thanks!
Emma
|