Hi, The CPU usage of the compress option depends a lot on the CPU and storage system you have. For a fast CPU and a slow storage, using compress makes more sense than if you have a slow CPU and a fast storage system. I'm afraid you need to run your own tests...
Regards, Thomas On Friday, February 5, 2016, <[email protected]> wrote: > Hello all, > > Firstly, let me say thanks for the selfless work that all the contributors > to H2 have made, outstanding. > > We've been using H2 as our Raspberry Pi storage system for a little while > and have had some challenges. One of the more obscure settings is COMPRESS. > When we run with this turned on, it gives us at least a 50% saving in disk > space (this is significant because we run off a RAM disk with periodic > online backups). > There is obviously a CPU price to pay, anyone have any idea what that is? > > We are using 1.4.191 > > Thanks, > Steve > > -- > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
