I need to create a database that can handle somewhere between 100GB and 1TB of mostly numeric data, and a .NET or a Java application which utilizes this database. There won't be multiple users, but speed is of primary concern. I would prefer running this database and the application in a high-end PC, not a server.
I've been considering both MySQL and MS SQL Server. Would MySQL be enough, or should I consider MS SQL Server or other database systems?
Thanks for your advice in advance!