load and sql select in qlikview

[Anonymous]

Hi All,

I have below script

Case1:

load A,

B,

C;

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

[Anonymous · Accepted solution]

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.

[Anonymous]

Thanks for the reply ! its really helped me

[Anonymous]

Has helped enough to be marked as Helpful ?

[Anonymous]

Or a "correct"

[MarcoWedel]

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

[qlikviewwizard]

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.