I got a dedicated server (running Windows 2008 Standard Edtion) with two hard drives. I have a web app (written in ASP.NET) that should be running on this server, the web app uses MySQL which should also be running on the same server. Also there will be the user photos which reside in the same folder as the app folder. Most access will be to MySQL and the user photos.
So, is it better to use the second drive for both the app and MySQL data files so that I leave the first drive for the OS
Use the first drive (which also has the OS files) for the web app and the second drive for MySQL so that I lower the access time.
Which approach should yield better performance?