Load millions rows

[Black_Hole]

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 · Accepted solution]

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

Here's a search string to find discussion about incremental loading on this site:
https://community.qlik.com/t5/forums/searchpage/tab/message?q=incremental%20load&page=2&collapse_dis...

And here's a good blog post about the subject: https://www.quickintelligence.co.uk/qlikview-incremental-load/

[Black_Hole]

Hello @Gysbert_Wassenaar ,

I will try this solution.

Thank you very much for sharing the links.