topic Re: load and sql select in qlikview in QlikView

load and sql select in qlikview

Anonymous — Sun, 10 May 2015 12:47:10 GMT

Hi All,

I have below script

Case1:

load A,

sql select * from Tablename;

If we load the above script will it decrease the performance of the application .Whats the case if i have millions of data ?

sql select A,B,C from Tablename ;

please clarify me how it is different from first statement.

Let me know whats the best practise

Thanks

Re: load and sql select in qlikview

Anonymous — Sun, 10 May 2015 13:05:28 GMT

sql select * from Tablename;

This will return all the fields in the table from the database, over the network and into QlikView, for QlikView to then ignore all fields except A, B & C.

sql select A,B,C from Tablename ;

This will only return the fields QlikView wants. A, B & C from the database, over the network and into QlikView. This is the better practice.

Re: load and sql select in qlikview

Anonymous — Sun, 10 May 2015 13:18:30 GMT

Thanks for the reply ! its really helped me

Re: load and sql select in qlikview

Anonymous — Sun, 10 May 2015 13:20:25 GMT

Has helped enough to be marked as Helpful ?

Re: load and sql select in qlikview

Anonymous — Sun, 10 May 2015 14:29:53 GMT

Or a "correct"

Re: load and sql select in qlikview

MarcoWedel — Sun, 10 May 2015 20:08:21 GMT

Hi,

maybe you would also like to read these threads:

Performance LOAD; SQL SELECT

https://community.qlik.com/message/1297#1297

hope this helps

regards

Marco

Re: load and sql select in qlikview

qlikviewwizard — Mon, 11 May 2015 02:26:23 GMT

rgvavihs‌,

As we know Qlikview is an In-Memory tool. It is not good bring all the columns into QVD/QVW.

Use the required columns in the load script.