H2 1.4.196 and free space allocated

[Philip Grozdanov]

Hello, I have tried out H2 1.4.196 with MVSTORE and as far as I understand/tested in this version compared to 1.3 for example when we insert data into the database an additional free space is taken/allocated which is reused later on.Is there possibility to use 1.4.196 with MVStore but to make the database not allocate addition free space and reuse it later or reduce that free space which will allocate?

[Evgenij Ryazanov]

Hello.

1.4.196 is an old unsupported version. You should try 1.4.199 first, it has some improvements in that area.

However, MVStore is not the best storage for massive insertions quickly followed by massive updates and massive deletions and so on. It is more suitable for normal use cases. It also provides much better scalability for multi-threaded access.

Old storage backend (PageStore) is still available, you can use it if you wish.