Is Reloading of a script after change in the Scripting part does take more time to Reload

[sunil2288]

Hi Every one,

There was an existing Qlikview application with 13 sheets and more than 50 objects...

I have changed the script as per my requirement.

Now when i reloaded the application it fetched all the Qvd's but not yet finishing...

I am wondering the Objects in the application might be taking some more time to Map the New Data ...

How much extent I am correct......Plz do reply

Comments Appreciated..

Regards

Sunil

[martinpohl · Accepted solution]

Hello Sunil

A long response-time after reload seems for a synthetic key.

Debug the script with a few datas, than QV can calculate them quick.

Regards

[sunil2288]

HI Wiseman..

Thanks for ur response..

I ahve already debugged the application with few data..

But This case is of reloading of entire data ...

Still hanged with the same problem.......

Regards

Sunil

[tresesco]

Another possibilty - improper JOIN.

Regards, tresesco

[#5]

Check it your model and make sure it wih out loop (it means you need to follow the fundamentals of joins i.e., if you have 'N' tables make sure it 'N-1' Joins other wise reloading will not finished) this is one possiblity

[sunil2288]

HI Everybody,

I got the answer why it's taking a lot of time to finish the execution....

As i hav echanged the script there are a lot of synthetic keys generating that is y it's taking a lot of time to generate a data cloud in the application...

My Suggestion is:

For a good application in qlikview we have to reduce the occurances of Synthetic keys....

Thank u all

Regards