Discussion Board for collaboration on QlikView Scripting.
I suppose to load all rows from SQLServer table, It's supposed to be ~5 Million Rows.
In the table there are 20 columns, and i need to pull 10 of them.
In a matter only of traffic, and overload on the system what is the efficient way to load:
Load* or load field1,Field2....
From <> ;
This should be the better option as this loads less number of fields. And if you have doubt about optimized load, let me tell you, this still remains optimized.
You can optimize your loading by
(1) Loading your data and save them in a QVDs file
(see QlikView reference manual C:\ProgramData\QlikTech\QlikView Documentation\Reference Manual).
(2) Then loading data from the QVDs.
Using QVDs will increase the performance
If you load fields and data directly from the SQL then you can try some thing like below
1. First opproach
SQL SELECT *
DROP Fields Field10,Field11.....Field20;
2. Second you can try but comment then like //Field10, // //Field11 and so on and you can try a resident load also and then comment the fields on the load.
this is the reason I suggested to extract only the needeed 10 fields in the sql (database)
Thanks all for the approaches..
I'll further my question...
If there is where sentence involved: i.e. WHERE year = 2014
is still select the specific fields instead of select* is the way that cost less in terms of DB traffic?