What type of database is the fastest?

Question

Database

Until recently, I thought that NoSQL databases were the fastest, then I was told about the "column" ClickHouse database, which is faster than nosql.
But in addition to columnar and NoSQL, there are, in theory, how many types of different databases
. I would like to know which type of database is the fastest?

Answer 1

What is the fastest transport? F1 car? And if with ten tons of cargo? And if on rough terrain? What if it's on the water? Got the message? The speed of certain types of DBMS depends on the operating conditions. In some conditions, one will be faster, in others the other.

Answer 2

KeyValue inmemory

Answer 3

You can talk about read speed and write speed.
In order to achieve maximum speed in these two cases (in the context of using NMJD), there are two types of databases: row and column.
Row databases store table data row by row, i.e. first the 1st field of the record is sequentially written to the track of the disc platter, then the 2nd, 3rd, etc. Then the next entry is written in the same way. In this case, the maximum recording speed is achieved. But when reading, even if you request one field of the table, all rows that are affected by the request will be read into memory from disk.
If you need maximum reading speed, then choose a columnar database. Columnar database data is stored on disk by fields (columns) and reading is very fast.

Answer 4

The fastest are hashmaps in the application memory. But the question is actually more complex. As soon as we need to join 2-3 tables, then the complex quantum mechanics of the optimizer works and the whole matrix becomes the speed options.