load time based on table fields

[jjustingkm]

If I load a table with 100 million records, would it make any difference in the load time if I load the  table 

with 15  fields and 10 fields. Basically just want to see if I reduce the number of column would it improve the load 

time? I am sure it improves the response time of the dashboard.

[Oleg_Troyansky]

Hi there,

Definitely, the more you limit the volume of data that you are loading, the faster it's going to load and the faster it's going to perform in memory.

If this is a database load, it's more beneficial to limit the load on the database side (in the SQL SELECT statement) rather than in the Qlik Preceding LOAD statement. Your DBA and your network administrators will thank you for that.

Cheers,

Oleg Troyansky