
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
- Tags:
- new_to_qlikview
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
