Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Does the use of Autonumber function improve the front end performance of a dashboard? If so, how?
Let´s say you have 30 or so table associations and none of them use AutoNumber.
No, AutoNumber() is an Script function, you cann't use this.
To generate sequences or numbers for columns in UI, You should use Above() or Below() functions. By these functions you may improve the performance.
Using autonumber() for large key-fields could improve the performance especially if these keys are strings like:
category & '|' & channel & '|' & WhatEver
because instead of the string a number is used to make the association (number-processing is always faster as the processing of strings) and this number needs not to be separately stored because the number is identically with the pointer of the field (each field creates an indexed symbol-table with only the distinct values of the field and this index is then used as pointer to the data-tables).
- Marcus
Hi Marcus,
Thank you for this.
I take it you wouldn't do autonumbering on date based associations since they are already stored as numbers?
Yes, I wouldn't do it by a date because often it's handled like an autonumber-field (if numbers are continuous Qlik stored the offset-value to 1 and could treat them with an autonumber-logic). Further even by 10 years this are just 3650 distinct values and it would nearly unnoticeable from a performance point of view if it is optimized in any way.
- Marcus
Yes
Autonumber() improve the performance of application.
When you use autonumber in script to generate key like Autonumber(customerId,customerName) as customerKey then it will save this customer key as arbitarary number .
As you know qlik creates symbol table for every table to store values in byte and bytes needed to store num value is always less than that of text value.
here key is in num format instead of text that's why association will be fast and space needed to store the data is also less.
So finally your performance will get improve.
Regards,
Arvind