Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Group by Performance tuning

Hi Folks,

I am trying to optimize the Datamodel reload time.

As I am using Group by function for  few calculations in the script, datamodel is taking around 38mins to complete the load for entire application. Where as I have 80+ fields including Dimensions and Measures in my fact table. I need to include all fields into group by as those are using in the UI and also tried the below logic, but there is no change in the loading time .

App Size: Around 1GB

Data: 2yrs 6Months

Facts: 1 Fact.

Flat Sources: 4 ( Using Mapping load )

https://community.qlik.com/t5/Documents/Optimize-Group-By-Performance/ta-p/1481470/page/2/show-comme...

 Could anyone tell me how to reduce the loading time by using any technique.

@sunny_talwar , @Anil_Babu_Samineni , @tresesco  

Thanks in advance !!

Krishna

1 Solution

Accepted Solutions
krishna20
Specialist II
Specialist II
Author

I have reduced the reload time by 10mins. 

Created a separate table for group by calculations and created composite key to link fact .

Still working on optimizing the reload time.

View solution in original post

2 Replies
krishna20
Specialist II
Specialist II
Author

Can anyone throw any clue ?

krishna20
Specialist II
Specialist II
Author

I have reduced the reload time by 10mins. 

Created a separate table for group by calculations and created composite key to link fact .

Still working on optimizing the reload time.