https://community.qlik.com/t5/App-Development/load-time-based-on-table-fields/m-p/2520408#M106419 <P>Hi there,</P><P>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.</P><P>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.</P><P>Cheers,</P><P>Oleg Troyansky</P> Fri, 06 Jun 2025 15:03:02 GMT Oleg_Troyansky 2025-06-06T15:03:02Z https://community.qlik.com/t5/App-Development/load-time-based-on-table-fields/m-p/2520401#M106418 <P>If I load a table with 100 million records, would it make any difference in the load time if I load the&nbsp; table&nbsp;</P><P>with 15&nbsp; fields and 10 fields. Basically just want to see if I reduce the number of column would it improve the load&nbsp;</P><P>time? I am sure it improves the response time of the dashboard.</P> Fri, 06 Jun 2025 14:19:49 GMT https://community.qlik.com/t5/App-Development/load-time-based-on-table-fields/m-p/2520401#M106418 jjustingkm 2025-06-06T14:19:49Z https://community.qlik.com/t5/App-Development/load-time-based-on-table-fields/m-p/2520408#M106419 <P>Hi there,</P><P>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.</P><P>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.</P><P>Cheers,</P><P>Oleg Troyansky</P> Fri, 06 Jun 2025 15:03:02 GMT https://community.qlik.com/t5/App-Development/load-time-based-on-table-fields/m-p/2520408#M106419 Oleg_Troyansky 2025-06-06T15:03:02Z