Warning message before loading a DB in memory

Etienne CAUSSE

Hi all, 

following our discussion here: Full RAM Mode / Benchmarking : how much time does it take to load your DB in RAM ? 

Issue

In a development environment, we are often in the situation where we have to duplicate databases to carry out testing, parallel developments, and so on. A number of similar and big databases can be on the server at the same time, and the RAM limits how many we can load in memory.

However if I select a DB in the DB list, it will be loaded in memory automatically without warning, even if this loading takes 1 hour.

 

Workaround:

We're trying to be careful...

 

Idea:

Implement a warning message and confirmation before loading a DB in memory: "This database is not in memory, do you want to load it ?"

 

 

 

Monisha Jain

Thank you for sharing your idea, Etienne. We understand the need of this solution.

We are working on the new dynamic engine which is a kind of hybrid form of in memory engine and standard database. This option will simplify and reduce the loading time drastically as only the queried data will be loaded in memory. So this will reduce the RAM comsumption along with an increase in the speed to load the database. We are aiming to release this by the beginning of 2024.

We encourage you to continue submitting your ideas and suggestions in the future, as we are always open to hearing new perspectives and feedback.