Re: MySQL mit Cache faster like a H2 In-Memory Mode database

[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

[snookerms]

Yes but, H2 in-memory mode has no cache. I read in documentation.

[Thomas Mueller]

Hi,

> Yes but, H2 in-memory mode has no cache. I read in documentation.

The "query cache" and the "page cache" are not the same... Where did you read this statement in the docs? I may need to change it.

Please note you didn't answer my question.

Regards,

Thomas

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/-/CnfgI0KJpFAJ.

To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

[snookerms]

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:

[Thomas Mueller]

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

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