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
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
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
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