I'm thinking of using H2 as an in memory cache for an external
relational database, which is not under my control. Does that make any
sense? The reason I thought of this is because the data model fits the
relational model very well. Trying to use a cache solution based on
objects and Maps to achieve O(1) response is to complicated and seems to
be wasteful on memory, for this model mainly because of the way we
access the information.
Today's DB's are also performant, and for information systems they
usually respond quickly enough. (They also hold alot of the data in
memory depending on their systems memory and Db size). So part of my
question is whether I need to cache this information anyway.
The use of this data is almost all read, hardly ever writes. There are a
lot of reads from this data model in a single transaction though, some
times queries are for a single object, some times for a group of objects
depending on a rule.
appreciate any insight...
Thnx
--
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.
