Error with the script and possible with the vbshout 2.0 PLEASE WE NEED HELP!

[lasatormentadas]

Hello,

I?m the webmaster of the site www.atormentadas.net, we have a vbulletin forum in that hosting.

We have received an email from the server (www.siteground.com). They say there are several errors in our script, that are slowing down the server. And that they will suspend our account if we don?t fix them.

The reasons for such slow queries can be several:

1. Large database
2. Not well written scripts
3. Large number of internal links that query the database directly.

The problem is that we don?t understand where the problems are coming from, but we have some idea, we think they come from the vshout 2.0 we have installed. The repeated error they told us is ONE of the errors they found, is this one:

# Time: 071026 6:17:06
# User@Host: atormen1_atormen[atormen1_atormen] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 166396
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s

I would like to know if someone have had the same problem, and if so, HOW YOU FIXED THEM?

Just shutting off the vbshout? Is there any update that works better than the version 2.0?

Is there any FAST way of finding another possible problems?

Thanks very much for your help!