Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

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
Partner
Partner

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.

tomasz_tru
Valued Contributor

Re: Qlik Sense: Different load frequency depending on table?

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