# Best Practices for Optimizing Data Load Performance in Matillion

**URL:** <https://matillioncommunity.discourse.group/t/best-practices-for-optimizing-data-load-performance-in-matillion/1053>\
**Category:** Maia\
**Created:** [August 14, 2023, 8:08am UTC](https://matillioncommunity.discourse.group/t/best-practices-for-optimizing-data-load-performance-in-matillion/1053 "2023-08-14T08:08:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vish234al](https://avatars.discourse-cdn.com/v4/letter/v/779978/32.png) [@vish234al](https://matillioncommunity.discourse.group/u/vish234al)\
**Post date:** [August 14, 2023, 8:08am UTC](https://matillioncommunity.discourse.group/t/best-practices-for-optimizing-data-load-performance-in-matillion/1053/1 "2023-08-14T08:08:21Z")

</div>

I'm working on a data integration project using Matillion, and I'm looking to optimize the performance of my data-loading processes. While I've successfully built and executed ETL pipelines, I've noticed that as the volume of data increases, the load times also seem to be increasing.

&nbsp;

I'm curious to learn about best practices and strategies for improving data load performance in Matillion. Are there any specific techniques you recommend for enhancing the speed of data extraction, transformation, and loading? Are there certain features within Matillion that can be leveraged to fine-tune the process for better performance?

&nbsp;

Additionally, I'm interested in understanding how parallel processing, instance sizing, and resource allocation play a role in optimizing ETL performance. Any insights, examples, or lessons learned from your experiences would be greatly appreciated!

---

<div class="post-metadata">

**Author:** ![PJay](https://avatars.discourse-cdn.com/v4/letter/p/54ee81/32.png) [@PJay](https://matillioncommunity.discourse.group/u/PJay)\
**Post date:** [August 17, 2023, 6:01pm UTC](https://matillioncommunity.discourse.group/t/best-practices-for-optimizing-data-load-performance-in-matillion/1053/2 "2023-08-17T18:01:55Z")

</div>

Hi Vish,

Happy to help. Although it’s logical that more data will take longer to load, with that in mind can you give more detail on:

- where are you loading from?
- where are you loading to?
- how much data are you loading?
- are you doing full or incremental loads?