Generally, I'm a big proponent of giving H2 lots of cache; it always seems to help. But it seems intuitive that you shouldn't need the cache for in-memory databases. Sadly, I remain too busy to futz with it and find out right now. ;-)
On Tue, Jan 26, 2010 at 4:38 PM, Thomas Floracks <[email protected]>wrote: > Did you get an answer? > We increased the cache size from it default value (20MB?) to 128MB and > the effect on performance has been positive, at least not > negative. :-) > > Thomas > > > On Jan 26, 10:23 am, Chris Schanck <[email protected]> wrote: > > I've had this same question? I wondered if H2 even allocates the cahce if > > you running in-memory? > > > > Chris > > > > On Tue, Jan 26, 2010 at 9:40 AM, Thomas Floracks > > <[email protected]>wrote: > > > > > > > > > Hi, > > > > > we are running an all in memory database with H2. I wanted to know if > > > you recommend using an additional cache in memory or should we set the > > > cache to 0 (CACHE_SIZE=0). > > > > > So my questions is basically if a cache with an in-memory database > > > provides any performance benefits or is it just a waste of memory. > > > > > We are using the last stable release 1.1.118. > > > > > Best, > > > 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]<h2-database%[email protected]> > <h2-database%[email protected]<h2-database%[email protected]> > > > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/h2-database?hl=en. > > > > -- > > C. Schanck > > -- > 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]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- C. Schanck -- 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.
