Hi, Yes, you could use H2 and define the tables like this:
create table static_data(data int); create table dynamic_data(data int) not persistent; See also the SQL grammar documentation for details. Regards, Thomas On Mon, May 18, 2009 at 10:16 AM, Gregory Mostizky <[email protected]> wrote: > > Is it possible using H2? > > To clarify this is the use case I am thinking about: suppose you have > an application that needs to monitor tens of parameters across > thousands of PCs. There are two types of data in this application: > static data (IPs, machine types, OSs etc...) and dynamic data > (monitoring results). Static data is persistent - dynamic data does > not have to be persisted across database restarts. In the interest of > performance I would like to store the tables of static data on disk > but tables of dynamic data in-memory. Optionally (but not very > important) I would like to have FKs from static tables to dynamic > tables but not vice versa (as it would break data integrity). > > What would be the best approach to accomplish something like that? > > Thanks, > Gregory. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
