Qlik Sense: Different load frequency depending on table?
I'm thinking of ways to improve the data load in my Qlik Sense application. In the QMC I've configured the task to load data every 15 minutes, but I see that my load script is already taking around 12 minutes to load, so it looks like I may be pushing things maybe a bit too far.
Do you know if I can somehow load certain tables more often that others? I could have tables that load once per day, and let the others every 15 minutes (or even 5 minutes).
Re: Qlik Sense: Different load frequency depending on table?
You're going to have to set up multiple dedicated ETL apps.
You can set up an app to do the 15 minute data and write it to qvd files.
Then another app to extract the daily data written to qvd files.
Finally your user facing application would have a reload task with a trigger for each ETL app.
I would make sure you are not running your 15 minute data when you are running your daily data so you don't run into io conflicts where you might try to read a qvd at the same time it is being written.