Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

balasundaram
Contributor II

Reload time Issue in Incremental Load(Delete)

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?

1 Solution

Accepted Solutions
balasundaram
Contributor II

Re: Reload time Issue in Incremental Load(Delete)

Hi,

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

Regards,

Bala

6 Replies
ankit777
Valued Contributor

Re: Reload time Issue in Incremental Load(Delete)

hi,

Can u share your script?

Highlighted

Re: Reload time Issue in Incremental Load(Delete)

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

balasundaram
Contributor II

Re: Reload time Issue in Incremental Load(Delete)

delete:


inner join

sql load primarykey

from database;

balasundaram
Contributor II

Re: Reload time Issue in Incremental Load(Delete)

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

balasundaram
Contributor II

Re: Reload time Issue in Incremental Load(Delete)

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

balasundaram
Contributor II

Re: Reload time Issue in Incremental Load(Delete)

Hi,

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

Regards,

Bala

Community Browser