Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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/
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/