The webserver itself does not have to be a monster. My slowest Apache server is 7600/132MHz and it is capable to fill the bandwidth of my 2.3Mbit SDSL line, even with complex MySQL / FM7SA queries. However the FM7SA is a dual AMD Athlon64 3200, and the MySQL server is a dual AMD 1600MP.