phpBB does generate a lot of SQL queries. There is some additional overhead due to the phpBB-seo mod, but seriously, it's not enough to tip your CPU usage over the edge. For a shared host, 4000+ visitors is a lot. If you have other mods, you may want to double-check they're not generating excessive ...