Interview Question in Sql Server 2000


 

Interview Question :: Best practice for DB server and web server

Hi guys,

I'm setting up a sales information system, and I'm using MS SQL 2000 for my DB and PHP.. My question is, what is the best practice for server setup. Is it much faster to host the web server and the DB server on the same machine or to have them hosted on a separate machine. The system is already working fine, the codes are already optimize. Right now I'm having problem with the speed of the quiries specially for long long date ranges. thanks..
by ksk