How to increase DBMS performance? Is it possible to store a database in RAM?

V

Vadim Ivanenko2016-09-12 18:21:30

MySQL

Vadim Ivanenko, 2016-09-12 18:21:30

There is a database of several hundred megabytes and it will not increase significantly in volume.
How can you maximize the speed of working with this database?
I guess the fastest way is to keep the whole db in ram.
Interested in possible solutions for MySQL and MS SQL Server.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

P

Philipp, 2016-09-12
@supra7sky

dev.mysql.com/doc/refman/5.7/en/memory-storage-eng...

A

Alexey, 2016-09-12
@k1lex

Indexes. And, perhaps, the most important thing is correctly written queries to the database.