# Export from NetSuite Saved Search to an FTP Server Performance

**URL:** <https://connective.celigo.com/t/export-from-netsuite-saved-search-to-an-ftp-server-performance/216>\
**Category:** Integrator.io\
**Tags:** performance, ftp, export, file-transfer, netsuite\
**Created:** [February 22, 2024, 10:05pm UTC](https://connective.celigo.com/t/export-from-netsuite-saved-search-to-an-ftp-server-performance/216 "2024-02-22T22:05:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![raulbernales](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@raulbernales](https://connective.celigo.com/u/raulbernales)\
**Post date:** [February 22, 2024, 10:05pm UTC](https://connective.celigo.com/t/export-from-netsuite-saved-search-to-an-ftp-server-performance/216/1 "2024-02-22T22:05:55Z")

</div>

Good day. I'm trying to improve the performance of a flow where data source is coming from a NetSuite saved search that produces over 700,000+ rows and the destion tile is to an FTP server. The flow is taking more than 4 hours to transfer the data to the FTP server.

 ![5301043caa20740200000001-11e9e5e4e90f48e1ae090e5558b3dbef.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/bc40d904d7d9d311924fc64c0bdc76b539544f65.png)

I tried increasing the Page size to 10,000 but don't see any huge improvement on the performance.

 ![5301043caa20740200000001-d96a6a8687a5477c862c2e251b1706a2.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/35a5697cd0f5324ceeef287187d63d92d7ce998d.png)

The thing is... It only takes me less than 10 mins if I run the saved search manually in NetSuite; export the result in CSV file; and drop it manually to the FTP server.

Are there any option that we can set to improve the performance? Any advice will be much appreciated.

---

<div class="post-metadata">

**Author:** ![kathyanaqueeman](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kathyanaqueeman/32/9122_2.png) [@kathyanaqueeman](https://connective.celigo.com/u/kathyanaqueeman)\
**Post date:** [February 23, 2024, 3:28pm UTC](https://connective.celigo.com/t/export-from-netsuite-saved-search-to-an-ftp-server-performance/216/2 "2024-02-23T15:28:07Z")

</div>

Hi @raulbernales,

I am moving this post to our [Troubleshoot custom flows](https://connective.celigo.com/c/6) section for more visibility.

Thanks!

---

<div class="post-metadata">

**Author:** ![raulbernales](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@raulbernales](https://connective.celigo.com/u/raulbernales)\
**Post date:** [February 26, 2024, 3:13pm UTC](https://connective.celigo.com/t/export-from-netsuite-saved-search-to-an-ftp-server-performance/216/3 "2024-02-26T15:13:39Z")

</div>

I've tried recreating the flow and used "SuiteApp SuiteScript 2.x" and checked off "Do not store retry data". Result was from 9 hrs down to 6 hrs. This is still not good as I haven't included 5 more currencies.

 ![5301043caa20740200000001-585ce46e68854f809ff49df898d80448.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/2d1dd23f1ce3c8d4cd8421ed220e92968b29f893.png)