Hi, > BLOB's aren't compressed by default
That's true, BLOB and CLOB data is not compressed by default. Well, CLOB data is stored as UTF-8, but I guess this is not really 'compression'. However, H2 does support BLOB and CLOB compression - see also http://h2database.com/html/advanced.html#large_objects "Large Object Compression" - but it's not enabled by default. But for H2 version 1.3.x, duplicate BLOB and CLOB blocks are only stored once. I guess that's why your database file is smaller than what you expect it to be. This is not really compression in the sense of LZF / Deflate / ZIP, it's just avoiding to store duplicate blocks twice. See also http://en.wikipedia.org/wiki/Data_deduplication > This text say's H2 data is compressed by default. You have read the documentation so out of context it's almost criminal. The documentation is for the built-in function COMPRESS(dataBytes [, algorithmString]) - The LZF is the default algorithm only if you actually USE this function, and don't specify the algorithm. But I guess you don't use COMPRESS explicitly. 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.
