Improving Script Performance

Wed, 05 Oct 2011 10:36:12 GMT

Hello,

Looking to inprove the load script within my application, and in particular the below script,

I think its running slower than expected as its checking against a variable for each row (?1),

If there are ANY suggestions on how I could improve this segment please let me know.

Thanks

BR.

LET vToday = num(today());

ControlTemp:

LOAD

id,

Case,

User,

Team,

Date,

[Task 1 Due Date],

[Task 1 Done Date],

[Task 2 Due Date],

[Task 2 Done Date],

[Task 3 Due Date],

[Task 3 Done Date]

From Data.QVD (QVD)

Conversion:

LOAD

'Opportunity' as [Type],

id,

User,

Team,

Date

Resident ControlTemp

WHERE

[Task 1 Due Date] <= $(vToday);

Concatenate

LOAD

'Achieved' as [Type],

id,

User,

Team,

Date

Resident ControlTemp

WHERE

([Task 1 Due Date] <= $(vToday))

AND

([Task 1 Due Date] >= [Task 1 Done Date]);

..... and so on.......

Improving Script Performance

IAMDV — Wed, 05 Oct 2011 10:40:52 GMT

Hi BlockRocker,

Please read the below thread for perfomance optimization.

http://community.qlik.com/message/111454#111454

Good luck!

Cheers - Dv

topic Improving Script Performance in QlikView

Improving Script Performance

Improving Script Performance