topic Re: Load millions rows in QlikView

Load millions rows

Black_Hole — Fri, 10 May 2019 08:56:17 GMT

Hello all,

In the edit script, I make a connection to my ODBC. Then, I load a table from my database.

But when I run my script the loading take a lot of time due to the number of rows in my table.

Please could you tell me what I can add in my script in order to reduce the time of loading.

Thank you in advance for your help.

Gysbert_Wassenaar — Fri, 10 May 2019 09:08:21 GMT

Perhaps you can implement incremental loading so that you don't need to retrieve all the records every time.

Black_Hole — Fri, 10 May 2019 10:51:38 GMT

I will try this solution.

Thank you very much for sharing the links.