topic Re: Optimize Qlikview Script in QlikView

Optimize Qlikview Script

Anonymous — Wed, 02 Mar 2016 12:02:12 GMT

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

Re: Optimize Qlikview Script

Anonymous — Wed, 02 Mar 2016 12:08:36 GMT

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.

Re: Optimize Qlikview Script

Anonymous — Wed, 02 Mar 2016 12:14:22 GMT

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

Re: Optimize Qlikview Script

Anonymous — Wed, 02 Mar 2016 12:16:26 GMT

Could you share the reload log file ?

Re: Optimize Qlikview Script

Colin-Albert — Wed, 02 Mar 2016 12:19:19 GMT

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.

Re: Optimize Qlikview Script

jonathandienst — Wed, 02 Mar 2016 12:19:26 GMT

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.

Re: Optimize Qlikview Script

Clever_Anjos — Wed, 02 Mar 2016 13:06:51 GMT

Would you mind sharing your script?

Log files would be usefull too

Re: Optimize Qlikview Script

luciancotea — Wed, 02 Mar 2016 13:37:34 GMT

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

Re: Optimize Qlikview Script

Wed, 02 Mar 2016 13:51:28 GMT

Hi,

Are you using optimized QVD Load ?

if not try to use optimized QVD Load.

Re: Optimize Qlikview Script

Anonymous — Wed, 02 Mar 2016 14:38:05 GMT

I meant it consumes 10gb ram reloading the Data

Re: Optimize Qlikview Script

puttemans — Wed, 02 Mar 2016 14:45:03 GMT

If you want to be helped, you need to share the complete built-up of the application (including data lay-out and script functions). The info you gave right now is just not enough.

Re: Optimize Qlikview Script

Anonymous — Wed, 02 Mar 2016 14:47:55 GMT

Im Sorry to all

I checked log files and there was too much info if i disclosed i can get sacked! They are very protective of their data here.

So i had to avoid posting a log file......Thanks all for the help though!

Re: Optimize Qlikview Script

puttemans — Wed, 02 Mar 2016 14:51:34 GMT

Not the data are needed, with a read of the script, some things to improve upon may come up already. Or is it impossible to share the script also?