One database with 20 million records or 51 databases with 50,000-300,000 records in each database?

Question

I bought a working CSV United States database with ~ 20 million records, which is divided into 51 databases, each database represents a state.

I need to write an ASP.NET MVC web application that will query this database for state and more arguments. Should I create a SQL Server database and import all records into all 51 CSV files? Or maybe I should request the csv files directly? What will be faster? Feel free to suggest other solutions.

Thank.

Answer 1

, . .

, "" "". . .

-, , . , .

.

Answer 2

. 20 - .

Answer 3

I would import the data into one large database. As long as the table is properly indexed, it will offer better query performance, instead of scanning each file, it should be able to use the correct indexes to speed up the work.