topic Re: Reload time Issue in Incremental Load(Delete) in QlikView

Reload time Issue in Incremental Load(Delete)

balasundaram — Tue, 09 Jun 2015 08:10:14 GMT

Hi All,

I have used Incremental Load in my extractor QVW's.

For Insert and Update , its fine and also its reduced reload response time.

But if i used for delete purpose , almost its taking full load time.

for this..any one can give any suggestions?

Re: Reload time Issue in Incremental Load(Delete)

ankit777 — Tue, 09 Jun 2015 08:13:39 GMT

hi,

Can u share your script?

Re: Reload time Issue in Incremental Load(Delete)

avinashelite — Tue, 09 Jun 2015 08:14:02 GMT

its hard to tell without seeing the script, check with the linking keys and how your deleting the data ?? may be its taking hard time to find the key and delete it!!

Please paste your script that would to useful for us

Re: Reload time Issue in Incremental Load(Delete)

balasundaram — Tue, 09 Jun 2015 08:16:00 GMT

delete:

inner join

sql load primarykey

from database;

Re: Reload time Issue in Incremental Load(Delete)

balasundaram — Tue, 09 Jun 2015 08:18:01 GMT

have u checked in ur script? For delete purpose how much time its taking if we compare with full load?

Re: Reload time Issue in Incremental Load(Delete)

balasundaram — Tue, 09 Jun 2015 08:18:45 GMT

have u checked in ur script? For delete purpose how much time its taking if we compare with full load?

Re: Reload time Issue in Incremental Load(Delete)

balasundaram — Thu, 13 Aug 2015 05:35:57 GMT

Hi,

As my analysis on incremental Load, If we implemented for Delete purpose it will take full load time.

Regards,

Bala