First thing you need to do is to identify why the web site is slow. Once you've found the cause of the slowness, it's often fairly easy to fix.
Performance monitor and profiler are your friends here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability