topic Re: Question regarding load and select statements? in QlikView

Question regarding load and select statements?

chiru_thota — Thu, 25 Sep 2014 18:33:35 GMT

Hi All,

I have 100 columns in table but I need only 3 columns out of them.

Will they be any difference in terms of performance between below two statements ( Select )

(1) Load Column1,Column2,Column3 ;

select Column1,Column2,Column3 from tablename;

(2) Load Column1,Column2,Column3 ;

select * from tablename;

Thanks,

Chiru

ashfaq_haseeb — Thu, 25 Sep 2014 18:40:54 GMT

Hi,

Yes first one will be more optimized.

regards

ASHFAQ

maxgro — Thu, 25 Sep 2014 20:39:45 GMT

the difference is the size of data you transfer from the database server to qlik server (or publisher server)

--> time to transfer, time to load

if you extract N rows from the database

(1) N rows * 3 columns

(2) N rows * 100 columns