Hi,

Below is my db connection url that I am using

*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;*

I have created just one table having 10 columns with string and long 
datatypes, string datatypes has no more than varchar(200) size. The table 
has around ~5 lac entries, however the size of db is around 500 MB, 
isn't it huge ? Am I missing something in connection string so that the 
size of db file which is created is bit compact.

I tried with *DEFRAG_ALWAYS=TRUE *option in above connection string, but it 
doesn't made much difference.



-
Jai.

-- 
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to