Hi, > 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?
Yes. However it's not trivial to implement such a caching solution. > 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. If it's mostly random access reads, then using a solid state disk may be a good idea. P.S. please don't double-post. Regards, Thomas -- 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.
