Connection string for using MVStore

42 views
Skip to first unread message

Jai Jamba

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

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

jdbc:h2:file:${dbstorage.path}/dbstore;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=FALSE;AUTO_SERVER=TRUE;MULTI_THREADED=TRUE;CACHE_SIZE=131072;MVCC=FALSE;

However I have noticed that DB file size is huge in version 1.4.197, I posted in this group few days back (https://groups.google.com/forum/#!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 ?


-
Jai

Noel Grandin

unread,
May 2, 2018, 5:08:19 AM5/2/18
to h2-da...@googlegroups.com, Jai Jamba
You are already using MVStore.

If you want to use PageStore, the older storage engine, add
;MV_STORE=FALSE

to your database URL

Jai Jamba

unread,
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
Forward
0 new messages