92 queries in forum index

Hi,

I just found out that my index page has more dan 92 queries, my host is starting to complain :nervous: How can i reduce the amount of queries??

I have a lot of hacks installed

hidjra

[Erwin]

If I can see your ?explain=1 then I can hack into your board. 2.2.6 and up have disabled this function because of security issues. As TECK said, remember to upgrade. And well done - 33 is very reasonable indeed.

[hidjra]

thanx for all the help guys :squareeyed: . Now i seem to have the same problem with my showthread file, there are 59 queries, and for some reason these 2 queries are repeated for about 20 times, there must be a loop somewhere, i just can't figure out where;

- Query: SELECT usergroupid FROM user WHERE userid=4518
- Query: SELECT moderatorid FROM moderator WHERE userid='4518' LIMIT 1

can someone please help me :ermm:

hidjra

[g-force2k2]

PHP Code:

$DB_site->query_first("
  SELECT user.usergroupid AS usergroupid, moderator.moderatorid AS moderatorid
  FROM user
  LEFT JOIN moderator ON moderator.userid = user.userid
  WHERE user.userid='$bbuserinfo[userid]'"); 


I haven't tested this but it should work regards...

g-force2k2

[hidjra]

Originally posted by g-force2k2

PHP Code:

$DB_site->query_first("
  SELECT user.usergroupid AS usergroupid, moderator.moderatorid AS moderatorid
  FROM user
  LEFT JOIN moderator ON moderator.userid = user.userid
  WHERE user.userid='$bbuserinfo[userid]'"); 


I haven't tested this but it should work regards...

g-force2k2

thnx g-force, but where should i put this? :surprised:

hidjra

[g-force2k2]

just put it in place of the other two queries where ever they appear together... regards...

g-force2k2