I want to build a database of available domain names and was hoping for a little input as to an efficient structure.
I'll only be storing 3 pieces of info.
Full Domain name
extension only (.org,.com,.net)
date domain was made available.
I'll be adding new domains daily and would imagine making a table for each month? There will be about 500,000 new entries each month. I also need to load in historical data which comprises about 29 million entries.
Any suggestions as to the best structure for this data that will make for the most efficient searches? Should the extension field be an ENUM for example.