Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

rgvavihs
Valued Contributor

load and sql select in qlikview

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

1 Solution

Accepted Solutions

Re: load and sql select in qlikview

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.


6 Replies

Re: load and sql select in qlikview

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.


rgvavihs
Valued Contributor

Re: load and sql select in qlikview

Thanks for the reply ! its really helped me

Re: load and sql select in qlikview

Has helped enough to be marked as Helpful ?

mov
Esteemed Contributor III

Re: load and sql select in qlikview

Or a "correct"

Re: load and sql select in qlikview

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

Arjunarao
Honored Contributor II

Re: load and sql select in qlikview

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.