Connection string for using MVStore

Skip to first unread message

Jai Jamba

May 2, 2018, 4:59:29 AM5/2/18
to H2 Database

I am using h2 db, below is my connection string.


However I have noticed that DB file size is huge in version 1.4.197, I posted in this group few days back (!topic/h2-database/pViJVgJPOGo) but no one replied.

I was reading about MVStore, so I was wondering what would the connection string would be in case I need to try out ?


Noel Grandin

May 2, 2018, 5:08:19 AM5/2/18
to, Jai Jamba
You are already using MVStore.

If you want to use PageStore, the older storage engine, add

to your database URL

Jai Jamba

May 2, 2018, 7:30:17 AM5/2/18
to H2 Database
Hi Noel,

Thanks for reply ! 

Could you please tell me what should I do to minimize the size of database then, how can I compress it ? There are no special fields as such, only 10 columns mostly with varchar with size of 200. It had around 5 lac entries but the size of db is around 1 GB.
Reply all
Reply to author
0 new messages