I haven't tried 1.4, yet. In 1.3 it really looks like a row size issue to me. Given the same amount of underlying data, splitting it across rows of different lengths gives very odd results. I would expect that the overhead of storing rows would go down as the number of rows goes down (with longer rows), but in fact the size of the data file goes up as the number of rows goes down, at least until reaching some threshold, where it drops. It's pretty nonlinear, which makes me suspect some internal block size, or something.
With 10M of data, 100 byte bins -> 17M data file 200 byte bins -> 17M data file 400 byte bins -> 25M data file 800 byte bins -> 25M data file 1200 byte bins -> 13M data file 2000 byte bins -> 10M data file 4000 byte bins -> 10M data file This is with LOG=1, UNDO_LOG=1. Running "shutdown compact" or "shutdown defrag" has no effect. The "compress" option is only for mv store, I think? On Monday, June 23, 2014 11:09:20 PM UTC-7, Thomas Mueller wrote: > > Hi, > > Did you try with the latest version of H2 (1.4.x)? Please note you will > need to compact the database using "shutdown defrag" after you finished. > And apppend ";compress=true" to the database URL, as Noel wrote. > > Regards, > Thomas > > > > On Saturday, June 21, 2014, Noel Grandin <noelg...@gmail.com <javascript:>> > wrote: > >> If you're worried about disk space, turn compression on by using >> COMPRESS=TRUE in your database URL. >> It will cost a little bit of CPU, but not much, and most of us >> normally have lots of spare CPU power. >> >> -- >> 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 http://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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
