When to use MV_STORE=FALSE?

[Reinier L'abee]

Hi all,

I read about MVStore on the website, but are there any specific advantages compared to the old storage when using H2 as a pure JDBC database? I use version 1.4.188 and I'm wondering whether or not I should use MV_STORE=FALSE. The database contains several million rows and I use it in embedded mode. It seems that MVStore takes somewhat more disk space.

[Thomas Mueller]

Hi,

The MVStore is relatively new and not yet as mature as the old storage mechanism (the PageStore). See also the documentation at http://h2database.com/html/mvstore.html . Some advantages compared to the PageStore are: multi-version, simpler, more concurrent, writes less, optimized for SSDs. Disadvantage is that it temporarily needs more disk space, and is currently a bit slower.

The PageStore is quite mature and will be supported in the future for some time. However, support will be phased out eventually.

Regards,

Thomas

On Wednesday, August 5, 2015, Reinier L'abee <reinie...@gmail.com> wrote:

Hi all,

I read about MVStore on the website, but are there any specific advantages compared to the old storage when using H2 as a pure JDBC database? I use version 1.4.188 and I'm wondering whether or not I should use MV_STORE=FALSE. The database contains several million rows and I use it in embedded mode. It seems that MVStore takes somewhat more disk space.

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.