Are there any DBs for Java that can be run in an embedded mode with some tables being stored in-memory while loading others from disk? H2 and JavaDB seem to be the two leaders for Java DBs and I know they both have an in-memory mode, but do they make you load the whole DB into memory or can you decide on a table-by-table basis?
A:
Most in-memory databases (such as HSQLDB have ability to cache some (or all) data to disk. Usually it's low enough level so it's transparent to the programmer but certainly is configurable
DroidIn.net
2009-12-19 07:34:38
Are there any docs you could point me towards? From what I saw on the H2 site, in-memory only works if the DB is not persistent.
Ben McCann
2009-12-21 07:42:28
You may want to look at the Terracotta http://www.terracotta.org/
DroidIn.net
2009-12-22 05:58:02