Hi, The setting "CACHE_SIZE" has no effect for in-memory database, that is true.
But I was talking about the "query cache", see http://h2database.com/javadoc/org/h2/constant/DbSettings.html#QUERY_CACHE_SIZE By the way, there are other caches as well: the "collator cache", the "object cache", and the "server object cache", see: http://h2database.com/javadoc/org/h2/constant/SysProperties.html Regards, Thomas On Tue, Oct 16, 2012 at 7:06 PM, snookerms <[email protected]> wrote: > I read it a lot of time. In everything with Cache. There stand "has no > effect on in-memory database". > > > Am Freitag, 12. Oktober 2012 16:40:55 UTC+2 schrieb Thomas Mueller: > >> Hi, >> >> The benchmark probably does not match what you do. >> >> > When I use query cache the MySQL Performance is better like the >> H2-In-Memory Performance. >> >> Do you run the same query multiple times? H2 also has a query cache, but >> it depends on your application. >> >> Regards, >> Thomas >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/Jtct8Qi23iEJ. > > 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. > -- 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.
