Re: [h2] some data size increase tests

2014-07-08 Thread Brian Craft
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 longe

[h2] Re: Reduce space usage with repeated strings column values

2014-07-08 Thread Jose Schiavon
How about a mapping table and a view? Your varchar column would be replaced by an int or even by a tiny int. On Monday, 7 July 2014 19:14:03 UTC-4, gaurav wrote: > > Is there any option to reduce space usage for varchar type columns when > the values for some of the columns may be repeated, bel

Re: [h2] IO Exception: "java.io.IOException: Stream Closed"; [90031-168]

2014-07-08 Thread Noel Grandin
You are could try playing with cache settings, that might help mask some of the latency. On 2014-07-08 12:45 PM, Tomasz Chmielewski wrote: Thank you Noel. This is what I suspected, but hoped there is some way to fix it or make it more stable. On Tuesday, July 8, 2014 8:37:08 AM UTC+2, Noel Gr

Re: [h2] IO Exception: "java.io.IOException: Stream Closed"; [90031-168]

2014-07-08 Thread Tomasz Chmielewski
Thank you Noel. This is what I suspected, but hoped there is some way to fix it or make it more stable. On Tuesday, July 8, 2014 8:37:08 AM UTC+2, Noel Grandin wrote: > > > > On 2014-07-05 08:22 PM, Tomasz Chmielewski wrote: > > I'm using eclipse PDT, which uses H2 DB for indexing data. there ar