How to store large amounts of data with the ability to search through it?

Question

Database design

There are over 100 GB of text data that can be represented in multiple tables. It is necessary to implement storage and fast (not for 20 minutes) search. What local database would you recommend?

Answer 1

Finding Documents in Windows 10 .

Answer 2

Any. It all depends on the structure of the relationships between these tables and the correctness of queries to select the necessary data from this database.

Answer 3

You can install a local search engine if the system search slows down. But if these are tables in essence, then it is optimal to fill in the texts with a script into the database and configure the search there.