Loading tables "row by row" works very slowly. How to improve performance?

[#1]

Hi!

Please look  the mock-up :

for i = 1 to 10000

//some calculations...

...

//store result:

  Table1:

  load ... as field1, ... as field2, ... ; //exactly one record

next

//now resulting table have 10000 rows

When I load rows "step by step" and a significant number of loop iterations - it takes a lot of time.

Is it possible to improve performance?

Thanks in advance,

Oleg

[Anonymous]

Hi Oleg,

Do you have a row identifier in the underlying table?

Antoine

[swuehl]

You can create a loop in your LOAD statement itself, using WHILE or AUTOGENERATE, then use ITERNO() resp. RECNO() as index for your calculations instead of i and perform the calculations within the LOAD.

Here are some basic example for calendar calculations:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

[#4]

Hi, Antoine!

Yes, I have a row ID

[Anonymous]

Is its structure sequential?