topic Re: Testing Load time in QlikView

Testing Load time

renjithpl — Thu, 18 Jul 2013 06:35:18 GMT

Hi All,

I have a question with regards to the load time.

I have assigned a the QVD path using a variable like

let vABC = lookup('File','Description','ABC','QVD_Files');

and then call this variable after "From " statement in the Load.

My question is, will this method takes more load time or Directly giving the source will take more time

regards

ren

Re: Testing Load time

Gysbert_Wassenaar — Thu, 18 Jul 2013 07:00:16 GMT

Theoretically specifying the file name directly will be faster since no calculations are necessary. But unless your QVD_Files table is very large I doubt you'll see any difference.

Re: Testing Load time

renjithpl — Thu, 18 Jul 2013 07:15:00 GMT

Thanks Gysbert,

so basically, we can go ahead with both ways, whichever is convenient right.

Regards

Ren