I am starting on a next to impossible journey to build a database with many records and with relational databases at a later date possibly.
The primary database I am going to build will have approximately 10 million records in it.
Each record will have 75 - 100 items of information within that record.
It has been suggested that I use a MySql or MsSql database for this. I wanted to get some other input on what database software would be the most efficient to handle something of this size efficiently and quickly. Time is always of the essence. So if there are any suggestions, recommendations, or points of direction at software to look at or start with please post them.
Thank You for any input...