BLOB's aren't compressed by default, because by default blob's will be saved as a single file, in stead of in the database. So the SET COMPRESS_LOB<http://www.h2database.com/html/grammar.html#set_compress_lob>function is only for external LOB and BLOBs.
This text say's H2 data is compressed by default. I can see this also in my benchmark results: "Compresses the data using the specified compression algorithm. Supported algorithms are: LZF (faster but lower compression; *default*), and DEFLATE(higher compression)." But is there anyway I can disable it? Vincent 2010/12/21 Ryan How <[email protected]> > I didn't think it compressed by default. From the documentation... > Large Object Compression > > CLOB and BLOB values can be compressed by using SET > COMPRESS_LOB<http://www.h2database.com/html/grammar.html#set_compress_lob>. > The LZF algorithm is faster but needs more disk space. By default > compression is disabled, which usually speeds up write operations. If you > store many large compressible values such as XML, HTML, text, and > uncompressed binary files, then compressing can save a lot of disk space > (sometimes more than 50%), and read operations may even be faster. > > Or does it do some sort of de-duplication by default? > > Ryan > > -- > 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]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- 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.
