Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

Qlik Sense: Different load frequency depending on table?

Hi all,

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).

Please let me know your thoughts and experiences.

Thanks much,

Juan

2 Replies
chriscammers
Partner - Specialist
Partner - Specialist

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.

tomasz_tru
Specialist
Specialist

It's also posible to do it in only two apps. In ETL script if condition:

'if there's different day in technical table than today(1) load the daily data and update technical table with actual date.'