topic Re: ID Columns in App Development

ID Columns

arusiva89 — Thu, 09 Apr 2020 13:41:41 GMT

Hi All,

I have a lot of unique records and everything needs to be shown in UI so I cant use Autonumber().Any other solution to reduce space?

Re: ID Columns

Vegar — Thu, 09 Apr 2020 14:14:48 GMT

You are basicly stuck to the RAM consumption of your fields if you can't do anyting to the field content.

One consideration to do is to make sure you load your qvd containing the data optimized in your final application. I have not laborated so much on this my self, but @rwunderlich wrote a blogpost on the topic back in 2008. It can be worth your while - QlikView Cookbook - When less data means more RAM .

Re: ID Columns

arusiva89 — Thu, 09 Apr 2020 14:29:40 GMT

Thanks @Vegar for your valuable suggesion. I will check that