What is faster parsing XML or SQL query?

Question

PHP

There is a large dictionary, you need to make queries to it and get information about the word, what will be faster, read from the dictionary in XML or upload it to the database and make SQL queries?
Actually the dictionary is taken from here: opencorpora.org
At the same time, tell me, if anyone knows how to quickly transfer it from xml to the database, maybe there is already a solution, I did not find it.

Answer 1

It's faster to put it somewhere in the nosql-storage thread

Answer 2

The base will be faster due to the use of indexes.

Answer 3

In the case when it is possible to present well in the form of linked tables, then I would choose SQL DBMS. If you need quick access to a large amount of data by key, then you can look towards KEY-VAULE DBMS (for example, redis), but if the data cannot be well structured, then you will have to use document-oriented DBMS (like MongoDB). But just an xml document and using something like xpath I will only choose when I have no choice.