Is it possible to store the database cache in RAM?

Question

linux

The idea is as follows: when the application starts, load the entire database into RAM in the form of objects and asynchronously change its contents during the program, eliminating the need for multiple disk reads. Concerned about the issue of overflowing the RAM - how real is this threat? Is this problem solved by caching the RAM at the operating system level?

Answer 1

Any normal base itself is engaged in competent caching in memory, and double-triple caching is not needed. You can simply load objects into memory and access them instead of the database. But if you change them, then you need to save regularly. The base does this on its own, so it makes no sense to make a bike.
It makes sense to tune something if you have such a highly loaded project that standard tools do not solve the problem.

Answer 2

Only for reading.