I am designing a new system that will be dealing with large data set. This system is expected to have over 10 million records. A user of the system needs to check for the availability of the name he wants to register. If nothing is returned, that means the name is available, the user can then proceed to register the name.
The database needs to be optimized for search. I was considering using mysql, but i don't know if there are better options. Thanks