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]> > > . > > 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.
