AutoNumber slow down performance

vijaymadhavan28 — Fri, 20 May 2022 11:51:14 GMT

Hi All,

I am trying to implement the below SQL script in QlikView to get the latest sequence number and facing performance issue while implementing "AutoNumber" as an equivalent for rank(). Table contains around 1 Million record.

SQL Script:

select id, response_id, seq_num, create_dt, sent_date,
rank() over(partition by id order by sent_date,response_id) as seq_num
from table_name where seq_num=1;

QlikView Script:

Load
id, response_id, seq_num, create_dt, sent_date,
AutoNumber (RowNo(),id ) as new_seq
from
table_name.qvd(qvd)
where seq_num=1;

Could you please advise on how to overcome the performance issue?

Thanks in advance.

Re: AutoNumber slow down performance

MarcoWedel — Fri, 20 May 2022 20:16:55 GMT

see Rob's solution in this thread:

https://community.qlik.com/t5/App-Development/AutoNumber-RowNo-MyField-takes-too-long/m-p/1815069#M66667

topic AutoNumber slow down performance in QlikView

AutoNumber slow down performance

Re: AutoNumber slow down performance