topic Application Reload Issue in QlikView

Application Reload Issue

Anonymous — Tue, 27 Aug 2013 06:01:14 GMT

Dear All,

I have An Issue in Application which is taking much time to complete the reload near about 20 Hour which is not sufficient,

Please suggest any solution to decrease the reload time.

Regards,

Alok

luciancotea — Tue, 27 Aug 2013 06:04:00 GMT

Could you please provide more information, maybe an example?

Tue, 27 Aug 2013 06:08:45 GMT

share the application

nilesh_gangurde — Tue, 27 Aug 2013 07:00:02 GMT

Dear Alok,

1. I assume that you are taking data from Qvds and not from data base. it will take more time to fetch data from data base.

2. Avoid the joins and lookups and calculations in the application. Do it in the separate extractor and store into consolidated Qvd.

Hope this will help u.

-Nilesh

ashwanin — Tue, 27 Aug 2013 07:06:53 GMT

Hi Alok,

Fetch the data which is required to you I/o of whole data present in QVD or server.

it will reduce your time. Search primary key on which basis you are fetching it , make command on that basis.

e.g if you are taking data on month /year basis then load last few months data or current year data.,

rgds

Ashwani

Anonymous — Tue, 27 Aug 2013 07:14:11 GMT

Dear Nilesh/Ashwani,

Thanks for your Reply,

Yes I am fetching the data from the QVD layer,

And I can Not map the logic during the Extracting the Data because Data is huge and I have been implemented the Incremental Load for that.

And It there Are Nested If statements and lots of Joins Statements are there.

Please Advice for same.

Regards,

Alok

Wed, 04 Sep 2013 10:20:44 GMT

Hello Alok,

Try, restricting the data and then reload it. If it still takes much time then :

1) Either the data model is not efficient.(sync keys etc)

2) Or you do not have sufficient memory space.

When you are reloading, check in the Windows task manager, how much memory is it consuming.

Also you need to debug, and find which join condition is making your reload slow.

Thanks,

ASINGH