Hi - my use case is I have several tables with a million+ rows that
change fairly infrequently. These tables are located in customer owned
and managed databases. My app is a J2EE app with a lot of legacy code.
Part of this code constructs dynamic sql against this small subset of
the database.
I'd like to have the following:
J2EE App |-> H2 in memory read only with subset of tables
| ^
| |
|-> Oracle or SQL Server or whatever with all the
tables
So in other words I want to use H2 as a read only cache for a subset
of tables in my database. Every so often (like every 10 minutes) I
want to, as quickly as possible, copy the subset from the big database
to the H2 database. It is acceptable if the data is out of sync for
this period of time.
Thanks!
Rick
--
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.
