It's not just the traffic. It's applications that use the database.
www.suzuki-bikes.com gets the same amount of traffic as Aaron's site, but it doesn't use anywhere near the same amount of CPU.
A few things can run up the CPU like crazy - like a spell checker some phpBB's use.