Application Reload Issue

[Anonymous]

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]

Could you please provide more information, maybe an example?

[#3]

share the application

[nilesh_gangurde]

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]

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]

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

[#7]

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