Optimize Qlikview Script

[Anonymous]

Hi All

I want my reload times to come down

Currently i got something like

End time - start time

In my script not in dashboard

should i use the following?

I wanted by mins

interval(End time-start time,'mm')

Thanks

[Anonymous]

Rather than telling us you have "something like.....", could you share what you actually have.

But in essence if you subtract when it started from when it ended within the Interval() function you should get how long it took.

[Anonymous]

I have this

sum(EndTime - StartTime)	as 1,
sum(EndTime - AnswerTime)	as 2,
sum(WrapUpTime - AnswerTime)	as 3,

but it takes ages to reload like 10 mins based on data so i thought maybe there is a way to speed this up.

It also takes upto 10gb Ram

Is this normal?

Thanks Bill

[Anonymous]

Could you share the reload log file ?

[Colin-Albert]

The reload time will be related to the amount of data you are loading, any joins, any manipulation you are doing to that data and where the data is located - is the data local to the QlikView server or on a remote server.

Can you post your actual load script  that would help identify your actual problem.

In the first instance enable the Generate Logfile option and the log file will show the time that each step in your script is taking.

[jonathandienst]

Do you mean the reload takes too long? Loading 10GB of date in around 10 minutes does not seem so unreasonable to me.

Having said that, you have provided no information that would allow anyone to make useful suggestions, other the most general principles like to only load the fields you actually need.

[Clever_Anjos]

Would you mind sharing your script?

Log files would be usefull too

[luciancotea]

Yes, yes.... share your 10GB file...

[#9]

Hi,

Are you using optimized QVD Load ?

if not try to use optimized QVD Load.

[Anonymous]

I meant it consumes 10gb ram reloading the Data