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!

[Marco van Herwaarden]

If you have questions/problems with a modification, then please post in the thread (or support forum/board) about that modification. Best chance to receive a reply from either the author or another member using the same modification.

[lasatormentadas]

OK, I´m sorry,

[Awjvail]

vBShout doesn't cause a large database.. I have over 35000 shouts in my shoutbox and the shoutbox database is only a few mb big.

[djdonx]

vBShout does use up a large amount of your bandwidth I think...

[Paul M]

According to what you posted, your shout database has 166,396 records in it - if it's not using indexes then it's going to slow down. I suggest you prune it down to a much smaller size.