Autonumberhash function

[Anonymous]

Dear all,

I would understand how to use the function in object. I've several tables linked by a very long char & number keys (for example Customer & year & month & contract & order & coutnry ....)

I have read that using this function, is possible to reduce RAM usage and speed up Qlikview applications.

May I have any further in order to understand how can I use it and when ?

Thanks in advance for your help

[sreenivas · Accepted solution]

AutoNumber(Customer & year & month & contract & order & coutnry) as FieldKey

[khadeer]

Autonumber, Autonumberhash128, Autonumberhash256 functions used for same thing.

It automatiacally generate an unique number. Basically we use in creating keys like composite keys.It will give the exact result.It will reduce the RAM usage also. Whenever u r creating composte keys it will be best to use autonumber function. For more read help n check in reference manual.

Regards,

Khadeer

[Anonymous]

Thanks for your answer,

but two questions are occuring in my mind:

- is there any performance differences using autonumber, autonumberhash128 or 256 ?

- when is it better to use them ? My application is composed by two docs: the first one reads all table from the db and stores them into qvd files, the second one retrieve data from qvd files and provides to create reports, graphs,..

The question is: is it better to use autonumber into the loading from db or later ?

Thanks in advance fo your suggestions

[farolito20]

I prefer into de loading from db