In-Memory Databases
-
Do in-memory database systems such as Prevayler or commercial products have a user-specifiable number N, such that if the system uses more than N bytes of RAM, the system will use virtual memory? That way the database system would use the operating system's virtual memory smarts for managing what goes on disk and what goes in memory, while providing the ability to have a larger database than just what will fit in available RAM.
-
Do in-memory database systems such as Prevayler or commercial products have a user-specifiable number N, such that if the system uses more than N bytes of RAM, the system will use virtual memory? That way the database system would use the operating system's virtual memory smarts for managing what goes on disk and what goes in memory, while providing the ability to have a larger database than just what will fit in available RAM.
I'd expect that such products (at least Bamboo Prevalence) will use virtual memory when necessary, as Windows may allocate more memory than the RAM available when an application asks for it. As for setting the limit for when virtual memory will be used, Bamboo Prevalence does not expose such a setting. Maybe the OS will let you set such limits...!?!?
Have a look at my latest article about Object Prevalence with Bamboo Prevalence.