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 -~----------~----~----~----~------~----~------~--~---
