topic Re: Benefit of using Autonumber() although key is already numeric? in App Development

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

chriys1337 — Sat, 16 Nov 2024 06:57:22 GMT

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

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

rwunderlich — Wed, 02 Jan 2019 15:32:31 GMT

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

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

jonathandienst — Wed, 02 Jan 2019 06:31:19 GMT

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

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

rwunderlich — Wed, 02 Jan 2019 15:33:07 GMT

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

-Rob