Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

chriys1337
Contributor II

Benefit of using Autonumber() although key is already numeric?

Hi Qlik experts,

I am using a datamodel where all tables come from an SQL database and all keys are coming from there as numeric (with 6-8 digits).

Now my question is, would a additional autonumber() around all key fields bring any benefit in this scenario? Or would this end up with additional calculation / script time, but no performance benefit?

 

Thanks for your help!

 

chriys

Labels (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Benefit of using Autonumber() although key is already numeric?

AutoNumbered values will be sequential integers.  Sequential integers do not require a symbol table to store the field values.  Therefore an autonumbered field will use less RAM.  

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

3 Replies
MVP & Luminary
MVP & Luminary

Re: Benefit of using Autonumber() although key is already numeric?

AutoNumbered values will be sequential integers.  Sequential integers do not require a symbol table to store the field values.  Therefore an autonumbered field will use less RAM.  

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Highlighted
MVP
MVP

Re: Benefit of using Autonumber() although key is already numeric?

Rob - I assume you mean: Sequential integers do NOT require a symbol table to store the field values. 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP & Luminary
MVP & Luminary

Re: Benefit of using Autonumber() although key is already numeric?

Yes, thanks for the correction.  I updated the post. 

-Rob