Yes. I found a few causes of the problem. First, the forum search was not using an efficient way of searching fulltext indexes. The SMF developers have promised to have this fixed in RC3 of the forum software, but in the interim I have restricted all search results to a maximum of 5, rather than unlimited.
As well, I have disabled the Who's Online feature, since that's what our host was saying was causing a large amount of server load.
As a more long-term solution, I'm planning on shopping around for a secondary VPS or dedicated server for our site, and moving our forum there, as well as any large bandwidth item, such as future demos, trailers, etc.
