Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

QVD calling in to Dashboard

Hi All,

I have two qvds one is oracle data stored qvd and red shift  data stored qvd.

Both qvd are same table, same logic of query, same no of fields, same count of records .

But when i call qvd in to the final dashboard  oracle data  qvd is fast and red shift data qvd is slow. 

Below are the details:

Oracle data stored qvd-> calling in to  Qlikview final dashboard -> taking 1 hr. for 21 crores record

Red shift data stored qvd-> calling in to  Qlikview final dashboard -> taking 2 hr. for 21 crores record

Please help me what can be issue to resolve this Red shift data stored qvd calling fast . 

1 Solution

Accepted Solutions
rwunderlich
MVP & Luminary
MVP & Luminary

1. Are you using the same LOAD statement for both in the dashboard?

2. Are the files located on the same or different disk?

3. Are the files the same size?

-Rob

View solution in original post

4 Replies
mfchmielowski
Contributor III
Contributor III

Hi.

Can you share the load script ?
I think that second table is loading with concatenate instruction (but it's only a gues) and thats why it's slower.

manoranjan_d
Specialist
Specialist
Author

hi

I can't share the script but there is concatenate logic in both the load script and finally storing in qvd. the only thing is qvd should be fast , why its differ, as per the qlikview logic qvd should be fast.

  

 

 

rwunderlich
MVP & Luminary
MVP & Luminary

1. Are you using the same LOAD statement for both in the dashboard?

2. Are the files located on the same or different disk?

3. Are the files the same size?

-Rob

View solution in original post

manoranjan_d
Specialist
Specialist
Author

Hi Rob, Thanks

1 Are you using the same LOAD statement for both in the dashboard?

Yes

2. Are the files located on the same or different disk?

No- from this i started analyzing and got  solution. Below is the explanation

Oracle data stored qvd-> calling in to  Qlikview final dashboard -> taking 1 hr. for 21 crores record-> this is done PROD server-384 gb ram

Red shift data stored qvd-> calling in to  Qlikview final dashboard -> taking 2 hr. for 21 crores record-> this is done in UAt server-384gb ram

So I tried moving the Red shift data stored qvd from UAT to PROD server and then ran the qlikview final dashboard-> took only 45 mins😀

Due to UAT server I might think that many application can run, but the server analysis is beyond my hand limit. so I moved  the Red shift data stored qvd from UAT to PROD server and then ran the qlikview final dashboard-> so its 45mins now😀

3. Are the files the same size?

Yes

 

Thanks for the suggestions. marked as solution accepted.