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