Answer the question
In order to leave comments, you need to log in
Is it possible to make a fast database?
Good afternoon!
There are many excel files. Each file has approximately 100 columns. In total, for all files, about 30 million lines will be obtained. Is it possible to drive this case into some kind of database so that it is convenient to quickly filter / sort this data?
Answer the question
In order to leave comments, you need to log in
Any one you know how to work with.
30 million rows for modern DBMS is nonsense.
Take MS Access and import it there. They didn't teach you how to work with him at the university? (a reference to modern teaching of database theories and everything about the database in universities, do not be offended)
In fact, everything is simple in it and in your case sounds like a solution
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question