Excessive amount of resources (deactivated)?

[PRODUCER]

(sorry so long, I've got no where else to get help)

My site was deactivated yesterday because of a Wordpress plugin called WP-Wall, it's a chat box that refreshes using Ajax, they said it was causing performance issues. I disabled the plugin and got my site turned back on. Then I come home tonight and my sites deactivated again for the same issue but they didn't tell me what exactly was causing the problem this time.

A little info about my site...a run a music Wordpress site that I post my hip-hop beats on for my members to download, I've got around 9,700 members and get 800-900 visits per day. My site has about 35 pages of beats, each page has 8 "blog entries" ...so that's 8 beats per page. To give you an example of my site here's an image so you can understand what's going on each time someone hits my site: http://img247.imageshack.us/img247/1...examplewp9.gif

The Podpress Player loads 8 times, the Ajax Ratings bar loads 8 times, the L and E javascript hover icons, the Top 10 Beats loads, the AJAX Chat Box (which I actually disabled and still was using too many resources), and the Latest Posts in the forum that loads.

Is this just too much stuff going on for each page or what?!

This is what I was told on Live Chat:

Your account is suspended because it is causing a server issue by using an excessive amount of resources. This is mainly due to poor performance from your MySQL databases and/or website scripts. We have found that your account has examined an average of 803241655 Rows per day and used 11398.357566 seconds of processing time per day. Such a high usage of our resources is bound to cause a high number of problems for a shared hosting server. You will need to optimize your queries and implement caching in your web scripts.

BH shut me off so I can't access my CPanel so I'm just trying to get some opinions from you guys on what you think would be causing the problem.

(Also if anyone is interested, I'd be willing to hirer someone to go through my website and database and look at everything once BlueHost turns me back on, it could be a mess in there and I wouldn't even know it)

[felgall]

Did you have one of the caching plugins installed in WordPress? They help reduce the database lookups by saving copies of web pages for several hours so that the same page only needs creating once even though there an be thousands of accesses to it during that time.

[PRODUCER]

No, I don't have one installed. The Super Cache plugin just didn't seem like it would work with my site because of the other plugins I use; WP-Ratings, the Ajax Chat Box, the "Latest Forum" box, WP-UserOnline, etc. Plugins that update live or when a page is reloaded. The cache plugin would screw that up I think?