Connection string for using MVStore

[Jai Jamba]

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]

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]

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.