QVD calling in to Dashboard

[manoranjan_d]

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 . 

[mfchmielowski]

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]

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 · Accepted solution]

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

[manoranjan_d]

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.