We are having 1 billion phone numbers and we have to search them against numbers which we send for promotion to filter out which are not promotional registered. That is we have lets say 1 million record which we need to search against 1 billion database records.
What would be best and optimized way to search these records and which database should we use?
We are currently using SQL Server and in a batch of 10000 searches it gives result in 20 minutes.
We want real time searching.