Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Data refresh taking too much time

Hey Guys,

I created a data model from loading a couple of QVD files, joining or concatenating, creating the fact and dimensions to reach to a star schema.

now that everything is ready, I realized that it takes 20 minutes to create the model. 

Some of our QVD files are updated every 4 hours and some of them are updated every 15 minutes.

To capture the QVD changes in the data model, I guess I need to refresh the data every 15 minutes. This means the app will be reloading all the time.

Is there any way to only refresh the data model based on the 15-minute qvds and not all the other qvds?

Many thanks

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Hi,

You should use the binary load option.

You can create one application (QVW) file, which will have the data model created with the QVDs which gets refreshed in 4 hours and then take that as a binary load, and create a data model with the QVDs which gets refreshed in 15 min.

This way you can save the reload time.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Hi,

You should use the binary load option.

You can create one application (QVW) file, which will have the data model created with the QVDs which gets refreshed in 4 hours and then take that as a binary load, and create a data model with the QVDs which gets refreshed in 15 min.

This way you can save the reload time.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Creator III
Creator III

Wow,

Thanks Kaushik

That's an awesome idea, I am gonna definitely try that.

One more thing, Is it possible to do me a favor and check my script at below link and let me know what you think?

Incremental Load on monthly Partitioned QVDs