Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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