Hi, If you have a read-only database, you could use "Read Only Databases in Zip or Jar File" to get a better compression ratio: http://h2database.com/html/features.html#database_in_zip - but if you compress the whole file / database, you can't do random access any longer. That means reading from the database is much slower.
> Do you have any idea why H2 enlarges the data so much? According to my test, the overhead of H2 is quite low when compared to other databases. Databases do have some space overhead, because typically 50% of a b-tree is empty. For H2 (and some other databases) there is a way to reduce this overhead - see http://h2database.com/html/performance.html#database_performance_tuning "Sorted Insert Optimization". But this only works well if you don't have many updates (updates will split the pages). Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
